If we use USE db, then in the code still use db.table, will that able to be replicated?
--- On Wed, 1/6/10, Rick James <rjames@stripped> wrote:
> From: Rick James <rjames@stripped>
> Subject: RE: Don't replicating without USE db;
> To: "Alper Oguz" <alper2@stripped>, replication@stripped
> Date: Wednesday, January 6, 2010, 11:07 AM
> Workaround: issue "USE db"
> before the INSERT.
>
>
> Rick James
> 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;
> >
> > Hello,
> >
> > 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:
> >
> > http://bugs.mysql.com/bug.php?id=37483
> >
> > 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
> > alper2@stripped
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=1
> >
> >
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
>
>
