List:General Discussion« Previous MessageNext Message »
From:a.smith Date:November 22 2010 1:03pm
Subject:Re: MySQL replication server
View as plain text  
Hi,

   I think you are wrong, slaves will always accept writes unless you  
set readonly in the mysql config.
Due to this, and if you dont specifically set readonly on the slave  
you have to be very careful in order to maintain data integrity on the  
slave and also not to break repliacton. Tools like Maatkit are  
designed to check data integrity on the slave due to exactly this issue,

thanks Andy.

Quoting John Daisley <daisleyjohn@stripped>:

> You are correct, in a master slave setup the slave does not accept writes.
>
> John
>
> On 22 November 2010 11:06, Machiel Richards <machielr@stripped> wrote:
>




Thread
MySQL replication serverMachiel Richards22 Nov
  • Re: MySQL replication serverJohn Daisley22 Nov
    • Re: MySQL replication servera.smith22 Nov
      • Re: MySQL replication serverMachiel Richards22 Nov
        • Re: MySQL replication servera.smith22 Nov
      • Re: MySQL replication serverJohn Daisley22 Nov
        • Re: MySQL replication serverTyler Poland22 Nov
        • Re: MySQL replication serverJohan De Meersman22 Nov