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       [email protected]      Voice: +1-760-468-3867 PST
Newline                                              Fax: +1-760-731-3000

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to