Case Study: Designing a synchronous multi-master cluster for elastic scale-out and scale-in in the cloud
In this talk we present a real customer case that included a challenging Architecture Design and Proof of Concept of using Synchronous Replication in AWS.
The customer had asked to investigate and design an upgrade to their MySQL based solution that supports an application serving retail shops around the globe.
The requirements were to build a highly available MySQL database using only the affordable Medium EC2 instance types.
Using this instance size the system then needed to efficiently scale out and also scale in depending on sales seasons (e.g. Christmas sales).
For the requirements we short listed MySQL NDB Cluster and Galera Cluster for MySQL. We will share our experience and present the benchmark results from the POC:
1) Define real customer requirements
2) Installation and initial setup
3) Applying the customer scenario to solution
4) Scaling out test and required effort
5) Scaling in test and required effort
6) Geographic distribution
7) Numbers and conclusions