Mysql配置 主从同步（下）

从服务器操作

1.导入数据 mysql -uroot -p < alldb.sql

2.修改配置文件 vim /etc/my.cnf

[mysqld]
server-id=2 #设置server-id，必须唯一

3.重启mysql，配置同步 需要主服务器主机名，登陆凭据，二进制文件的名称和位置 CHANGE MASTER TO MASTER_HOST='182.92.172.80', MASTER_USER='test', MASTER_PASSWORD='123456', MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=73; start slave;

4.查看slave状态： show slave status\G;

1. *************************** 1. row ***************************
2. Slave_IO_State: Waiting for master to send event
3. Master_Host: 182.92.172.80
4. Master_User: rep1
5. Master_Port: 3306
6. Connect_Retry: 60
7. Master_Log_File: mysql-bin.000013
8. Read_Master_Log_Pos: 11662
9. Relay_Log_File: mysqld-relay-bin.000022
10. Relay_Log_Pos: 11765
11. Relay_Master_Log_File: mysql-bin.000013
12. Slave_IO_Running: Yes
13. Slave_SQL_Running: Yes
14. Replicate_Do_DB:
15. Replicate_Ignore_DB:

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

都是yes即可