Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # for get log file and log pos
- SHOW MASTER STATUS;
- # run on each server
- SLAVE STOP;
- CHANGE
- MASTER TO MASTER_HOST = '%IP%',
- MASTER_USER = '%USER%',
- MASTER_PASSWORD = '%PASSWORD%',
- MASTER_LOG_FILE = 'mysql-bin.%NUM%',
- MASTER_LOG_POS = %NUM%;
- SLAVE START;
- # check status
- SHOW GLOBAL STATUS like 'slave_running';
- SHOW SLAVE STATUS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement