MySQL Data synchronous backup replication

Setting up MYSQL Data synchronization
MySQL provides database replication functionality after version 3.23.15. The function of two database synchronization, master-slave mode and mutual backup mode can be realized by this feature.
The settings for database synchronization replication are reflected in the MySQL settings file. MySQL's configuration file (typically MY.CNF), in UNIX environments in/etc/mysql/my.cnf or in MySQL user's home directory my.cnf.
　
Window environment, if there is a my.cnf file under the C: root directory, the configuration file is taken. When running MySQL's Winmysqladmin.exe tool, the tool will name the MY.CNF in the C: root directory as Mycnf.bak. and create the My.ini in the Winnt directory. The MySQL server reads this profile when it is started. So you can copy the contents of the MY.CNF to the My.ini file and use the My.ini file as the MySQL server configuration file.
　
To set the method:
Set up the sample environment:
Operating system: window2000 Professional
Mysql:4.0.4-beta-max-nt-log
A ip:10.10.10.22
B ip:10.10.10.53
A: Set
1. To increase the user's most synchronized user account:

GRANT FILE on *.* to backup@ ' 10.10.10.53 ' identified by ' 1234 '

2. Add a database as a synchronization database:

Create DATABASE backup

B: Set
1. To increase the user's most synchronized user account:

GRANT FILE on *.* to backup@ ' 10.10.10.22 ' identified by ' 1234 '

2. Add a database as a synchronization database:

Create DATABASE backup

Master-slave mode: a->b
A is master
Modify a MySQL My.ini file. In the MYSQLD configuration entry, add the following configuration:
server-id=1log-bin# settings require log log can be set log-bin=c:mysqlbakmysqllog the directory of the logging file, #其中mysqllog是日志文件的名称, MySQL will build different extensions, Several log files with file name Mysqllog. Binlog-do-db=backup #指定需要日志的数据库

Restart the database service.
　
Use the Show Master Status command to see the log.
　
b for Slave
Modify the My.ini file for b MySQL. In the MYSQLD configuration entry, add the following configuration:

Server-id=2master-host=10.10.10.22master-user=backup

#同步用户帐号

Master-password=1234master-port=3306master-connect-retry=60