Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Replication, the Community Sceptic Roundup

MySQL Replication, the Community Sceptic Roundup

 18 April 9:30AM - 12:30PM @ Ballroom E
Experience level: 
Intermediate
Duration: 
3 hours tutorial
Tracks:
Architecture/Design
Scalability/Performance
Topics:
MySQL
Tools and Techniques
Replication

Description

Replication in the last years has been a game of marketing and bragging, where features have been presented as life-changing and highly innovative. Sometimes, these features are really good, and meet the users expectations. Some other times, though, the features are just an item on a completeness list, and it's difficult to understand what is good and what is bad. This tutorial analyses the newest replication features in MySQL and MariaDB, and shows how they work in practice, with the good parts, and especially the bad ones highlighted and explained with examples. The tutorial covers: * Replication monitoring; * Global Transaction Identifiers; * Multi-source replication; * Parallel appliers; * Replication safety. For each feature, there is an explanation of how it is implemented in various flavors and a live demo of the important points. The theme of the tutorial is "how can I be in control of the replication stream if I start using this new feature?" And so we'll see what new advantages and challenges are there when adding GTID to regular replication. And what happens when we also want to add multi-source data streams and parallel appliers. Attendees will learn the basic of monitoring, and how to apply them to all the features mentioned above. They will walk away with an understanding of the features and how well they compare to each other.

Speakers

Giuseppe Maxia's picture

Giuseppe Maxia

Quality Assurance Architect, VMware

Biography:

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.

Share this talk