2009/4/28 Attila Fülöp <lichtsc...@gesindel.org>: > Simon Ekstrand wrote: >> 2009/4/23 Attila Fülöp <lichtsc...@gesindel.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
