2009/4/28 Attila Fülöp <lichtscheu AT gesindel DOT org>:
> Simon Ekstrand wrote:
>> 2009/4/23 Attila Fülöp <lichtscheu AT gesindel DOT org>:
>>> Ever thought of using multiple catalogs, eg one catalog for each
>>> client or client group? This should mitigate most of the catalog issues
>>> you have.
>>
>> Yes, we've thought about it. That has it's own set of problem though.
>> One is obviously the trouble of keeping multiple catalog db's around
>> and assigning clients to them, this isn't a big problem but it does
>> add complexity.
>> The other is the extra bconsole overhead of having to know what
>> catalog a client is in to perform certain operations. 'query' is a
>> prime example, or restore, a catalog must be selected before any
>> query/restore commands can be performed. This means you need to check
>> what catalog a client is assigned to for every bconsole command that
>> requires use of the catalog, which feels like it would get old fairly
>> quickly.
>
> Well, currently we are using a single catalog too. But since the
> db size reached 32GB we were thinking of using multiple catalogs.
> By now the db size has reached 44GB (PostgreSQL) and is still
> manageable but certain operations do take a long time.
>
> Regarding the bconsole complexity, we thought about a catalog for
> each client. With a consistent naming scheme like <client>-fd and
> <client>-cat it should be obvious which catalog to use. We have
> relatively few clients but long retention times. YMMV though.

We're pretty much on the other end of the spectrum, many hundreds of
clients but (mostly) relatively short retention times.
Regarding the idea above, is it possible to use the same pool with
several catalogs? I haven't tried it but it seems bacula would be very
confused wrt. the volumes in the pool. We've considered going with one
catalog per sd - which pretty much equates to one catalog per pool for
us. But that would still leave us with the previously mentioned
bconsole issues.

-- 
Simon Ekstrand

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users