Database uptime and resilience is crucial for cloud infrastructure and in this post I'm going to detail a simple but powerful load balanced Percona XtraDB Cluster utilising components from Amazon Web Services.Percona XtraDB Cluster integrates Percona Server with the Galera library of MySQL high availability solutions while AWS delivers a set of services that together form a reliable, scalable, and inexpensive cloud computing platform. Combining both technologies delivers an incredibily robust cloud DB solution.
Let's take a look at the basic schematic. For those familiar with AWS infrastructure design the components will be familiar. For those new to AWS a breakdown of services used with explanations of function and reasons for selection along with expanded design options follows.