Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Xabier Elkano
El 23/01/12 16:28, Uwe Schuerkamp escribió: DB Size: Total clients:107 Total bytes stored: 34.41 TB Total files: 47495362 Database size:31.64 GB Hi Uwe, I am having the same problem, backups are fast, but restores takes too long creating directory tree with bat. I

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Marcello Romani
Il 24/01/2012 10:05, Xabier Elkano ha scritto: El 23/01/12 16:28, Uwe Schuerkamp escribió: DB Size: Total clients: 107 Total bytes stored: 34.41 TB Total files: 47495362 Database size:31.64 GB Hi Uwe, I am having the same problem, backups are fast, but restores

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Xabier Elkano
El 24/01/12 10:49, Marcello Romani escribió: Il 24/01/2012 10:05, Xabier Elkano ha scritto: El 23/01/12 16:28, Uwe Schuerkamp escribió: DB Size: Total clients: 107 Total bytes stored: 34.41 TB Total files:47495362 Database size:31.64 GB Hi Uwe, I am having

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Marcello Romani
Il 24/01/2012 11:18, Xabier Elkano ha scritto: El 24/01/12 10:49, Marcello Romani escribió: Il 24/01/2012 10:05, Xabier Elkano ha scritto: El 23/01/12 16:28, Uwe Schuerkamp escribió: DB Size: Total clients: 107 Total bytes stored: 34.41 TB Total files: 47495362

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Xabier Elkano
El 24/01/12 11:47, Marcello Romani escribió: Il 24/01/2012 11:18, Xabier Elkano ha scritto: El 24/01/12 10:49, Marcello Romani escribió: Il 24/01/2012 10:05, Xabier Elkano ha scritto: El 23/01/12 16:28, Uwe Schuerkamp escribió: DB Size: Total clients:107 Total bytes stored:

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Phil Stracchino
On 01/24/2012 06:21 AM, Xabier Elkano wrote: El 24/01/12 11:47, Marcello Romani escribió: I'm just thinking out loud, but I don't see how having a catalog for each client can help you scale, since you can't put them on different db servers. You'd probably have a higher ROI by upgrading the

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Uwe Schuerkamp
Hi folks, thanks to your hints and ideas the restore times have been reduced from 3-4 hours to about five minutes (building the directory tree, that is). Lesson learnt: Before complaining loudly to the list, make sure your db is in good health by administering a generous dosage of repair table

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Marcello Romani
Il 24/01/2012 12:21, Xabier Elkano ha scritto: [snip] I'm just thinking out loud, but I don't see how having a catalog for each client can help you scale, since you can't put them on different db servers. You'd probably have a higher ROI by upgrading the DBMS hardware and/or migrating to

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Xabier Elkano
El 24/01/12 17:02, Marcello Romani escribió: Il 24/01/2012 12:21, Xabier Elkano ha scritto: [snip] I'm just thinking out loud, but I don't see how having a catalog for each client can help you scale, since you can't put them on different db servers. You'd probably have a higher ROI by

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Marcello Romani
Il 24/01/2012 17:43, Xabier Elkano ha scritto: El 24/01/12 17:02, Marcello Romani escribió: Il 24/01/2012 12:21, Xabier Elkano ha scritto: [snip] I'm just thinking out loud, but I don't see how having a catalog for each client can help you scale, since you can't put them on different db

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread John Drescher
On Tue, Jan 24, 2012 at 12:00 PM, Marcello Romani mrom...@ottotecnica.com wrote: Il 24/01/2012 17:43, Xabier Elkano ha scritto: El 24/01/12 17:02, Marcello Romani escribió: Il 24/01/2012 12:21, Xabier Elkano ha scritto: [snip] I'm just thinking out loud, but I don't see how having a catalog

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-24 Thread Alan Brown
On 24/01/12 17:08, John Drescher wrote: I believe it meant that with bacula prior to 5.2.X you had to compile in your db choice (sqlite, postgresql,mysql) and could not change that choice at runtime. Now with 5.2 You can mix and match and have more than 1 catalog. 1: You can only define one

[Bacula-users] Have we reached bacula's limits?

2012-01-23 Thread Uwe Schuerkamp
Hi folks, we're running four bacula installations, most of them on version 5.0.x compiled from source on CentOS 5.x / 6.x 64bit servers. We're mostly happy with the setup, backups are fast, reliable and generally do not cause us a lot of headaches. Today, a colleague asked me to restore some

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-23 Thread Phil Stracchino
On 01/23/2012 10:28 AM, Uwe Schuerkamp wrote: I've run mysqltuner on the db a couple of times as this isn't the first time we've had problems during a restore, and it looks ok (to my untrained, non-dba eyes anyway): ##

Re: [Bacula-users] Have we reached bacula's limits?

2012-01-23 Thread Alan Brown
1: Make sure you have enough ram in your mysql box (ie, several 10s of Gb) 2: Make sure you tune mysql properly. Most of the supplied config examples are for sub-1Gb memory configuration. 3: Make sure you have the _correct_ indexes built. this is in the bacula knowledgebase. 4: For systems