Deploying a highly available database solution in the Amazon EC2 Cloud using MariaDB
How can you create a template for deploying a Highly Available database in the Amazon EC2 Cloud? How can you get redundancy and automated failover, all based on standard Open Source components?
The solution describes how to use Pacemaker and Corosync for control, and how to use Elastic IP address, Elastic Block Storage and EC2 Linux instances in Amazon.
With the template, you can automate the deployment of a database cluster. The solution includes startup synchronisation, automated Pacemaker configuration, MariaDB Master promotion, Elastic IP migration and node maintenance.
The goal of the template is also to produce a system that will allow repeatable and highly automated deployments of a database cluster within the Amazon EC2 Cloud environment.
We look at how to use the security features of Amazon's IAM subsystem to allow automated control using the Pacemaker and Corosync Linux HA tools.