> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Joel Nimety > Sent: Monday, September 11, 2006 2:28 PM > To: [email protected] > Subject: [AMaViS-user] Duplicate mail_id using SQL quarantine > > > Our setup involves a large number of frontend smtp servers > (running postfix-amavis-postfix, spamassassin, av, dns, > mysql,..., etc.). We have just enabled SQL quarantine an all > > Am I missing something, is there logic to deal with duplicate > mail_id that is broken by or mysql2mysql migration scheme? > If there is no such logic how does amavisd guarantee that the > mail_id is unique (even for single server setups). Have > GUID/UUID's been considered? Thanks.
Has anyone tried NDB clusters for amavis/SA and quarantine? Doesn't that 'pretend' to be one big distributed SQL database? Not just an 'after the fact' replacation scheme? That way, the built in sql quarentine routines will attempt to create a non-unique id, fail and create a unique one? I have not tried yet, but with a minimum of three servers (at least two sql servers, with NBD enabled and one 'master/heart beat' server) would it work? ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
