Am Wed, 10 Feb 2010 16:52:54 +0100 schrieb JanJaap Scholing:

> 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?


thoughts:
* take an lvm snapshot and backup the db files directly or
* configure a replicated mysql setup and take the backup on the second 
server or
* use mysqlhotcopy (never used myself) or
* split the catalog in x catalogs to get smaller databases (hmm.. size 
doesnt change but maybe bacula remains usable while backup) or
* there are for sure other ways to do it (like buying a faster server). ;)

- Thomas


------------------------------------------------------------------------------
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