Ronan, Yes it can/has been done and it works flawlessly. We currently have 4 front end SA processing machines that tie into a single MySQL cluster (running HA with DRBD mirroring for failover).
Basically you just need to point your SA's on each machine to the MySQL database. Here is mine: auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:spamassassin:10.0.0.99 user_awl_sql_username youruser user_awl_sql_password yourpassword bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:spamassassin:10.0.0.99 bayes_sql_username youruser bayes_sql_password yourpassword Also, there has been much talk regarding the replication of MySQL and using slaves/masters. This works for some but requires you to basically tweak the internals of SA. It works, so I wouldn't recommend breaking it by applying tweaks. The Linux HA with DRBD is free, doesn't require you to tweak SA and works great. We use it for firewalls and recently HA for MySQL for development projects and other systems like SA. Our backend MySQL for SA is 2.8ghz P4 HT with 512mb and 40gb SATA drives (15gb /, 128mb /boot, 25gb /exports - drbd). We are averaging 180k emails per day on this infrastructure (4 front end postfix, 4 backend SA/AV and 2 MySQL servers) and it's basically running idle. Active MySQL node: 04:00:01 AM all 2.92 0.00 0.38 0.23 96.47 ... Log rotation spikes it :( 04:10:01 AM all 7.12 0.00 0.51 0.17 92.21 ... 12:10:01 PM all 3.77 0.00 0.43 0.32 95.48 12:20:01 PM all 1.89 0.00 0.25 0.10 97.75 12:30:01 PM all 2.86 0.00 0.40 0.28 96.47 12:40:01 PM all 2.79 0.00 0.38 0.20 96.63 Hope this helps, Gary Smith On 6/14/05 10:00 AM, "Ronan McGlue" <[EMAIL PROTECTED]> wrote: > Hi all, > running 2 spamd servers and want to share the BAYES DB between > them... so that one never gets too swayed and that both the servers are > contantly synced etc... > > anybody currently running an SQL backend off multiple Spamd servers?? > and if so care to part with some knowledge??? > > thanks
