On 27/07/16 15:39, Phil Stracchino wrote: > >> I strongly recommend you to move to MySQL or Postgresql. Please let us >> know if you really need SQLite. I would say that SQLite in Bacula is >> almost "deprecated". > "Almost"? I thought SQLite support had already been removed, or at > least was unmaintained. >
It is. Sqlite is _only_ there for proof of concept (as in testing if bacula suits your purposes) and should _never_(*) be used in a production environment. (*) As in "you would have to be absolutely and completely crazy to use SQlite in a production environment." If you're backing up 1-2 machines (SOHO) then MySQL is fine. If you are backing up anything larger, then use Postgres or you'll probabl end up regretting it. MySQL runs into major scaling (memory consumption) and tuning issues very quickly, whilst Postgres is self-tuning and tends not to grow as uncontrollably as MySQL does. I run both, they're about as easy as each other to setup but MySQL is significantly harder to keep running when things get complex, large or high-load, rapidly growing to consume far more resources of all kinds than the equivalent Postgresql installation. Don't let anyone try and discourage using Postgres on complexity or "usability" grounds and "I only know mysql" is a path to eternal pain. MySQL was originally designed as a lightweight (compared to Postgresql) system for fast mostly-read work on webservers and it's still firmly rooted there. (It's great for web query engines and that's what we mostly use it for.) ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
