BBahmni 한국어 매뉴얼검색홈
한국어 번역 완료
한국어English

MySQL Replication Problems

Check replication process is running on master and slave
Command
show processlist;
If replication process is running, check if slave is lagging behind master.
Command to start
start master
If replication process is running, check if slave is lagging behind master.
Check the status
show master status \g; show slave status \g;
If replication process has stopped due to duplicate entry in the slave.
Solution
STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; /*This is to skip the duplicate record*/
START SLAVE;
원문 정보

Bahmni Wiki · CC BY-SA 4.0

원문 보기 ↗