BTW, same problems occur on the slave side with replicate-do and replicate-ignore. They seem to go away with row-based replications - that's our big hope, anyway. It appears to work so far in test.
On Sat, Mar 7, 2009 at 12:41 PM, Baron Schwartz <ba...@xaprb.com> wrote: > Sure. Set binlog-do-db to "foo" and set up a slave, and then try this: > > create database foo; > create database bar; > use bar; > create table foo.table1(a int); > use foo; > insert into table1(a) values(1); > > Now go to the slave and check replication. It's broken: > > Last_Error: Error 'Table 'foo.table1' doesn't exist' on query. > Default database: 'foo'. Query: 'insert into table1(a) values(1)' > > Why? Because binlog-do-db doesn't do what you think it does. Check > the docs again :) Read this: > http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html and then > this: > http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html#option_mysqld_binlog-do-db > > I won't duplicate the documents here. The docs are clear and > comprehensive. But pay attention to "default database" which is what > changes when you say "use foo" or "use bar". Notice what the default > database is in the error above! > > On Fri, Mar 6, 2009 at 12:08 PM, Atle Veka <at...@flyingcroc.net> wrote: > > Hi, care to elaborate on the pit-falls of binlog-do-db? > > > > > > Thanks, > > Atle > > > > On Wed, 4 Mar 2009, Baron Schwartz wrote: > > > >> No. But I would recommend removing binlog-do-db and using > >> replicate-wild-do-table=<mydb>.% on the slave instead. The > >> binlog-do-db approach has many pitfalls anyway, and is likely to burn > >> you at some point, e.g. get the slave out of sync with the master. > >> The bonus of my suggestion is that you'll be able to see from SHOW > >> SLAVE STATUS what's being replicated. > >> > >> -- > >> Baron Schwartz, Director of Consulting, Percona Inc. > >> Our Blog: http://www.mysqlperformanceblog.com/ > >> Our Services: http://www.percona.com/services.html > >> > >> > > > > > > -- > Baron Schwartz, Director of Consulting, Percona Inc. > Our Blog: http://www.mysqlperformanceblog.com/ > Our Services: http://www.percona.com/services.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
