[LRUG] Sites drop off web

Richard Taylor richard at richt.co.uk
Mon Aug 8 04:16:30 PDT 2011


It seems more complicated that it really is when you read the documentation (http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html) but it usually will take you about half to a whole a day if you haven't done it before.

-- 
Richard Taylor


On Monday, 8 August 2011 at 12:08, Andrew Stewart wrote:

> 
> On 8 Aug 2011, at 13:05, Matthew Rudy Jacobs wrote:
> > This may be overkill for you, 
> > But it may kill two birds with one stone. 
> > 
> > - set up a replication to a single slave 
> > - when you want to dump, stop replication 
> > - dump from the slave 
> > - restart after the dump
> > 
> > Thereby you have a hot copy to failover to
> > As well as a mechanism for taking consistent database snapshots 
> > Without affecting the performance of your service. 
> 
> Sounds like a good idea. In hand-wavy terms, is it much of a hassle to set up MySQL replication?
> 
> Cheers,
> Andy
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org (mailto:Chat at lists.lrug.org)
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20110808/075656e9/attachment-0003.html>


More information about the Chat mailing list