Russel,
Supporting proprietary DBs would be nice, but you're
given THREE free choices for storing your catalog -
SQLite, Postgres, and MySQL - and two are mature,
capable DBs. I personally use MySQL and it works very
well. I don't speak on Kern's behalf, but it would
take more work (and testing and documentation and
upgrade migration scripts... it goes on) to support
relatively few users.
How big is your catalog? Take in consideration
Bacula's typical workload on the DB: lots of inserts,
no concurrency, no transactions. MySQL w/ InnoDB does
the job nicely, and you can run it on the same server
as Bacula.
Of course, you can fetch the sources, implement your
desired DB back end, and then submit patches. But if
your catalog size doesn't justify the extra work, go
for MySQL w/ InnoDB. Regards,
Georger
--- Russell Howe <[EMAIL PROTECTED]> escreveu:
> I didn't see a feature request on the site for extra
> database support,
> so here goes:
>
> Origin: Russell Howe <[EMAIL PROTECTED]>
> Date: 26 July 2006
>
> What: It would be nice for the database backend to
> support more
> databases. I'm thinking of SQL Server at the moment,
> but I guess Oracle,
> DB2, MaxDB, etc are all candidates. SQL Server would
> presumably be
> implemented using FreeTDS or maybe an ODBC library?
>
> Why: We only really have one database server,
> which is MS SQL Server
> 2000. Maintaining a second one for the backup
> software (we grew out of
> SQLite, which I liked, but which didn't work so well
> with our database
> size). We don't really have a machine with the
> resources to run
> postgres, and would rather only maintain a single
> DBMS. We're stuck with
> SQL Server because pretty much all the company's
> custom applications
> (written by consultants) are locked into SQL Server
> 2000. I can imagine
> this scenario is fairly common, and it would be nice
> to use the existing
> properly specced database server for storing
> Bacula's catalog, rather
> than having to run a second DBMS.
>
> I haven't seen Bacula's database routines, but it
> seems like it's fairly
> modular and so I'm guessing that adding another
> database wouldn't be too
> much work. What would be involved?
>
> --
> Russell Howe
> [EMAIL PROTECTED]
_______________________________________________________
Você quer respostas para suas perguntas? Ou você sabe muito e quer compartilhar
seu conhecimento? Experimente o Yahoo! Respostas !
http://br.answers.yahoo.com/
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
