In this blog post, we are going to implement load balancer solution for MySQL high availability by integrating it with Keepalived, HAProxy, xinetd software components.
High availability databases use an architecture that is designed to continue to function normally even when there are hardware or network failures within the system.
Why we need this?
Let’s take a scenario were we have MySQL Multi-Master / MASTER-SLAVE replication setup for high availability. In the case of Hardware/Network failure on MASTER, In order to failover to a next available server, we need to manually do the configuration changes for client connections.In this case, downtime is expected since manual failover will take some times. To solve this we can integrate load balancer with MySQL to take care of this manual work and do automatic failover connections.
To avoid such downtimes and for the maximum high …[Read more]