List: > 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?
It could help to make Postfix scalable. I added memcached support a year or so ago to enable sharing between hosts in the same network. The next step would be to enable sharing between data centers. Wietse > 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. > >