Difference between revisions of "Server backup and restore"
(→Filling disk with null) |
|||
| Line 46: | Line 46: | ||
== Filling disk with null == | == Filling disk with null == | ||
| − | |||
| + | cd /mnt/dump/; sudo dd if=/dev/zero bs=2048 of=/mnt/dump/file1 | ||
| + | Reason: if backup shall be compressed, this will drastically increase compressibility. Danger: watch this with df -h, else it will fill each mount completely, potentially crashing the server. | ||
[[Category:Software documentation]] | [[Category:Software documentation]] | ||
Revision as of 08:33, 18 September 2010
Contents
Strategies
Wikis: Both the media folders and mysql databases need regular backup and validation of restore. We can run a backup to a separate disk, which is mounted at /mnt/dump and mapped; with /var/backups mapped to /mnt/dump/var/backups. Thus writing a backup to /var/backups will end up on this disk.
Backup scripts are currently stored at: /var/backupscripts/
We want a combination of rsync for heavily used resources (especially the media folders or wikis, and other media storage) and versioned, 7-zipped backup (to protect against user-error as well as hardware failure). The versioning schema is planned to be 7 daily versions (cyclically overwritten), 5 weekly ones (cyclically overwritten), 12 monthly ones (cyclically overwritten), yearly ones (not overwritten). That is after the first year, one has 7 + 5 + 12 + years = 24 + yearly copies.
Versioned backup should be /etc and /home weekly, and /var (without backup, mysql db and media folders) daily.
Current MySQL backup
The daily backup of all of mysql databases is performed by the script
/var/backupscripts/mysql_bak_manol.sh
which is executed as cron job at 03:12 every night. The backup files is located in
/mnt/dump/var/backups/mysql/
and is named as:
ttYY-MM-DD_DBNAME.sql.7z
In the script there is a variable DBSKIP that contains names of databases to skip, for example:
DBSKIP="information_schema|otherdb1|otherdb2"
Current MediaWiki media folder backup
The daily backup of media wikis is performed by the script
/var/backupscripts/mediawiki_bak_manol.sh
which is executed as cron job at 03:22 every night.
It rsync files from media dirs of wikis to the corresponding subdir in/mnt/dump/var/backups/wikis/It also makes tar backup with all LocalSetting* in
/mnt/dump/var/backups/wikis/. The name of tars is:
ttYY-MM-DD_settings.tar
Remote backup
The daily remote backup of these dirs:
/mnt/dump/var/backups/wikis/ /mnt/dump/var/backups/mysql/
is performed by the script
/var/backupscripts/remote_bak_manol.sh
It is executed as cron job at 03:33 every night and make rsync of specified dirs to remote server
k2n.bikam.com
Filling disk with null
cd /mnt/dump/; sudo dd if=/dev/zero bs=2048 of=/mnt/dump/file1
Reason: if backup shall be compressed, this will drastically increase compressibility. Danger: watch this with df -h, else it will fill each mount completely, potentially crashing the server.
