> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:amavis-user- > [EMAIL PROTECTED] On Behalf Of Robert Schetterer > Sent: Friday, March 16, 2007 7:28 AM > To: Michael Storz > Cc: [email protected] > Subject: Re: [AMaViS-user] Somewhat OT: Postgrey vs. SQLGrey > > Michael Storz schrieb: > > On Thu, 15 Mar 2007, Danita Zanre wrote: > > > >> Any opinions about these two? I've been using postgrey for awhile, > and > >> I like it, but I also like the idea of using mysql so that I can > perhaps > >> get info out of the database if I want. Any opinions as to which > would > >> be faster, etc.? > >> > >> Thanks. > >> > >> Danita > >> > > > > We run Sqlgrey and are happy with it. I can't say if it's faster than > > postgrey because we never ran postgrey. Yesterday, at the last DDOS > like > > attack of a spammer, we processed 243 triplets per second. Uptodate > > hardware would be 2.5 faster, as our tests showed. > > > > For MySQL we use 2 dedicated server with master-master-replication > and > > heartbeat for failover (www.linux-ha.org). > > > > Michael Storz > > -- > > ====================================================== > > Leibniz-Rechenzentrum | <mailto:[EMAIL PROTECTED]> > > Boltzmannstr. 1 | Fax: +49 89 35831-9700 > > 85748 Garching / Germany | Tel: +49 89 35831-8840 > > ====================================================== > > > > --------------------------------------------------------------------- > ---- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > > opinions on IT & business topics through brief surveys-and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD > EV > > _______________________________________________ > > 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/ > > > I run, postgrey with 1000 users at the largest setup and > on back mx with high traffic, no problems so far since one year, > ( i have no setup with sqlgrey, but i never heard something evil about > it ) > sqlgrey may give the users the choice to choose their > whitelist by their own, after all we do only greylist > in a selective way for dynamic ips ( this lows down whitelisting ), i > would recommend > sqlgrey for realy big mail sites as i think mysql behaves more nice for > high traffic than file based > > -- > Mit freundlichen Gruessen > Best Regards > > Robert Schetterer > > https://www.schetterer.org > Munich/Bavaria/Germany > > > ----------------------------------------------------------------------- > -- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD > EV > _______________________________________________ > 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/
We run sqlgrey. I have two front end MX servers. The primary reason for sqlgrey is to have a single repository for the grey listing data. Then a sending domain does not have wait multiple times depending on which MX font end server it is currently connected to. We receive 1 million messages a day, and sqlgrey has no problem handling the load. I have had a couple of instances where a sqlgrey table got corrupted. I'm not sure why. But the fix was easy. I just stopped sqlgrey, deleted the tables, restarted sqlgrey. Sqlgrey recreates the tables and continues working. Since I have not been able to re-create the corruption event, I have not been able to troubleshoot the problem. I have done some tuning on the MySQL database configuration, using the my-huge.cnf config file. And since then I have not had an sqlgrey corruption problem. Ed ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ 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/
