MySQL Replication, the Community Sceptic Roundup
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.
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.