Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. server-id = 1
  2. binlog_do_db = example
  3. log-bin=mysql-bin
  4. replicate-same-server-id = true
  5.  
  6. slave stop;
  7. 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;
  8. slave start;
  9.  
  10. server-id = 2
  11. binlog_do_db = example
  12. log-bin=mysql-bin
  13. replicate-same-server-id = true
  14.  
  15. slave stop;
  16. 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;
  17. slave start;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement