MySQL Replication : Advanced Features in all flavors

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

Experience level: 
Intermediate
Duration: 
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.


Speakers

QA Director, Continuent
Biography: 
QA Director at Continuent I am active member of the MySQL community and long timer open source enthusiast. During the past 25 years I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C , French, Spanish, Java. I work in cyberspace, with a virtual team.

Slides