MySQL Master-Slave synchronization

1. Modify the configuration file

Master server Master:

[Mysqld]
Log-bin=mysql-bin

server-id=222

Modify the slave from the server:

[Mysqld]
Log-bin=mysql-bin
server-id=226

Restart MySQL for both servers

2. Establish an account on the primary server and authorize slave:

GRANT REPLICATION SLAVE on * * to ' son ' @ ' percent ' identified by ' a123456 ';

Show master status;

Remember, file,position.

3. Configure the slave from the server:

Change Master to master_host= ' 192.168.0.113 ', master_user= ' son ', master_password= ' a123456 ', master_log_file= ' Mysql-bin.,000009 ', master_log_pos=240;

4. View results turn on sync

Mysql>start slave;

Mysql> Show Slave Status\g