In this how-to article, we will walk you through the procedures for installing and maintaining a single-site multi-master MySQL cluster solution with load-balancing services. We will be using Percona XtraDB Cluster Server as our base MySQL database platform, as it has all the necessary components and has built-in support for an active/active high availability and high scalability open source solution for MySQL clustering. It integrates Percona Server and Percona XtraBackup with the Galera library of MySQL high availability solutions in a single package, which enables you to create a cost-effective MySQL high availability cluster. We will be using Keepalived to handle the load-balancing.
Percona provides yum and apt repositories for Red Hat/CentOS and Ubuntu/Debian. These repositories include Percona Server, Percona XtraDB, Percona XtraBackup, and Percona Toolkit.