Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- server-id = 1
- binlog_do_db = example
- log-bin=mysql-bin
- replicate-same-server-id = true
- slave stop;
- CHANGE MASTER TO MASTER_HOST = 'IP_OF_SERVER_B', MASTER_USER = 'replicator', MASTER_PASSWORD = 'password', MASTER_LOG_FILE = 'mysql-bin.0000013', MASTER_LOG_POS = 120;
- slave start;
- server-id = 2
- binlog_do_db = example
- log-bin=mysql-bin
- replicate-same-server-id = true
- slave stop;
- CHANGE MASTER TO MASTER_HOST = 'IP_OF_SERVER_A', MASTER_USER = 'replicator', MASTER_PASSWORD = 'password', MASTER_LOG_FILE = 'mysql-bin.0000012', MASTER_LOG_POS = 120;
- slave start;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement