Bacula-users

Re: [Bacula-users] Catalog size problem

2008-09-05 10:49:50
Subject: Re: [Bacula-users] Catalog size problem
From: Ryan Novosielski <novosirj AT umdnj DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 05 Sep 2008 10:49:12 -0400
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Foo Bar wrote:
> Hi,
> 
> I noticed that the catalog seems to be the same size as all my
> backups together (~4 GB for 3 test machines), am I correct in
> assuming the actual backups are somehow stored in it and how do I
> check? At the beginning of the file I see a lot of plaintext SQL
> stuff, near the end (probably after I added encryption to backups) a
> lot of binary.
> 
> I suspect something wrong/recursive in my config but not sure where.
> The following relevant (AFAIK at least) entries are in
> bacula-dir.conf:
> 
> # Backup the catalog database (after the nightly save) Job { Name =
> "BackupCatalog" JobDefs = "DefaultJob" Level = Full FileSet="Catalog"
>  Schedule = "WeeklyCycleAfterBackup" ## Pool does not seem to work
> here, needs Client to define it? Pool = Pool_Catalog 
> Client=Catalog-fd RunBeforeJob = "/etc/bacula/make_catalog_backup
> bacula bacula" RunAfterJob  = "/etc/bacula/delete_catalog_backup" 
> Write Bootstrap = "/var/bacula/working/BackupCatalog.bsr" Priority =
> 11                   # run after main backup }
> 
> # Client (File Services) to backup Client { Name = Catalog-fd Address
> = 127.0.0.1 FDPort = 9102 Catalog = XXCatalog Password = "********" 
> File Retention = 30 days Job Retention = 2 months AutoPrune = yes 
> Maximum Concurrent Jobs = 4 }
> 
> Pool { Name = Pool_Catalog Pool Type = Backup Recycle = yes AutoPrune
> = yes Volume Retention = 365 days }
> 
> # Generic catalog service Catalog { Name = XXCatalog dbname = bacula;
> user = bacula; password = "" }
> 
> 
> All the clients have Catalog = XXCatalog lines.
> 
> The /var/bacula/working/BackupCatalog.bsr file has:
> 
> # 05-Sep-2008 01:50:06 - BackupCatalog.2008-09-05_01.50.20 - Full 
> Volume="Vol_Catalog" MediaType="NAS_File" VolSessionId=195 
> VolSessionTime=1214999599 VolFile=0-0 VolBlock=3964139038-3975461727 
> FileIndex=1-1
> 
> Everything is stored on a Samba mounted NAS share.
> 
> If nothing is actually wrong and the catalog is simply huge because
> it's been running for a year or so, how do I keep its size down? This
> will become a major problem when the system goes into production and
> needs to handle a lot more machines.

The "files" portion of the catalog takes up a lot of space. As can the
"messages" if you're sending them to the catalog (which is required for
bweb if you want to see status of backup jobs).

dbcheck might help you here if you have a lot of orphaned
computers/files/etc. in there. Sounds like you must, because none of
your file retention stuff is out of what.

The data is NOT stored in the catalog.

- --
 ---- _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIwUbomb+gadEcsb4RAqJlAKCrX5YEwMDGuQw92FO9YC11+Lg5/gCfUZh9
9eY6z8xZVZ9Uc/xCO/+gcAg=
=24uC
-----END PGP SIGNATURE-----

Attachment: novosirj.vcf
Description: Vcard

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users