Versions Compared

Old Version 17

changes.mady.by.user Sravanthi N. S. CH.

Saved on

compared with

New Version Current

changes.mady.by.user Ravinder Deolal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Check replication process is running on master and slave
Code Block
titleCommand
collapsetrue
show processlist;
If replication process is running, check if slave is lagging behind master.
Code Block
titleCommand to start collapsetrue
 start master


If replication process is running, check if slave is lagging behind master.
Code Block
titleCheck the statuscollapsetrue
show master status \g; show slave status \g;

...

If replication process has stopped due to duplicate entry in the slave.
Code Block
titleSolutioncollapsetrue
STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; /*This is to skip the duplicate record*/
START SLAVE;

...