Master
创建用户:
GRANT REPLICATION SLAVE ON *.* TO 'userx'@'server_b' IDENTIFIED BY 'xxxxx';
导出数据:
mysqldump --all-databases --master-data > dbdump.sql
导致的 dbdump.sql 里会包含 binlog 的位置.
Slave
CHANGE MASTER TO MASTER_HOST='server_a'; CHANGE MASTER TO MASTER_USER='userx'; CHANGE MASTER TO MASTER_PASSWORD='xxxxx'; CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=106; start slave; show slave status\G