**修改my.cnf** ``` log-bin=mysql-bin //開啟二進制日志 server-id=222 // 保持server-id一致 replicate-db-db=testdb //指定需要復制的db binlog-ignore-db=mysql //忽略的db binlog-ignore-db=information_schema //忽略的db auto-increment-increment=2 //防止主鍵沖突，id + 2 auto-increment-offset=1 ``` 重啟mysql服務 hostA hostB 在hostA上執行 grant replication slave on *.* to dsa@ 'hostB_ip' identified by 'password'; 在 hostB上執行 change master to master_user='dsa',master_password='password',master_host='hostA_ip',master_log_file='',master_log_pos='position';