tag:blogger.com,1999:blog-5068760857663076184.post4231161883097114407..comments2022-11-11T04:02:54.309-08:00Comments on Krishna's Blog: TEST: Default SchemaKrishna Chandra Prajapatihttp://www.blogger.com/profile/12579520959955659622noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5068760857663076184.post-14177454146536934452011-01-20T14:20:43.639-08:002011-01-20T14:20:43.639-08:00Yes, I agree binlog-ignore-db, binlog-do-db can be...Yes, I agree binlog-ignore-db, binlog-do-db can be problematic in many scenario and lead to break replication. replicate-ignore-tab* along with row based replication would solve some of the problem.Krishna Chandra Prajapatihttps://www.blogger.com/profile/12579520959955659622noreply@blogger.comtag:blogger.com,1999:blog-5068760857663076184.post-57013689084572339022011-01-20T13:08:50.347-08:002011-01-20T13:08:50.347-08:00Sorry, my example was bad.. this is the one you wa...Sorry, my example was bad.. this is the one you want<br />use test;<br />create table a(a1 int);<br />use production;<br />drop table test.a;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5068760857663076184.post-39677058590919089122011-01-20T13:08:03.924-08:002011-01-20T13:08:03.924-08:00Never use binlog-ignore-db, it will cause issues w...Never use binlog-ignore-db, it will cause issues with replication. Assume you have a database called production1, then I run the following:<br /><br />use production1;<br />create table test.a(a1 int);<br />drop table test.a;<br /><br />there goes your replication..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5068760857663076184.post-77401008663684993842011-01-20T10:18:30.952-08:002011-01-20T10:18:30.952-08:00binlog-ignore-db=information_schema
I don't kn...binlog-ignore-db=information_schema<br />I don't know what this is for, as it is nonsense.<br />Nor does it hurt:)erkuleshttp://linsenraum.de/erkulesnoreply@blogger.com