Advertisement
Guest User

Untitled

a guest
Apr 19th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. log-bin = mysql-bin
  2. server-id = 1
  3. binlog_format = MIXED ## or ROW?
  4. enforce-gtid-consistency
  5. gtid-mode=ON
  6. binlog_do_db = foo ## dont know if this is needed?
  7. log-slave-updates ## dont know if this is needed?
  8. relay-log-recovery ## dont know if this is needed?
  9.  
  10. create user 'replicator'@'%' identified by 'xxx';
  11. grant replication slave on *.* to 'replicator'@'%';
  12.  
  13. server_id = 2
  14. log_bin = mysql-bin
  15. binlog_format = MIXED ## or ROW?
  16. skip_slave_start ## is this needed? What if this server becomes master???
  17. gtid_mode = on
  18. enforce_gtid_consistency
  19. log_slave_updates
  20. binlog_do_db = foo ## dont know if this is needed?
  21.  
  22. SQL> CHANGE MASTER TO
  23. MASTER_HOST='master_ip',
  24. MASTER_PORT=3306,
  25. MASTER_USER='slave_user_name',
  26. MASTER_PASSWORD='xxx',
  27. MASTER_AUTO_POSITION=???;
  28.  
  29. SQL> START SLAVE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement