Re: [Bacula-users] How to backup the catalog
2010-02-10 12:23:27
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
|
|
|