New Replication Features in MySQL 5.6: Benefits, Limitations, and Challenges
MySQL 5.6 has been out for a few months and it provides a lot of enhancements, specifically with regards to 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.
- Binlog checksums aims at avoiding data corruption.
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.