Nagios Support Forum

Hi,
I have a Nagios server which is built for backup purposes. When the primary server goes down, we have automation in place that will bring up the secondary backup server. We are seeing issues with /store/backups/mysql/daily/nagios , /store/backups/mysql/weekly/nagios file systems getting full with mysql backups. We don't see this behavior on the other nagios servers we have. How can i stop mysql service from creating backups when server is not running. Backups are being created on other nagios servers also, but we never saw any storage issues on the above mentioned file systems. This is the df -h output on the nagios server.

[nagios@nagios]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/macysvg-lv_root
4.8G 1.8G 2.8G 39% /
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda1 477M 105M 348M 24% /boot
/dev/mapper/macysvg-lv_home
4.8G 521M 4.1G 12% /home
/dev/mapper/macysvg-lv_opt
3.9G 1.6G 2.1G 43% /opt
tmpfs 8.0G 171M 7.9G 3% /tmp
/dev/mapper/macysvg-lv_usr
3.9G 2.8G 898M 76% /usr
/dev/mapper/macysvg-lv_var
49G 6.4G 40G 14% /var
/dev/mapper/macysdd-lv_archive
50G 82M 47G 1% /archive
/dev/mapper/macysdd-lv_usrlocal
99G 36G 59G 38% /usr/local
/dev/mapper/macysdd-lv_www
50G 32G 15G 69% /www

[nagios@nagios]$ ls -l /store/backups/mysql/daily/nagios
total 2421520
-rw-r--r-- 1 root root 1481753079 Oct 7 07:00 nagios_2018-10-07_07h00m.Sunday.sql
-rw-r--r-- 1 root root 142557184 Oct 8 07:00 nagios_2018-10-08_07h00m.Monday.sql
-rw-r--r-- 1 root root 142685582 Oct 16 07:00 nagios_2018-10-16_07h00m.Tuesday.sql.gz
-rw-r--r-- 1 root root 142595448 Oct 17 07:00 nagios_2018-10-17_07h00m.Wednesday.sql.gz
-rw-r--r-- 1 root root 142589908 Oct 18 07:00 nagios_2018-10-18_07h00m.Thursday.sql.gz
-rw-r--r-- 1 root root 142546294 Oct 19 07:00 nagios_2018-10-19_07h00m.Friday.sql.gz
-rw-r--r-- 1 root root 142522559 Oct 21 07:00 nagios_2018-10-21_07h00m.Sunday.sql.gz
-rw-r--r-- 1 root root 142365059 Oct 22 07:00 nagios_2018-10-22_07h00m.Monday.sql.gz

We have the same 4 GB allocated for '/' FS on all the servers but only the backup server i mentioned seem to be having issues. Temporarily we are moving the backup files to other FS to free up the space on '/'. Please help!

Thanks!

Hi @vy3734,

Looks like you have scheduled backups enabled for the backup XI server. Have you compared the backup server settings to the settings on the primary server?

You can enable/disable/configure scheduled backup settings in Admin >System Backups > Scheduled Backups. There is also a setting to limit the number of backups on the server.

Let me know if your able to resolve the issue.