Copy principle 1. Master writes the data to Binlog. 2. Slave Open two thread I/O thread and SQL thread. 3. The slave I/O thread thread thread attached to master, reading the Binlog file name and Binlog position location on master. 4. Slave receives master's change information through the I/O thread and writes it to the relay log (trunk log). 5. Read the relay log information via SQL thread to replay to slave.
What does replication solve? The individual believes that the primary role of replication is: 1. Backup function, the standby is a backup of the main library. 2. Read and write separation, the main library is responsible for writing operations, from the library to read operations. 3. Use multiple load balancers that can be read from the library. 4. Master-Slave is the foundation of a highly available architecture.
MySQL replication principle and Function analysis (2014-11-10)
