Saturday, 5 March 2016

Add Slave Server If Replication Failed Due To BinLog


service mysqld stop
cd /var/lib/mysql/
mv auto.cnf auto.cnf_bak
vim /etc/my.cnf

service mysqld start

mysql -u root -p'password'

show slave status\G
stop slave;
reset slave;
CHANGE MASTER TO
MASTER_LOG_FILE='mysql-bin.008264',     <<-- Take Own Server Log Bin         
MASTER_LOG_POS=717525205;              <<-- Take Own Server Log Position                           
start slave;

show slave status\G

No comments: