Ticket #88 (closed task: fixed)

Opened 6 years ago

Last modified 5 years ago

MySQL backups going berserk

Reported by: hobu Owned by: sbarnes
Priority: major Milestone:
Component: Systems Admin Keywords:
Cc: hobu@…

Description

Shawn,

MySQL backups are currently at 54gb. Can you investigate?

Howard

Change History

Changed 6 years ago by sbarnes

  • status changed from new to assigned

I've cleaned out some of the backups.

And will change the mysql backup configuration. It was keeping 10 weeks of uncompressed of backups.

I changed the configuration to use gzip to compress the mysql backups

Should we change the time to keep backups to less than 10 weeks

shawn

Changed 6 years ago by sbarnes

  • cc hobu@… added

I just did a massive clean up of the mysql backups, freeing up a significant amount of space.

I've adjusted the crontab of the mysql backup to do a full backup at 3 am only not, every 3 hours. And changed the purge to only keep 5 days of backups. This should keep the mysql backups from eating up all the disk space.

I'll keep this ticket open for awhile for any suggestions on changing the crontab or number of days to keep backups

shawn

Changed 5 years ago by warmerdam

  • status changed from assigned to closed
  • resolution set to fixed

Things seem to be managable now (also see #126).

Closing.

Note: See TracTickets for help on using tickets.