From: Johan De Meersman Date: November 22 2010 2:36pm Subject: Re: MySQL replication server List-Archive: http://lists.mysql.com/mysql/223632 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0022152d5cbdbd584b0495a52e51 --0022152d5cbdbd584b0495a52e51 Content-Type: text/plain; charset=ISO-8859-1 On Mon, Nov 22, 2010 at 2:08 PM, John Daisley wrote: > The replicated database should not be accepting writes, if it is then you > haven't set it up correctly > *shrug* I never bother. The slave is way too useful to fuck around with optimisations and whatnot, reporting tools tend to do useful aggregations, et cetera. You may like to set it read-only, but that doesn't make it the only way, let a lone a requirement. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0022152d5cbdbd584b0495a52e51--