On Wed, 2005-06-15 at 08:41 -0700, [EMAIL PROTECTED] wrote: > Arvinn Løkkebakken wrote: > > [EMAIL PROTECTED] wrote: > >> I'm running two SpamAssassin servers with enough traffic that > >> file-based Bayes was becoming a bottleneck. I installed MySQL on > >> both and they each maintain their own independent database. > >> > >> > > What's the point of running independenet databases? When there was > > news about SA supporting SQL for storing Bayes and AWL my first > > thought was: finally a proper way to have multiple spamd servers > > sharing the same data. This was good news! I always didn't like the > > fact that two different spamd servers working the same mail stream, > > but with seperate databases, would create different scores. > > Matter of taste, I suppose... I like the redundancy of having two independent > servers. If one goes down, the other won't know or care, and will continue > handling mail (albeit twice as much mail as it would otherwise handle.)
I would love the ability to split reads and writes ... it would mean that each MTA could run a local MySQL database, replicated from a master. Writes to the master over TCP, reads from local slave over UNIX socket... Mike -- | Mike Grice Broadband Solutions for | Systems Engineer Home & Business @ | PlusNet plc. www.plus.net + ----- PlusNet - The smarter way to broadband ------
