Hi, I have a question regarding a BayesStore module I'm writing. First let me explain what I'm trying to accomplish.
I want to build a setup of three servers, one master database, and two spam gateways. I want the bayes database to be replicated so that the bayes check produces the same result on both servers (more might be added in the future). To do this I want to use a master sql database that replicates to both mail servers. The BayesStore module should do all writes on the master, and all reads on the slave. Although this doesn't necessarily improve overall performance, it does allow the master to go down without the slaves being interrupted. My questions: 1. Is this even a good idea? 2. Splitting on read/write actions might not be a good idea. It might be better to read only tokens locally, and token expiration delta etc from the master so that we're always working with the most up to date information? 3. Other pointers? Best regards, Jeroen Koekkoek
