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 hen...@scannet.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
