Server Backups
(Created page with "Every day, Cron runs a bash script to backup the MySQL DB & Mediawiki image files to Beaker, from where we rely on Beaker's cloud backup for longer term storage. == The Scrip...") |
No edit summary |
||
| Line 1: | Line 1: | ||
[[Category:IT]] | |||
Every day, Cron runs a bash script to backup the MySQL DB & Mediawiki image files to Beaker, from where we rely on Beaker's cloud backup for longer term storage. | Every day, Cron runs a bash script to backup the MySQL DB & Mediawiki image files to Beaker, from where we rely on Beaker's cloud backup for longer term storage. | ||
Revision as of 11:23, 23 July 2022
Every day, Cron runs a bash script to backup the MySQL DB & Mediawiki image files to Beaker, from where we rely on Beaker's cloud backup for longer term storage.
The Script
The canonical location of the script is /root/backup.sh, there is a symlink from /etc/cron.daily/backup.sh (which is how it runs daily)
Databases
The script loops through the databases (except the system DBs 'information_schema', 'performance_schema' & 'archive'), dumps them in SQL format to a tmpfile, and then compresses that file to /mnt/beaker/IT/MySQL_Backups/[DAY OF THE WEEK]/[DATABASE].sql.bz, providing us with an automated one week backlog
Wiki Uploads
The three live wikis (Crew, Plot & Public) also have their image directories backed up to /mnt/beaker/IT/mediawiki-image-backups/ by rsync as part of the same script.
Flaws
- Errors go to cron-mail, which I'm fairly sure is a black hole
- Working out which is the most recent backup isn't trivial
- Daily cron tasks happen at 17:45, which isn't a great time to slow the DB down.