How to skip MySQL replication counter

There are such times when MySQL replication stops when you run certain updates on the master and the slave fails. Like for example you may have run a create table or an alter table on the master and further inserts but these DDLs get skipped and the inserts into these non-existent tables cause the slave to error out and stop.

A simple way out of this is to run the missing DDLs on the slave and push the counter by a step. This is not recommended as this might cause data inconsistency.
…continue reading How to skip MySQL replication counter

Hello world!

My first post for thinkapi.

The idea behind thinkapi is to blog about all the technical things that I come across everyday. A home page for all my thoughts and its processes.

Welcome!