<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>I have been having a problem where the Server Backup package will hang while backing up large databases.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>What happens is that I don’t get a backup email and when I check running processes the mysqldump hung during the backup so the rest of the raq-backup script never completes. Sometime I have gone a few days before I noticed and found 3 hung.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I found the solution myself but I wanted to ask Michael Stauber if he could consider adding it to the Server Backup package either as default or as a checkbox option.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The problem seems to occur when backing up large InnoDB tables. I have gotten the mysqldump to complete successfully by adding two options to the file at /usr/sbin/raqbackup.sh<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I add the following to the mysqldump command “--flush-logs” and “-q”<o:p></o:p></p><p class=MsoNormal>so the whole options bit looks like “--all-databases --flush-logs --add-locks -Q -q -f –u”<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The --flush-logs force any logs to be written out. This simply makes sure that the InnoDB state is all caught up from what I understand. It introduces a delay but it has not been bad.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The –q causes the dump to read large tables one row at a time rather than reading and buffering the whole table. Can solve problems on reading large tables.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The other thing I have done, in order to ensure I get good backups is to include the /home/msql folder as an additional folder in the backup, but in order for that to work MariaDB (or MySQL) must be stopped while the folder is backed up. In order to do that I create two script files at:<o:p></o:p></p><p class=MsoNormal>/home/solarspeed/solbackup/server_backup/plugins/pretardirs.sh<o:p></o:p></p><p class=MsoNormal>/home/solarspeed/solbackup/server_backup/plugins/posttardirs.sh<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Each of those does what you would expect from the names. In the pre file I put a command to stop the database server and a short sleep so the database daemon stops. Then the regular folder backup runs and in the post file I simply restart the database server again.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This method causes a tiny bit of downtime but by copying the current state of /home/mysql I am sure to get a workable backup. It might be nice to include the option of a database backup with through a dump file or folder backup within the Server Backup package itself.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I hope this helps someone else.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>______________________________<br>M Aronoff Out <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>