[asterisk-users] Backing up DB kills RT peers

[Steve Edwards]

On Thu, 8 Aug 2013, Mike Diehl wrote:

> I had a scary thing happen to me when I did my database backup last
> night.  Within seconds of starting the backup script, ALL of my real
> time sip peers disappeared!
>
> I also notice that while the backup is running, my other queries
> block, which is probably why my peers disappear.

Depending on how you are doing the backup, MySQL may lock the entire 
database.

For one of my clients I scripted up a backup procedure that dumped the 
database table by table to reduce the impact.

-- 
Thanks in advance,
-------------------------------------------------------------------------
Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867 PST
Newline                                              Fax: +1-760-731-3000