High Availability Database Infrastructure with Galera and HAProxy

Author(s)	J Kevin Terence, Veera Nagaiah Maddikayala
Country	India
Abstract	High Availability (HA) is crucial in the cloud environment to render the services according to the Service Level Agreement (SLA) to the customers. This paper provides an novel solution for 99.99% high availability and scalability of database infrastructures using Galera Cluster, along with HAProxy. The Galera Cluster delivers synchronous multi-master replication over multiple nodes, guaranteed data consistency while in real-time and for each transaction, high availability through automatic failover. HAProxy strikes a balance here by distributing the traffic across nodes and achieving optimal load distribution with less or minor effect on downtime. Real-time monitoring and alerts are also enabled by using Prometheus & Grafana to monitor cluster health as well performance.
Keywords	Galera Cluster, HAProxy, High Availability, Load Balancing, Prometheus, Grafana, Fault Tolerance, Self-Healing Database Systems, virtual IP Failover.
Field	Computer > Data / Information
Published In	Volume 6, Issue 6, November-December 2024
Published On	2024-11-12
DOI	https://doi.org/10.36948/ijfmr.2024.v06i06.30449
Short DOI	https://doi.org/g8qtg7

About IJFMR Fees & Payment Current Issue Publication Archive	Submit Research Paper Track Submission Status Publication Guidelines Publication Ethics Peer Review & Plagiarism	Join as a Reviewer Editors & Reviewers Reviewer Referral Program Get Reviewer Membership Certi.	Website/Journal Policies Usage Policy Content Policies Privacy Policy

Contact Us		+91-9687-828-838	editor@ijfmr.com

International Journal For Multidisciplinary Research