MySQL 5.6 reached GA (General Availability) today and is packed
with a wealth of new features and capabilities.
Exciting stuff!
MySQL 5.6 also introduces the largest set of enhancements to
replication ever delivered in a single release, including: - 5x
higher performance to improve consistency across a cluster and
reduce the risks of data loss in the event of a master failing -
Self-healing clusters with automatic failover and recovery from
outages or planned maintenance - Assured data integrity with
checksums implemented across the replication workflow - DevOps
automation
Of course, getting started with all of these enhancements can be
a challenge - whether you are new to MySQL replication or an
experienced user. So two new Guides are available to help take
advantage of everything replication offers in MySQL 5.6.
MySQL Replication: An
Introduction The introduction takes you through new
5.6 features, including Global Transaction Identifiers (GTIDs),
BinLog Group Commit, Multi-Threaded Slaves, Crash-safe
replication, Checksums, etc. To provide context to these
features, the Introduction Guide takes Developers and DBAs
through the concepts of replication, including:
- Use-cases such as scaling out on commodity hardware, high availability, geo-redundancy for DR and data placement, and supporting complex analytics alongside high velocity OLTP operations in the same cluster
- The replication workflow and internals, discussing the roles of different threads and log files
- Controlling data consistency using different synchronisation models
- Pros and cons of Statement-Based and Row-Based Replication
- Monitoring and managing replication using tools such as the replication dashboard within MySQL Enterprise Monitor
MySQL Replication Tutorial Having learned
the concepts of replication and what's new in MySQL 5.6, the
Tutorial provides step-by-step guides to configuring,
provisioning and managing replication, covering:
- Configuring replication with master and slave .cnf files, creating users, introducing replication to an existing application, initialisation and checking proper operation, using GTIDs and other new features
- Migration to semi-synchronous replication for improved data consistency and reduced risk of data loss
- Administration and configuration by checking slave status, suspending replication and viewing binary logs
- Failover and recovery, including pre-requisites, detecting an
outage, slave promotion, redirecting the application and
recovering a failed master
These new resources provide everything you need to get started in
building your next generation web, cloud, social or mobile
application with the world's most popular open source
database.
You will find more information in the Docs. Also, look out for a live webinar in
March where we will demonstrate all that is new in MySQL 5.6
replication.