Hi, In the MySQL documentation, it is written that the two versions are compatible to make a replication.
It seems that if I make a DELETE without the 'LIMIT 7500', the query is replicated to the slave. Regards, David. -----Message d'origine----- De : Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Envoyé : mercredi 28 avril 2010 11:15 À : dflore...@legos.fr Cc : mysql@lists.mysql.com Objet : Re: Replication : request DELETE is not executed on slave Hi dflorella, The important thing about mysql replication is same mysql version for both master as well as slave should be used. It should be taken as good practice. You need to check that master and slave are in sync. Is there any error (replication) on the slave server. Check the mode, strict or some thing else. Does the delete command exits in binlog. Regards, Krishna On Wed, Apr 28, 2010 at 2:37 PM, David Florella <dflore...@legos.fr> wrote: > Hi, > > > > I am using MySQL replication : > > > > - The version of the master is 4.1.12-log > > - The version of the slave is 5.0.41 > > > > When I use the query '' DELETE QUICK FROM [TABLE] WHERE [field] < 'xxxxxx' > LIMIT 7500", the query is executed on the master but not on the slave. > > > > Do you know why the request is not executed on the slave? > > > > Regards, > > > > David. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
