MySQL mutual Replication

Two hosts

Hostname: linux-web ip: 10.5.5.23

Hostname: linux-mysql ip: 10.5.5.27

Host1: linux-web

Vim/etc/my. cnf

Server-id = 1

Log-bin = master-bin

Master-host = 10.5.5.27 # hostname linux-mysql

Master-user = slave # The account slave in mysql (in linux-mysql) is used for interlinking

Master-password = slave

Replicate-ignore-db = mysql # Do not synchronize mysql database

Replicate-do-db = sync # specify the database to be synchronized

Host2: Same as linux-mysql

Server-id = 2

# Cd/var/lib/mysql

Delete all previous logs

Service mysqld restart # (both restart)