Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

MySQL Replication issues

Recently I had problem mysql replication, i.e. replication seems to be missing in some random occasion. It was clueless and if i test manually all use to work, but some field in some coloum donot get updated.

And i had my.cnf with ignore DB

Ignored DB:

replicate-ignore-db = mysql
replicate-ignore-db = test

While testing manually, all queries seemed to work and i was unable to troubleshoot or narrow down problem area.

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

I was directed to mysqlperformanceblog which pointed me to right track which mentions senario of ignore db and how binlogs are not created and accordingly replication will not take place as slave has got no idea since no binlog is available.

If you wouldl like to read further (http://www.mysqlperformanceblog.com/2009/05/14/why-mysqls-binlog-do-db-option-is-dangerous/)

And it was right feedback from a user in stackoverflow (dba branch).

“It is less error-prone if you use the replicate-wild-* options”

replicate-wild-ignore-table = mysql.*
replicate-wild-ignore-table = test.*

Wanted to share if some of other are getting same problem.