[LRUG] Sites drop off web

[Jay Caines-Gooby]

On 8 August 2011 11:53, Andrew Stewart <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
+44 (0)7956 182625
twitter, skype & aim: jaygooby
gtalk: jaygooby at gmail.com