Async, semi, and sync jump into the rink for your data management. Who wins? The answer depends greatly on many different factors including: * your availability needs * your infrastructure * your technical resources * ease of use * tools *legacy systems In this presentation we look at the maturity and configuration of the different types of replication to show what is involved to support and administer. We will discuss the architectural impact of choosing and using a type of replication for your application. We will look at the impact to the application developer in choosing, supporting or switching types. We will look at the operations and administration impact to evaluate the full cost of supporting different types in your organization. We will review all three type of replication for providing a geographically redundant highly available cloud based application. This is becoming the minimum standard for all applications. This presentation will also discuss the three types of synchronous replication now possible. Galera, MySQL cluster and the labs group replication to define the features and stability of each.
Founder & CEO, EffectiveMySQL
Ronald has over 25 years of professional RDBMS experience in MySQL, Oracle, and Ingres. His expertise covers MySQL, LAMP and cloud-based consulting in architecture, performance, scalability and business continuity. Ronald is a former employee of the MySQL Inc consulting team (06-08) and Oracle Corporation (96-99). He has currently published 4 books on MySQL, his most recent titles available from Oracle Press include Effective MySQL: Optimizing SQL Statements, Effective MySQL: Backup & Recovery and Effective MySQL: Replication Techniques in Depth.