Milton, > Has anyone tried multiple Amavisd-new instances storing data in one > mysql database.. I am working on a setup like this and just wanted to > know if it would fly..
Haven't tried, but even with a single amavisd-new instance, each child process accessess the database individually, without coordinating with other child processes first, so this should be no different with multiple instances. > My main concerns are : > 1: is "mail_id" Unique -- and what happens if amavisd-new tries to > store a message in de DB and there's allready a message with that > mail_id Same issue needs to be resoled in a single-instance setup as well, and it is resolved: when mail_id is generated, a record is immediately inserted into a database, and if that fails, a new id is generated (several attempts). > 2. run-time collisions when adding entries to MADDR, Similar. If a record already exists (being simultaneusly inserted by another process), insert fails and the existing record will be used. Mark ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/