Hi all, 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! All of my voicemailboxes, voicemail messages, and sip peers are in a Mysql database. I was able to do a database backup 3 days ago without any incedent. Now suddenly, the whole thing comes crashing down. I also notice that while the backup is running, my other queries block, which is probably why my peers disappear. I'll be posting to the mysql list as well, but has any Asterisk user seen this before? TIA, Mike Diehl.
On 13-08-08 02:08 PM, Mike Diehl wrote:> Hi all, > > 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! >try mysqldump -q instead of just mysqldump. That will send output as its available instead of waiting for mysql to collect it all (which might be the cause of your problem - collecting it all means gathering it all in ram, usually.) -- Looking for (employment|contract) work in the Internet industry, preferably working remotely. Building / Supporting the net since 2400 baud was the hot thing. Ask for a resume! ispbuilder at gmail.com
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