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
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.
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.