On Wed, Jun 23, 2004 at 02:41:17PM -0400, Mick Szucs wrote: > On Wednesday 23 Jun 2004 2:13 pm, Bob Pierce wrote: > > IS this something that might be possible using v3.0's new MySQL functions? > > Or would it even be possible to have them share the same nfs share for the > > rules directories? > > > > Has anybody tried something similar to this, or is there any documentation > > on something like this? > > I'm currently running four servers all synced to the same rules database via > MySQL. I'm using MySQL replication to keep the servers all in sync with one > another. So far, however, I'm just using the local whitelist/bayes dbs on > these machines. I'm anxiously awaiting the release of 3.0 to add > bayes/whitelist to my replicated SQL server.
Bayes SQL won't work well on a replicated setup. It uses an auto_increment column for the userid. It could be made to work with some minor code changes, but wouldn't work well out of the box. Why not just setup a master server and have all your mail servers talk to it? Michael
