On 4/23/14, 3:24 PM, Wietse Venema wrote:
List:
Are there any plans or existing projects that support connecting Postfix
to a Cassandra cluster to execute CQL queries for table lookups? Or any
other NoSQL databases?
If someone has a plan, then they are welcome to implement it!
For a simple example see util/dict_env.c. For more advanced see
global/dict_ldap.c or dict_mysql.c.
Wietse
If I had the programming chops I would love to contribute. I am
curious, is anyone here even interested in using NoSQL databases for
lookup tables? In our use case we have an email system distributed
between multiple data centers currently using Cassandra to store
stateful information across all the DC's about SASL attempts, failed
logins, sender/recipient counts, etc. for our homegrown policy server.
It would be great to roll all of our user/alias mappings, policy tables,
and other data points to Cassandra to get rid of MySQL master/slave
which is considerably more work to maintain. It seems to us that NoSQL
is a great fit for the kind of key=value looks ups that Postfix and
other MUA's implement, just not sure if anyone else feels the same.