Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Check replication process is running on master and slave

Code Block

title	Command
collapse	true

show processlist;

If replication process is running, check if slave is lagging behind master.

Code Block

title	Command to start
collapse	true

 start master

If replication process is running, check if slave is lagging behind master.

Code Block

title	Check the status
collapse	true

show master status \g; show slave status \g;

Info

Looking at output from above commands, you'd know

if slave is lagging behind master.
replication is failing because of some issues replicating a sql on slave.

If replication process has stopped due to duplicate entry in the slave.

Code Block

title	Solution
collapse	true

STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; /*This is to skip the duplicate record*/
START SLAVE;

...