Usage of MySQL synchronization Tool

The following articles mainly describe how to use the MySQL synchronization tool. If you are interested in the actual operations of the MySQL synchronization tool, you can click to view the following articles. I hope it will help you in this regard.

1. MySQL synchronization tool usage instructions: Install MYSQL, create the required database, and stop all MYSQL servers.

2. Add the following six rows to the my. ini file of MYSQL to be synchronized.

Backup_db indicates the actual database to be synchronized. server-id indicates the server number. The numbers of each server cannot be the same and are arranged in the order of numbers such as 1, 2, 3:

Server-id = 1 # server id.

Log-bin = c: \ mysqlback # Name of the log record file of the synchronization event.

Binlog-do-db = backup_db # database that provides the data synchronization service. Multiple databases are separated by commas. do not end with commas.

Log-slave-updates

Log-warnings

Skip-name-resolve

3. skip this step if you have just created an empty database.

If the database has been used and data exists, perform this step: (manually copy the database of the master server to all the secondary servers to overwrite backuk_db, you can also directly compress the backup_db directory under the mysql data directory And then update it to the secondary server. To ensure that the initial database status is completely consistent .)

4. Open the mysqlsync.exe program, add a record to each MYSQL server, and add their root account password.

5. Start all MYSQL servers.

6. Click start monitoring and press the button to check whether all MYSQL servers can be connected.

7. Go to the automatic settings window and set the MYSQL synchronization mode as needed.

8. MySQL synchronization tool usage instructions: Return to the monitoring window to check whether the synchronization is normal.

When the slave monitoring is normal, the IO description displays "Waiting... ", when data is written," Q ........ "And no error information is displayed in the last error message.

9. Test MySQLSync_Agent on each mysql server and run "Install service. bat" to install a service of MySQLSync_Agent.

10. Configure the MySQLSync_Agent \ config. ini file. Set the basic parameters of MySQLSync_Agent, and then restart the MySQLSync_Agent service:

Server: mysql server

User: mysql user name

Password: mysql password

Port: mysql port number

Agentport: Working Port Number of the controlled end

Backup_db: name of the database to be backed up

Backup_time: Backup interval (in seconds)

Backup_path: Backup relative path

Backup_delete: the number of days before the backup file is deleted.

The above content describes the usage of the MySQL synchronization tool, hoping to help you in this regard.