MySQL manual version 5.0.20-MySQL synchronization

6 MySQLSynchronization

The synchronization function is available in MySQL
3.23.15 was introduced. It can copy data from one MySQL server to another. This chapter describes various replication features of MySQL. This section describes the concept of synchronization, how to set the synchronization server, and the reference for available servers. It also provides a series of frequently asked questions, answers, and answers.

"14.6 Replication Statements" describes SQL statement syntaxes related to synchronization.

We recommend that you always visit "http://www.mysql.com" to read the latest in this chapter. The synchronization function has been improving. We often update this manual to the latest content.

6.1 synchronization introduction

MySQL
3.23.15 and later versions support unidirectional synchronization. One server acts as the master server, and one or more servers act as the slave server ). The master server writes the updated content to the binary log (binary
And maintains an index file to record log loops. The updates in these logs are sent to the slave server. After a server load balancer instance is connected to the master, it notifies the master of the log location for the last successful incremental update. Slave will find all the update operations starting from that time, and then block and wait for the master to send new update operations.

If you want to create a synchronization server chain, slave can also be used as a master.

Note: After synchronization is enabled, all update operations to be synchronized must be performed on the master. Otherwise, do not cause conflicts between updates on the master node and those on the slave node.

One-way synchronization provides robust, high-speed, and easy system management:

With the master/slave mechanism, it becomes more stable. When a problem occurs on the master node, you can use slave as a backup switch.