Hello,
we do daily fullbackups for our database backups and currently I use software compression. The reason behind this is that I do disk2disk2tape and I want 2 weeks of backups readily on disk for fast restore.
Four our databases we do the following (we have around 500 gig of DB Backup data each day):
The database servers backup their databases locally.
-> Each time a database has finished backup it's backup to the local drive, we copy it over the backup server
-> After all databases of a server have been backed up locally and copied to the backup server we launch a bacula job
-> Older backups (2-3 days, depends) are deleted from the local backup
The bacula job then:
-> figures out all the database files backed up in the last 20 hours
-> backs them up to disk with software compression on (I get around 82% compression ratio)
-> deletes source backups which are older than 2 days from the backup server
In the morning, all the backup jobs get copied to tape for. We rotate daily tapes 2 weeks and Weekly tapes 10 weeks.
Now, for databases that leaves me:
2-3 days worth of uncompressed backups on the database server itself (easy and fastest restore)
2 days worth of uncompressed backups on the backup server (fast restore in case DB server died horribly)
14 days worth of compressed backups on the backup servers disk (slow restore, but conviniently on disk)
10 weeks worth of weekly compressed backups on the tapes (slowest restore, but at least you can have data from way back)
It does suit our needs nicely but creating the compressed software backups costs a lot of time, it would go way faster if I just did hardware compression on the tapes, but then I would have the problem with local diskspace. keeping 14 days of uncompressed data amounts to about 7 Terrabyte versus the roughly 140 Gig's I get from the (avg. 82%) compression.
How do you handle big database backups? Is it worth storing uncompressed? Is the hardware compression *actually* better? Do I waste space on tape? Would saving this space on tape be worth all the space problems I would get on disks?
thank you,
best regard,
Rai
