List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:November 22 2010 1:06pm
Subject:Re: MySQL replication server
View as plain text  
My reason for asking this is the following....


The client have database A on one machine, Database B on a second
machine both of which are production.

They want to setup replication of Database B to Server hosting Database
A and still keep Server A as the primary production system.





-----Original Message-----
From: a.smith@stripped
To: John Daisley <daisleyjohn@stripped>
Cc: Machiel Richards <machielr@stripped>, mysql mailing list
<mysql@stripped>
Subject: Re: MySQL replication server
Date: Mon, 22 Nov 2010 13:03:38 +0000


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