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