Hi,

On 02/10/10 04:52 PM, 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.

Are you using MyISAM or InnoDB ? Backup procedures can vary according to 
the MySQL storage engine being used.

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

For MyISAM I would either deploy filesystem snapshots or replication to 
another server for backups of large MySQL databases.

InnoDB is generally more suited for hot backups -  google should be able 
to provide you with both commercial and / or open source solutions for 
that.

We use filesystem snapshots for MySQL backup (both MyISAM & InnoDB) and 
it works very well.


> Thanks and regards
>
> Jan Jaap
>
>
> ------------------------------------------------------------------------
> Ontdek nu Windows phone. De smartphone van dit moment
> <http://www.microsoft.com/windowsmobile/nl-nl/default.mspx>


-- 
Med venlig hilsen / Best Regards

Henrik Johansen
henrik AT scannet DOT dk
Tlf. 75 53 35 00

ScanNet Group
A/S ScanNet

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