Kirk Hoganson wrote: > I would like to thank everyone for their suggestions. Bacula looks like > a close fit. I don't know how it flew under my radar. My question, for > those using it, would be how do you handle DB backups? MySQL backups > are of the utmost importance here.
hotbackup might be an option ? (too unfamiliar with it to actually give any useful advice, just know that it exists) You might want to have a look at LVM snapshot facility which allows you to take a simple filebased backup of your database because LVM has frozen the state at a point in time. That would assume that you're willing to run your database off a LVM volume ;-) I personally use a scheme for mysql-backup with a dedicated slave for backups in a mysql-replication setup. The slave isn't used for anything but backups. Stop the slave at low traffic and dump everything to local fs, start the slave and resync, move the backup to storage. > How are Bacula users backing up their DB servers? Last time I used bacula it didn't have hot-backup facilities for databases. That was about a year back, so things might have changed. Ramon -- [email protected] mailing list
