Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: John Daisley (daisleyjohngooglemail.com)
Date: Mon Nov 22 2010 - 07:08:03 CST
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:
> 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.
>> On 22 November 2010 11:06, Machiel Richards <machielrrdc.co.za> wrote:
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621