By Mat Keep on Sep 21, 2012
Following on from my post about MySQL Cluster sessions at the forthcoming Connect conference, its now the turn of MySQL Replication - another technology at the heart of scaling and high availability for MySQL.
Unless you've only just returned from a 6-month alien abduction, you will know that MySQL 5.6 includes the largest set of replication enhancements ever packaged into a single new release:
- Global Transaction IDs + HA utilities for self-healing cluster..(yes both automatic failover and manual switchover available!)
- Crash-safe slaves and binlog
- Binlog Group Commit and Multi-Threaded Slaves for high performance
- Replication Event Checksums and Time-Delayed replication
- and many more
There are a number of sessions dedicated to learn more about these important new enhancements, delivered by the same engineers who developed them. Here is a summary
Saturday 29th, 13.00
Replication Tips and Tricks, Mats Kindahl
In this session, the developers of MySQL Replication present a bag of useful tips and tricks related to the MySQL 5.5 GA and MySQL 5.6 development milestone releases, including multisource replication, using logs for auditing, handling filtering, examining the binary log, using relay slaves, splitting the replication stream, and handling failover.
Saturday 29th, 17.30
This session showcases the new replication features, including
• High performance (group commit, multithreaded slave)
• High availability (crash-safe slaves, failover utilities)
• Flexibility and usability (global transaction identifiers, annotated row-based replication [RBR])
• Data integrity (event checksums)
Saturday 29th, 1900
In this session, the MySQL Replication engineers discuss all the goodies, including global transaction identifiers (GTIDs) with autofailover; multithreaded, crash-safe slaves; checksums; and more. The team discusses the design behind these enhancements and how to get started with them. You will get the opportunity to present your feedback on how these can be further enhanced and can share any additional replication requirements you have to further scale your critical MySQL-based workloads.
Sunday 30th, 10.15
Hands-On Lab, MySQL Replication, Luis Soares and Sven Sandberg
But how do you get started, how does it work, and what are the best practices and tools? During this hands-on lab, you will learn how to get started with replication, how it works, architecture, replication prerequisites, setting up a simple topology, and advanced replication configurations. The session also covers some of the new features in the MySQL 5.6 development milestone releases.
Sunday 30th, 13.15
Hands-On Lab, MySQL Utilities, Chuck Bell
Would you like to learn how to more effectively manage a host of MySQL servers and manage high-availability features such as replication? This hands-on lab addresses these areas and more. Participants will get familiar with all of the MySQL utilities, using each of them with a variety of options to configure and manage MySQL servers.
Sunday 30th, 14.45
Eliminating Downtime with MySQL Replication, Luis Soares
The presentation takes a deep dive into new replication features such as global transaction identifiers and crash-safe slaves. It also showcases a range of Python utilities that, combined with the Release 5.6 feature set, results in a self-healing data infrastructure. By the end of the session, attendees will be familiar with the new high-availability features in the whole MySQL 5.6 release and how to make use of them to protect and grow their business.
Sunday 30th, 17.45
In a Replication topology, high performance directly translates into improving read consistency from slaves and reducing the risk of data loss if a master fails. MySQL 5.6 introduces several new replication features to enhance performance. In this session, you will learn about these new features, how they work, and how you can leverage them in your applications. In addition, you will learn about some other best practices that can be used to improve performance.
So how can you make sure you don't miss out - the good news is that registration is still open ;-)
And just to whet your appetite, listen to the On-Demand webinar that presents an overview of MySQL 5.6 Replication.