Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SHOW MASTER STATUS;
- Copied the values of MASTER_LOG_FILE and MASTER_LOG_POS.
- STOP SLAVE;
- RESET SLAVE;
- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98; (<- example values)
- START SLAVE;
- SHOW SLAVE STATUS G;
- Slave_IO_State Waiting for master to send event
- Master_Host xxx.xxx.xxx.xxx
- Master_User repl
- Master_Port 3306
- Connect_Retry 60
- Master_Log_File mysql-bin.000006
- Read_Master_Log_Pos 787956776
- Relay_Log_File mysql-relay-bin.000004
- Relay_Log_Pos 624412
- Relay_Master_Log_File mysql-bin.000006
- Slave_IO_Running Yes
- Slave_SQL_Running Yes
- Replicate_Do_DB
- Replicate_Ignore_DB
- Replicate_Do_Table
- Replicate_Ignore_Table
- Replicate_Wild_Do_Table
- Replicate_Wild_Ignore_Table
- Last_Errno 0
- Last_Error
- Skip_Counter 0
- Exec_Master_Log_Pos 787956776
- Relay_Log_Space 788197
- Until_Condition None
- Until_Log_File
- Until_Log_Pos 0
- Master_SSL_Allowed No
- Master_SSL_CA_File
- Master_SSL_CA_Path
- Master_SSL_Cert
- Master_SSL_Cipher
- Master_SSL_Key
- Seconds_Behind_Master 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement