lecture: New replication features in MySQL 5.6

Event_large

Global transaction identifiers, multi-threaded slaves, crash-safe replication are some of the interesting replication-related features of MySQL 5.6. They promise a lot of improvements regarding flexibility, performance and robustness. Is the reality so nice? Learn in this session how to use these features and where the limitations are.

MySQL 5.6 has been out for a few months and it provides a lot of enhancements, specifically regarding replication. Global transaction identifiers offer an efficient way to deal with the hassles of maintaining a replication topology when a master crashes, multi-threaded replication is a nice solution to overcome the performance limitations of the regular single-threaded replication, crash-safe replication provides new configuration to make replication more resilient in case of a crash, and the new MySQL utilities are new tools alleviating some tedious tasks of the DBAs.

This session aims at exploring these new features. You will learn which problems they are likely to solve and how they can improve the performance or the resilience of your application. We will also discuss their limitations and the challenges you may face while trying to implement them. Demos will be shown to illustrate both the strengths and weaknesses of all features.