MySQL Database Configuration master/slave server implementation dual-machine Hot Standby instance tutorial

Website: bbs.justin.com: Web Server 10.15.72.73 above database: MySQL Server 10.15.72.177 above purpose: Add a MySQL Backup Server (10.15.72.136) as MySQL

Website: bbs.justin.com: Web Server 10.15.72.73 above database: MySQL Server 10.15.72.177 above purpose: Add a MySQL Backup Server (10.15.72.136) as MySQL

Groupadd mysql #4. perform the following operations on the client Windows 7 (10.15.72.74) (The bbs.justin.com domain name must be resolved to the Web server 10.15.72.73 in advance). The following program installation interface is displayed: Hong Kong server, start installation-agree to the agreement, Hong Kong virtual host, next step

Host ='

Show tables; # view the justindb table structure. A new table named test is displayed, indicating that the database is synchronized successfully.

At this point, the MySQL database configuration master/slave server has completed the dual-machine Hot Standby instance tutorial.

This article is from the "justin" blog. Be sure to keep this source

, Hong Kong VM