--On Thursday, April 16, 2015 6:39 PM +0200 Mark Martinec
<[email protected]> wrote:
If some database is needed, currently SpamAssassin can use a couple
of them, from file-based (e.g. BerkeleyDB), to SQL, LDAP, Redis.
Btw, Quanah Gibson-Mount (from Zimbra) is a strong advocate for trying
the LMDB (http://symas.com/mdb/), which recently also can be used by a
Postfix mailer, so it may be worth considering when an in-memory database
(such as Redis or Memcache) may not suffice.
It's used by many things these days. ;)
This list is a little bit out of date, but has a fairly good list of things:
<http://symas.com/mdb/#projects>
Some databases (like SQL or Redis) offer server-side code execution
(stored procedures, or LUA in Redis), which can significantly reduce
the number of round-trip query/response accesses to a database, which
can be valuable for performance.
The issue I encounter most these days is needing to support databases at a
cluster level, so there is no per-host database. So things like Redis
(already mentioned), MariaDB Galera, etc, are useful to keep in mind.
We're trying to get Zimbra to the point where there is no single point of
failure anywhere in our setup.
--Quanah
--
Quanah Gibson-Mount
Platform Architect
Zimbra, Inc.
--------------------
Zimbra :: the leader in open source messaging and collaboration
