The Ultimate Guide to High Availability with MariaDB

Comments - Replication : Restart After Out of Sync Master/Slave

5 years, 9 months ago stuart tom
Re: Replication : Restart After Out of Sync Master/Slave

Thank you ! Ok, I think I got it. In order to restart, I believe this is my command on the slave: 

stop slave;
CHANGE MASTER TO MASTER_HOST = 'master_host',
MASTER_USER = 'user',
MASTER_PASSWORD = 'password',
MASTER_PORT = 3306,
MASTER_LOG_FILE =  [Relay_Master_Log_File],
MASTER_LOG_POS= [Exec_Master_Log_Pos]
MASTER_CONNECT_RETRY=0;
start slave;

Where the LOG_FILE and LOG_POS are key to restarting where it left off ?

Again, thanks !

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.