MySQL5.6同步白皮书

MySQL Replication enables users to cost - effecti vely deliver application performance, scalability and high availability. Many of the world's most trafficked web properties like eBay, Facebook, Tumblr, Twitter and YouTube rely on MySQL Replication to elastically scale- out beyond the capacity constraints of a single instance, enabling them to serve hundreds of millions of users and handle exponential growth. By mirroring data between instances, MySQL replication is also the most common approach to delivering High Availability (HA) for MySQL databases. In addition, the MySQL replication utilities can automatically detect and recover from failures, allowing users to maintain service in the event of outages or planned maintenance. With the release of MySQL 5.6, a number of enhancements have been made to M ySQL Replication, delivering higher levels of data integrity, performance, automation and application flexibility. We will discuss these enhancements in the whitepaper. We will also explore the business and technical advantages of deploying MySQL Replic ation and describe the fundamental enabling technology behind replication . This paper concludes by outlining the major differences when using replication with the MySQL Cluster database. A companion white paper (MySQL 5.6 Replication – Tutorial 1 ) provides a simple step - by- step guide on how to install and configure a master/slave topology, as well as handle failover events . It demonstrates how to do this using Global Transaction Identifiers (GTIDs) as well as the extra steps needed when taking the more traditional approach.