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.sm...@ukgrid.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 <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: >> >> > > > > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk