Yes this is the same issue I've reported previously. Unless literally 'select' the database, the query is never written to the binary log.
----- Original Message ----- From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 12, 2003 12:38 PM Subject: Replication bug? > I think I have found a replication bug. We are using Mysql-Max 3.23.53 > in a master and multiple slave situation. That is working fine. We are > using InnoDB > > We have found a workaround to the problem but I thought you should know > about it. > > We have 2 databases on the system call them dba and dbb. > > If I have a connection to dba and and then run the following query the > update happens on the master but not on the slaves!!! > > replace into dbb.tablename set field='somevalue' ... > > The key to the problem is not the replace into, but the fact that we are > connected to one database and working on another. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php