[LRUG] Sites drop off web

Richard Taylor richard at richt.co.uk
Mon Aug 8 04:01:19 PDT 2011


 If your database is large enough that this is a problem it is usually better to run your dump off a slave rather than the master. 

-- 
Richard Taylor


On Monday, 8 August 2011 at 11:57, Jay Caines-Gooby wrote:

> On 8 August 2011 11:53, Andrew Stewart <boss at airbladesoftware.com (mailto:boss at airbladesoftware.com)> wrote:
> > Tim,
> > 
> > > I had a similar problem with CentOS. mysqldump was stalling everything for a couple of minutes when it ran.
> > > 
> > > Saw some pretty epic query times popping up in NewRelic RPM around that time. The site just stalled for a few minutes.
> > > 
> > > Pingdom reported a minute or two of downtime.
> > 
> > Thanks for the information. I use mysqldump too -- with increasing reluctance because I've been seeing the
> > same behaviour as you. As a stopgap measure I wrapped it in a timeout[1] but I think the real solution is to
> > move to Postgres and whatever backup mechanism it has.
> 
> You can also use the --single-transaction option to mysqldump which
> prevents it from locking up your app.
> 
> 
> -- 
> Jay Caines-Gooby
> http://jay.gooby.org
> jay at gooby.org (mailto:jay at gooby.org)
> +44 (0)7956 182625
> twitter, skype & aim: jaygooby
> gtalk: jaygooby at gmail.com (mailto:jaygooby at gmail.com)
> _______________________________________________
> 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/2a4b992a/attachment.html>


More information about the Chat mailing list