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.
To: John Daisley <daisleyjohn@stripped>
Cc: Machiel Richards <machielr@stripped>, mysql mailing list
Subject: Re: MySQL replication server
Date: Mon, 22 Nov 2010 13:03:38 +0000
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,
Quoting John Daisley <daisleyjohn@stripped>:
> You are correct, in a master slave setup the slave does not accept writes.
> On 22 November 2010 11:06, Machiel Richards <machielr@stripped> wrote: