Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Replication latest features: the community sceptic roundup

Replication latest features: the community sceptic roundup

 26 April - 11:10 AM - 12:00 PM @ Ballroom A
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Topics:
MySQL
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 talk 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 talk covers: * Replication monitoring; * Global Transaction Identifiers; * Multi-source replication; * Parallel appliers; * Group replication; * 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 talk 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