From: John Daisley (daisleyjohngooglemail.com)
Date: Mon Nov 22 2010 - 07:08:03 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

The replicated database should not be accepting writes, if it is then you
haven't set it up correctly

On 22 November 2010 13:03, <a.smithukgrid.net> wrote:

> 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 <daisleyjohngooglemail.com>:
>
> You are correct, in a master slave setup the slave does not accept writes.
>>
>> John
>>
>> On 22 November 2010 11:06, Machiel Richards <machielrrdc.co.za> wrote:
>>
>>
>
>
>
>

--
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisleybutterflysystems.co.uk

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]