MySQL personal theory of master-slave synchronization

Initiating a request from the database to the primary database

Primary database validation request, if authentication is passed, turn on I/O thread

Sending bits files from a database to the primary database

The primary database matches the value of the bits move file that originated from the database and matches the value of its own bits move file.

If the value of the binary file is smaller than the primary database

Notifications to update synchronized data from the database

After the data has been updated from the database, go to sleep mode

To change the database data to the primary database, turn on I/O thread, send the binary log to the database

After the log is received from the database, enter the operating mode, open the SQL thread, and update the data to the primary database

After the data is updated, go to sleep mode

MySQL personal theory of master-slave synchronization