On 2/10/2010 10:52 AM, JanJaap Scholing wrote:
Hi List,
One question, how to backup the catalog.
We are using MySQL for the bacula catalog. This database is
approximately 46 Gb in size.
When we use the backup script make_catalog_backup (supplied with
bacula) to dump the database, bacula is not usable during the
mysqldump process due to locked tables.
In this case its not possible to make a backup of the catalog every
day. We don’t like a not responding bacula system ;)
My question is how do you make a good backup of the catalog without
interrupting the bacula functionality?
Thanks and regards
Jan Jaap
So you want to back up a database while still being allowed to write to
that database at the same time? It's simply not possible as stated.
Your options, as far as I know, are these:
1) Dump the database, as the Bacula script does, and wait for it to
complete.
2) Flush the tables and copy the database files (if MyISAM), which may
or may not be faster (still must prevent DB writes).
3) Set up a slave database that uses MySQL replication to mirror the
master database. When you want to backup, take the slave offline to do
a dump or copy, leaving the master free to continue working. You will
not back up whatever changes were made since the slave was taken offline.
I haven't messed around with MySQL replication just yet, so I don't know
how easily option 3 will work in practice. But if you don't want Bacula
to be offline while doing a DB backup, that's your only real option.
Even the expensive commercial DBMS's don't have a very good solution to
doing live backups.
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
