2012/1/11 Honia A <honia2...@hotmail.com>:
> I'm backing up a handful number of Unix boxes, they all get backed up very
> quickly but we can't access them due to the BackupCatalog job being very
> slow. When I read online, I see people said it's because of the database
> size getting larger and larger.
>
> I cancel the backup catalog job and all the servers become accessible. This
> is the configuration for catalog:
>
>
> # This is the backup of the catalog
> FileSet {
> Name = "Catalog"
> Include {
> Options {
> signature = MD5
> }
> File = "/var/lib/bacula/bacula.sql"
> }
> }
>
There is really nothing you can do with the bacula config files to change that.
>
> All backups finish around 5 AM but all the servers remain inaccessible until
> 8:30 or so. The last job running is that backup job so I thought the process
> getting slower and slower everyday might have something to do with the size
> of th ebacula.sql file.
>
>
You really need to tune your mysql database / filesystem the db is on.
My database is ~39GB and the catalog job takes less than 10 minutes to
complete. Although I am using postgres instead of mysql both databases
should be tuned in a lot of cases since the defaults are very low for
for a modern machine with 8GB+ of ram.
John
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
