From owner-freebsd-isp@FreeBSD.ORG Sat Jun 7 11:46:26 2003 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 559C337B401 for ; Sat, 7 Jun 2003 11:46:26 -0700 (PDT) Received: from blue.gerhardt-it.com (gw.gerhardt-it.com [204.83.38.103]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8470543F93 for ; Sat, 7 Jun 2003 11:46:25 -0700 (PDT) (envelope-from scott@g-it.ca) Received: from [24.71.178.119] (h24-71-178-119.ss.shawcable.net [24.71.178.119]) by blue.gerhardt-it.com (Postfix) with ESMTP id 4310BFD96 for ; Sat, 7 Jun 2003 12:46:24 -0600 (CST) User-Agent: Microsoft-Entourage/10.1.1.2418 Date: Sat, 07 Jun 2003 12:46:21 -0600 From: Scott Gerhardt To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Subject: Mirroring Solution X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 07 Jun 2003 18:46:26 -0000 Does anyone know of a good way to mirror two servers running Apache, PHP and MySQL on FreeBSD 4.8? The ideal solution would be real-time (synchronous) or near-real-time mirroring. The failover transfer is already taken care of. I think Rsync run from cron would do a good job of syncing the relatively static files (configs, php scripts etc.). I don't think Rsync would be a good way of mirroring the MySQL DB though. For that, I'm thinking of using MySQL's built in replication. I think dumping the MySQL data and importing into the slave would be a bit clumsy and slow especially when the DB grows quite large. Does anyone on the list have any recommendations or experience with mirroring of this type? Any other recommendations besides Rsync + MySQL replication? Thanks, -- Scott Gerhardt, P.Geo. Gerhardt Information Technologies [G-IT]