Re: [Bacula-users] How to backup the catalog
2010-02-10 11:22:33
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|