On 5/17/2013 6:45 AM, Benny Pedersen wrote:
Marc Perkel skrev den 2013-05-17 06:12:
Yeah - I'm running global too. Not per user.
why do you have 7 servers and only one mysql server ? :)
well to get more performance out of mysql one need to use clustered
backends aswell, so to get most performance it would make sense to
read from all mysql servers (read only) but on update (write only) to
master mysql server that will replicate to other mysql servers that
can be readed from, is your servers doing more writes then it reads
then its spamassassin optimizing needed, not backends
mysql is memory hungry btw, here i use mysqltuner with good results,
if mysql is failing change to postgres cluster
I have a dedicated SQL server with 32 gigs of ram so I have the
resources to handle it.
--
Marc Perkel - Sales/Support
supp...@junkemailfilter.com
http://www.junkemailfilter.com
Junk Email Filter dot com
415-992-3400
