Saturday, November 22, 2014

New MySQL 5.6 Replication Features

There is a long list of new replication features in the latest MySQL 5.6 release including:

  • Binary log group commit
  • Multi-threaded slaves
  • Crash-save slaves
  • Global Transaction Identifier (GTID)
  • Replication checksums
  • Optimized row-based replication
  • Time-delayed replication
  • Remote binary log backup
  • UUID

This presentation from the MySQL Tech Tour events in New York and Boston provides an overview and syntax examples of many of these features. The Effective MySQL: Replication Techniques in Depth also discusses many of these features in detail. Chapter 3 is available for FREE download.