High Availability Database Infrastructure with Galera and HAProxy

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.