Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- server-id=1
- log-bin="mysql-bin"
- binlog-do-db=replicatietest
- replicate-do-db=replicatietest
- relay-log="mysql-relay-log"
- auto-increment-increment = 2
- auto-increment-offset = 1
- CREATE USER 'replicator'@'%' IDENTIFIED BY 'Slave123';
- GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%' IDENTIFIED BY 'Slave123';
- SHOW MASTER STATUS;
- --> mysql-bin.000003 397 replicatietest
- STOP SLAVE;
- 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;
- START SLAVE;
- --> OK
- server-id=2
- log-bin="mysql-bin"
- binlog-do-db=replicatietest
- replicate-do-db=replicatietest
- relay-log="mysql-relay-log"
- auto-increment-increment = 2
- auto-increment-offset = 2
- CREATE USER 'replicator'@'%' IDENTIFIED BY 'Slave123';
- GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%' IDENTIFIED BY 'Slave123';
- SHOW MASTER STATUS;
- --> mysql-bin.000001 154 replicatietest
- STOP SLAVE;
- 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;
- START SLAVE;
- --> OK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement