Workaround: issue "USE db" before the INSERT.
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Alper Oguz [mailto:alper2@stripped]
> Sent: Wednesday, January 06, 2010 6:15 AM
> To: replication@stripped
> Subject: Don't replicating without USE db;
> I've two Mysql 5 servers that work on master-master
> replication. Both are
> Mysql 5.0.51a on Debian 5 machines.
> I've discover this issue on my system:
> Our developers sometimes use queries like INSERT INTO
> db.table... and these
> rows aren't replicated to the second server.
> There is a suggestion to remove binlog-do-db lines from
> my.cnf end of that bug
> entry. (I know, this is not a bug)
> But how to work replication without binary logs? Could you
> please inform me?
> thank you
> Alper Oguz
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: