List:Replication« Previous MessageNext Message »
From:Mats Kindahl Date:October 31 2011 6:52am
Subject:Re: Master-Master -> duplicate entry
View as plain text  
On 10/28/2011 05:50 PM, Rick James wrote:
> Anyone happen to understand how (or if) DETERMINISTIC in Stored
> Programs interacts with Replication?

Either DETERMINISTIC, NO SQL, or READS SQL is required (for stored
functions) to be possible to log the creation of the function to the
binary log, but does not really "mean" anything except that. There is no
checking that the function supplied really is deterministic (or does not
contain any SQL or only read SQL).

Just my few cents,
Mats Kindahl

>
> On 10/28/11 12:03 AM, Johan De Meersman wrote:
>> ----- Original Message -----
>>> From: "Rick James"<rjames@stripped>
>>>
>>> The potential flaw in semi-sync is that it acks once the data gets to
>>> the relay log; it does not wait for the write to be applied to the
>>> table.  Granted, it would take two serious crashes to cause loss of a
>>> write.
>> Correct, thank you :-)
>>
>> It amazes me how many people run replication, but how little is
>> actually understood about it :-)
>>
>> MySQL's semi-synchronous feature is not that a quorum of slaves
>> confirms the update (as Cassandra does, like Marcus points out); it
>> is semi-synchronous because the slave must acknowledge that it has
>> _received_ the update (ie, written to the relay log), whereas a fully
>> synchronous replication requires that the slave acknowledges that it
>> has _applied_ the update.
>>
>> When the master writes statements to the binary log, most
>> non-deterministic expressions (autoincrement, now(), ...) get
>> replaced by the actual values that were applied; thus ensuring that
>> the slave does indeed apply exactly the same data. Not *all* of those
>> get translated, though - a typical example being "insert as select"
>> where the select has no explicit ordering - and those cases, if you
>> have them, can be accomodated by using row-based replication instead
>> of statement-based. Look at the documentation before making a
>> decision :-)
>>
>>
>>
>>
>
Thread
Master-Master -> duplicate entryRicardo Freitas26 Oct
  • Re: Master-Master -> duplicate entrynavid@navid.it26 Oct
    • Re: Master-Master -> duplicate entryRicardo26 Oct
  • Re: Master-Master -> duplicate entryRick James27 Oct
    • Re: Master-Master -> duplicate entryRicardo27 Oct
      • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
        • Re: Master-Master -> duplicate entryJohan De Meersman27 Oct
          • Re: Master-Master -> duplicate entryRicardo27 Oct
          • Re: Master-Master -> duplicate entryRicardo27 Oct
          • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
            • RE: Master-Master -> duplicate entryRicardo Freitas27 Oct
              • Re: Master-Master -> duplicate entrynavid@navid.it27 Oct
              • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
                • RE: Master-Master -> duplicate entryRicardo Freitas27 Oct
                  • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
                    • RE: Master-Master -> duplicate entryRicardo Freitas27 Oct
                    • Re: Master-Master -> duplicate entryRicardo27 Oct
                      • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
                        • RE: Master-Master -> duplicate entryRicardo Freitas27 Oct
                          • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
                            • Re: Master-Master -> duplicate entry (UUID lecture)Rick James27 Oct
            • Re: Master-Master -> duplicate entryJohan De Meersman28 Oct
        • Re: Master-Master -> duplicate entryRicardo27 Oct
  • Re: Master-Master -> duplicate entrylist27 Oct
    • RE: Master-Master -> duplicate entryRicardo Freitas27 Oct
      • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
        • Re: Master-Master -> duplicate entryMySQL)27 Oct
    • Re: Master-Master -> duplicate entryRick James27 Oct
      • Re: Master-Master -> duplicate entryMarcus Bointon27 Oct
        • Re: Master-Master -> duplicate entryRick James27 Oct
          • Re: Master-Master -> duplicate entryJohan De Meersman28 Oct
            • Re: Master-Master -> duplicate entryRick James28 Oct
              • Re: Master-Master -> duplicate entryMats Kindahl31 Oct
      • Re: Master-Master -> duplicate entrylist27 Oct