CASE STUDY: DESIGNING A SYNCHRONOUS MULTI-MASTER CLUSTER FOR ELASTIC SCALE-OUT AND SCALE-IN IN THE CLOUD

Database Administration
12 November 1:50pm - 2:40pm @ Orchard 1
Experience level: 
Intermediate
Duration: 
50 minutes conference
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


Speakers

Manager, Consulting Rapid Response 24/7 Team, Percona
Biography: 
Marco Tusa had his own international practice for the past twenty seven years. His experience and expertise are in a wide variety of information technology and information management fields of application and cover research, development, analysis, quality control, project management and team management. Marco has move to Percona as manager of the Consulting Rapid Response Team on October 2013. Marco Tusa has moved from Italy to Ottawa in 2011 and had being working at Pythian as Cluster Technical Leader for the MySQL technology until September 2013. He has being working as employee for the SUN Microsystems as MySQL Professional Service manager for South Europe., and previously in MySQL AB. He has worked with the Food and Agriculture Organization of the United Nation since 1994, leading the development of the Organization’s hyper textual environment.Team leader for the FAO corporate database support.