From owner-freebsd-questions@FreeBSD.ORG Thu Jan 21 07:27:43 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3F4631065670 for ; Thu, 21 Jan 2010 07:27:43 +0000 (UTC) (envelope-from mail25@bzerk.org) Received: from ei.bzerk.org (tunnel490.ipv6.xs4all.nl [IPv6:2001:888:10:1ea::2]) by mx1.freebsd.org (Postfix) with ESMTP id C09E88FC18 for ; Thu, 21 Jan 2010 07:27:42 +0000 (UTC) Received: from ei.bzerk.org (BOFH@localhost [127.0.0.1]) by ei.bzerk.org (8.14.2/8.14.2) with ESMTP id o0L7RaxJ022326; Thu, 21 Jan 2010 08:27:36 +0100 (CET) (envelope-from mail25@bzerk.org) Received: (from bulk@localhost) by ei.bzerk.org (8.14.3/8.14.2/Submit) id o0L7RZWO022325; Thu, 21 Jan 2010 08:27:35 +0100 (CET) (envelope-from mail25@bzerk.org) Date: Thu, 21 Jan 2010 08:27:35 +0100 From: Ruben de Groot To: Steve Bertrand Message-ID: <20100121072735.GA22231@ei.bzerk.org> Mail-Followup-To: Ruben de Groot , Steve Bertrand , "freebsd-questions@freebsd.org Questions -" References: <4B57A887.2030801@ibctech.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4B57A887.2030801@ibctech.ca> User-Agent: Mutt/1.4.2.3i X-Spam-Status: No, score=-4.3 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on ei.bzerk.org X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.0.1 (ei.bzerk.org [127.0.0.1]); Thu, 21 Jan 2010 08:27:41 +0100 (CET) Cc: "freebsd-questions@freebsd.org Questions -" Subject: Re: High availability SQL server setup X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 21 Jan 2010 07:27:43 -0000 Here's an article about multi-master replication on MySQL: http://onlamp.com/onlamp/2006/04/20/advanced-mysql-replication.html It's not rocket science ;) Ruben On Wed, Jan 20, 2010 at 08:06:15PM -0500, Steve Bertrand typed: > Hi all, > > For some time, I've been considering consolidating all/most of our SQL > databases (all MySQL) onto a single dedicated cluster setup. > > I'm looking for feedback on the best way to do this. > > All of the options I've considered so far have both their drawbacks and > benefits. From what I can tell, there's no one single way to be able to > have everything that I want. > > Off the bat, I haven't found a way to create a cluster that can have > more than one host in the cluster writable. > > My objective would be to start with two very high end boxes. One would > sit in my primary location, the other a few blocks away over a gi fibre > link. > > I would want the remote box to pick up immediately if the master server > fails. I figure I could achieve this using network trickery for IP > failover, CARP or the like and span a couple of vlans across the fibre. > > I would want each SQL server connected to separate edge routers to > ensure both server and network resilience. Each box has two GigE NICs, > so off the bat, I'd have each box doing VRRP to two separate edge gear > at each location. > > My concern is, is that I can't envision how both boxes could possibly > stay in a continuous state that would allow such fail-over, and > fail-back. (fail-back is less of a concern...if it comes to it, I'd > rebuild by hand if necessary). > > I've considered ZFS replication, but there could be several minutes > worth of snapshot missing if the primary fails. > > I already have MySQL replication in many spots, but that's only one > write master and read-only slaves. > > Can you provide any details or new ideas that I'm missing in order to > have the holy grail of SQL redundancy? > > Cheers, > > Steve > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"