From owner-freebsd-database@FreeBSD.ORG Sun Oct 19 02:10:14 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3A56516A4B3 for ; Sun, 19 Oct 2003 02:10:14 -0700 (PDT) Received: from web40604.mail.yahoo.com (web40604.mail.yahoo.com [66.218.78.141]) by mx1.FreeBSD.org (Postfix) with SMTP id 6410043F85 for ; Sun, 19 Oct 2003 02:10:13 -0700 (PDT) (envelope-from pjn0211@yahoo.com) Message-ID: <20031019091013.66842.qmail@web40604.mail.yahoo.com> Received: from [203.146.50.38] by web40604.mail.yahoo.com via HTTP; Sun, 19 Oct 2003 10:10:13 BST Date: Sun, 19 Oct 2003 10:10:13 +0100 (BST) From: =?iso-8859-1?q?Supote=20Leelasupphakorn?= To: freebsd-database@FreeBSD.ORG MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cc: gioria@FreeBSD.ORG Subject: Re: Clustering mysql X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 19 Oct 2003 09:10:14 -0000 In-Reply-To: <20031008095226.A18491@thorm.gioria.dyndns.org> Hi gioria, I've done something like that. Let say There're 3-4 SLAVE-servers replicate data from MASTER-server. Web application reading from any SLAVE-servers but only write data to MASTER-server. Take a look at "Section 4.10.9" of MySQL's document (http://www.mysql.com/documentation/mysql/ - bychapter/manual_MySQL_Database_Administration.html#Rep - lication_FAQ) Cheers, pjn ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk