List:General Discussion« Previous MessageNext Message »
From:David Florella Date:April 28 2010 4:30pm
Subject:RE: Replication : request DELETE is not executed on slave
View as plain text  
Hi, 

Thanks to you and everyone. 

I will test the same request with the ORDER BY clause. 

Regards, 

David. 

-----Message d'origine-----
De : Mattia Merzi [mailto:mattia.merzi@stripped] 
Envoyé : mercredi 28 avril 2010 17:54
À : mysql@stripped
Objet : Re: Replication : request DELETE is not executed on slave

AFAIR you can use LIMIT with replication only if you use row-based
replication (or mixed), that means that you must use mysql 5.1.

Greetings,

Mattia.


2010/4/28 Tom Worster <fsb@stripped>:
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
> statements is not guaranteed, since the order of the rows affected is not
> defined. Such statements can be replicated correctly only if they also
> contain an ORDER BY clause.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Replication : request DELETE is not executed on slaveDavid Florella28 Apr
  • Re: Replication : request DELETE is not executed on slaveKrishna Chandra Prajapati28 Apr
    • RE: Replication : request DELETE is not executed on slaveDavid Florella28 Apr
      • RE: Replication : request DELETE is not executed on slaveJerry Schwartz28 Apr
        • Re: Replication : request DELETE is not executed on slaveTom Worster28 Apr
          • Re: Replication : request DELETE is not executed on slaveMattia Merzi28 Apr
            • RE: Replication : request DELETE is not executed on slaveDavid Florella28 Apr
              • Re: Replication : request DELETE is not executed on slaveTom Worster28 Apr