Page 1 of 1

Managing Daily, Weekly, Monthly Mysql backups

Posted: Mon Jul 27, 2015 1:28 pm
by JakeHatMacys
I've got about 16gb's to work with in my '/' directory on this server... and it's all I'm getting.

I've got the following space allocated for MySQL backups alone:

Code: Select all

[root@esuxxxxx mysql]#  du -csh monthly
771M    monthly
771M    total
[root@esuxxxxx mysql]#  du -csh weekly
2.0G    weekly
2.0G    total
[root@esuxxxx mysql]#  du -csh daily
4.7G    daily
4.7G    total
[root@esuxxxx mysql]#
So my question is can I turn off the daily SQL back ups and do you think that's a big deal? This has to have been an out of the box setting but I'm not seeing where it's set. Any advice? Is monthly & weekly general sufficient?

Re: Managing Daily, Weekly, Monthly Mysql backups

Posted: Mon Jul 27, 2015 1:45 pm
by lmiltchev
If you run scheduled backups or backup your Nagios XI instance manually on a regular basis, I don't think turning off daily (even weekly & monthly) sql backups is a big deal. The nagios xi backups contain the mysql and postgresql backups. You can view what's in the *.tar.gz file by running:

Code: Select all

tar -tvf /store/backups/nagiosxi/<backup>.tar.gz
The sql backups are run on a cron:

Code: Select all

grep auto /etc/cron.d/nagiosxi
You can disable these jobs or make them run less frequently. If you know what you are doing, you can also modify the "/root/scripts/automysqlbackup" and/or the "/root/scripts/autopostgresqlbackup" script.

Hope this helps.