- 记下查询结果的bin文件和坐标 (确保两个实例的uuid不要一样, 如果一样修改data / auto.cnf文件的server_uuid, 重启实例)登陆slave的mysql执行CHANGE MASTER TO MASTER_HOST = '192.168.14.115',
- MASTER_USER = 'rep116',
- MASTER_PASSWORD = 'rep116',
- MASTER_LOG_FILE = 'mysql_bin.000001',
- MASTER_LOG_POS = 1497;
- Start slave;
来源: http://www.bubuko.com/infodetail-1984085.html