Advertisement
Guest User

Untitled

a guest
Oct 26th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. server-id=1
  2. log-bin="mysql-bin"
  3. binlog-do-db=replicatietest
  4. replicate-do-db=replicatietest
  5. relay-log="mysql-relay-log"
  6. auto-increment-increment = 2
  7. auto-increment-offset = 1
  8.  
  9. CREATE USER 'replicator'@'%' IDENTIFIED BY 'Slave123';
  10. GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%' IDENTIFIED BY 'Slave123';
  11. SHOW MASTER STATUS;
  12. --> mysql-bin.000003 397 replicatietest
  13. STOP SLAVE;
  14. CHANGE MASTER TO MASTER_HOST = 'Server A IP Address', MASTER_USER = 'replicator', MASTER_PASSWORD = 'Slave123', MASTER_LOG_FILE = 'mysql-bin.000003', MASTER_LOG_POS = 397;
  15. START SLAVE;
  16. --> OK
  17.  
  18. server-id=2
  19. log-bin="mysql-bin"
  20. binlog-do-db=replicatietest
  21. replicate-do-db=replicatietest
  22. relay-log="mysql-relay-log"
  23. auto-increment-increment = 2
  24. auto-increment-offset = 2
  25.  
  26. CREATE USER 'replicator'@'%' IDENTIFIED BY 'Slave123';
  27. GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%' IDENTIFIED BY 'Slave123';
  28. SHOW MASTER STATUS;
  29. --> mysql-bin.000001 154 replicatietest
  30. STOP SLAVE;
  31. CHANGE MASTER TO MASTER_HOST = 'Server B IP Address', MASTER_USER = 'replicator', MASTER_PASSWORD = 'Slave123', MASTER_LOG_FILE = 'mysql-bin.000001', MASTER_LOG_POS = 154;
  32. START SLAVE;
  33. --> OK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement