Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- log-bin = mysql-bin
- server-id = 1
- binlog_format = MIXED ## or ROW?
- enforce-gtid-consistency
- gtid-mode=ON
- binlog_do_db = foo ## dont know if this is needed?
- log-slave-updates ## dont know if this is needed?
- relay-log-recovery ## dont know if this is needed?
- create user 'replicator'@'%' identified by 'xxx';
- grant replication slave on *.* to 'replicator'@'%';
- server_id = 2
- log_bin = mysql-bin
- binlog_format = MIXED ## or ROW?
- skip_slave_start ## is this needed? What if this server becomes master???
- gtid_mode = on
- enforce_gtid_consistency
- log_slave_updates
- binlog_do_db = foo ## dont know if this is needed?
- SQL> CHANGE MASTER TO
- MASTER_HOST='master_ip',
- MASTER_PORT=3306,
- MASTER_USER='slave_user_name',
- MASTER_PASSWORD='xxx',
- MASTER_AUTO_POSITION=???;
- SQL> START SLAVE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement