Knowledgebase
MYSQL Slave Synchronization
mysql -hlocalhost -uroot -pv0lkswagon -e "show slave statusG" | grep -P '(Seconds_Behind)|(Running)' -i
stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;
stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;
Post Date: 2015-01-30 13:13:42 · Tags: Knowledgebase,