Mike Ruskai wrote:
> 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.
>
If you use Postgresql, you could put database in backup mode for hot 
backup = http://www.postgresql.org/docs/8.1/static/backup-online.html.

Regards,

Heitor Faria
www.bacula.com.br

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