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.sm...@ukgrid.net To: John Daisley <daisleyj...@googlemail.com> Cc: Machiel Richards <machi...@rdc.co.za>, mysql mailing list <mysql@lists.mysql.com> 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 <daisleyj...@googlemail.com>: > You are correct, in a master slave setup the slave does not accept writes. > > John > > On 22 November 2010 11:06, Machiel Richards <machi...@rdc.co.za> wrote: >