Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- auto-increment-increment = 2
- auto-increment-offset = 1
- auto-increment-increment = 2
- auto-increment-offset = 2
- Server 1:
- mysql>
- RESET MASTER;
- # First time only:
- #GRANT REPLICATE SLAVE ON *.* TO 'replicate'@192.168.2.7 IDENTIFIED BY '[password_redacted]';
- #FLUSH PRIVILEGES;
- FLUSH TABLES WITH READ LOCK;
- SHOW MASTER STATUS;
- bash#
- mysqldump -u root -p -ceQRE --hex-blob --triggers --opt --single-transaction --comments --dump-date --no-autocommit --all-databases -r /root/master.sql
- scp -P 5934 /root/master.sql root@192.168.2.7:.
- mysql>
- UNLOCK TABLES;
- Server 2:
- mysql>
- STOP SLAVE;
- bash#
- mysql -u root -p < /root/master.sql
- mysql>
- # First time only:
- #GRANT REPLICATE SLAVE ON *.* TO 'replicate'@192.168.2.6 IDENTIFIED BY '[password_redacted]';
- #FLUSH PRIVILEGES;
- RESET SLAVE;
- CHANGE MASTER TO MASTER_HOST='192.168.2.6', MASTER_USER='replicate', MASTER_PASSWORD='[password_redacted]', MASTER_LOG_FILE='ibm.000001', MASTER_LOG_POS=28556380;
- START SLAVE;
- SHOW SLAVE STATUSG
- Server 1:
- mysql>
- STOP SLAVE;
- CHANGE MASTER TO MASTER_HOST='192.168.2.7', MASTER_USER='replicate', MASTER_PASSWORD='[password_redacted]', MASTER_LOG_FILE='ibm.000004', MASTER_LOG_POS=121875;
- CHANGE REPLICATION FILTER REPLICATE_DO_DB = (reminderdental2), REPLICATE_IGNORE_DB = (mysql);
- START SLAVE;
- Slave SQL for channel '': Slave failed to initialize relay log info structure from the repository, Error_code: 1872
- ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
Add Comment
Please, Sign In to add comment