On Thursday 24 June 2004 05:08 pm, [EMAIL PROTECTED] wrote: > We run eight qmail servers with one main server that stores the client data > and acts as the main mysql server. We have a backup server to the main > server that replicates the mysql DBs. The six additional qmail servers > connect to these servers as the mysql server. The primary mysql server > performs all queries that make changes to the DBs and the backup server > executes all select queries. I am wondering if we are better off > replicating the mysql DBs to each qmail server (six of them) and performing > the sql select queries locally rather than over the network.
it's a little more headache to administer the mysql stuff, but definitely a better setup. I've done this with several customers and it works fine. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail