mysql双机热备（MySQL hot standby）.doc

mysql双机热备（MySQL hot standby） F9B MySQL data synchronization mainly in three ways: 1. by using MySQLs own database synchronization function 2. using the characteristics of the MySQL database (database solution directory, and stored in the file), the database directory synchronization to achieve data synchronization to 3. using MySQL database synchronization software for 1., the use of MySQL own database synchronization function (refer to the following article from the Internet, written in great detail) MySQL provides database replication capabilities from the 3.23.15 version. With this function, two database synchronization, master slave mode and backup mode can be realized The settings for the database synchronization replication feature are shown in the MySQL settings file. MySQL configuration file (usually f), in UNIX environment, in /etc/mysql/f, or in the home directory of the MySQL user, f. In the windows environment, if you have f files under the c: root directory, take the configuration file. When running the winmysqladmin.exe tool for MySQL, the tool names the f in the c: root directory as mycnf.bak. And create my.ini in the WinNT directory. This configuration file is read by the MySQL server when it is started. So you can copy the contents of the f into the my.ini file and use the my.ini file as the configuration file for the MySQL server. Setting method: Setting example environment: (net banned characters per day) as a system: window2000professional Mysql:4.0.4-beta-max-nt-log Aip:2 Bip:3 A: settings 1. add a users most synchronized user account: GRANTFILEON*.*TObackup@3IDENTIFIEDBY 1234 2. add a database as a synchronous database: Createdatabasebackup B: settings 1. add a users most synchronized user account: GRANTFILEON*.*TObackup@2IDENTIFIEDBY 1234 2. add a database as a synchronous database: Createdatabasebackup Master-slave mode: A-B A is master Modify the Amysql my.ini file. In the mysqld configuration entry, add the following configuration: Server-i