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

Reply via email to