MySQL Replication : Advanced Features in all flavors

1 April 9:30AM - 12:30PM @ Ballroom C

Experience level: 
3 hours tutorial
Starting with MySQL 5.6, and continuing with MariaDB 10.0 and MySQL 5.7, there has been a rush of new replication features: * Parallel replication * Global Transaction Identifiers * Multi source replication * Crash safe tables. How good are these features? And how well can be used? This talk compares the main replication features offered by MySQL 5.6 and 5.7, MariaDB, and Tungsten, showing for each what each feature does, how well it works, and how it integrates with the rest of the features set. In particular, we will focus on the following: * Replication monitoring basics. This section explains the nuances of database replication, exposing what components exist or (may exist), and what they mean for a DBA. We will talk stages, tasks, streams, shards, positions and identifiers) * Monitoring operations, or how to get the gist of what your servers are doing; * Practical monitoring for all the flavors being examined. Most of the features under scrutiny are all detectable by monitoring. When we focus on monitoring, we see how well the features work. The purpose of this talk is to give a fair comparison of all the new features in replication available in modern servers, so that attendees can decide what to adopt.


Quality Assurance Architect, VMware
Quality Assurance Architect at VMware. Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle. Then at Continuent, Inc and currently at VMware through a merge. I am active member of the MySQL community and long timer open source enthusiast. During the past decades I have worked in various IT related fields, with focus on databases, object oriented programming, system administration, quality assurance. Fluent in Italian, English, Perl, Python, SQL, Spanish, C, Bash, and good speaker of C , French, Java. I work in cyberspace, with a virtual team.