From owner-freebsd-hackers@FreeBSD.ORG Thu Nov 25 07:08:41 2004 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F35DB16A4CF for ; Thu, 25 Nov 2004 07:08:40 +0000 (GMT) Received: from bsdhosting.net (bsdhosting.net [65.39.221.113]) by mx1.FreeBSD.org (Postfix) with SMTP id 5B7FA43D5A for ; Thu, 25 Nov 2004 07:08:40 +0000 (GMT) (envelope-from jhopper@bsdhosting.net) Received: (qmail 41477 invoked from network); 25 Nov 2004 07:06:47 -0000 Received: from unknown (HELO ?192.168.1.2?) (jhopper@bsdhosting.net@65.39.221.113) by bsdhosting.net with SMTP; 25 Nov 2004 07:06:47 -0000 From: Justin Hopper To: freebsd-hackers@freebsd.org In-Reply-To: References: <41A467DB.29212.9F2DEC@localhost> <20041124171358.GG545@numachi.com> Content-Type: text/plain Message-Id: <1101366517.15634.318.camel@work.gusalmighty.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Wed, 24 Nov 2004 23:08:38 -0800 Content-Transfer-Encoding: 7bit Subject: Re: HD Mirroring X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 25 Nov 2004 07:08:41 -0000 On Wed, 2004-11-24 at 13:31, Charles Sprickman wrote: > On Wed, 24 Nov 2004, Brian Reichert wrote: > > > And, although I've not tested it, recent versions of MySQL can > > outright support a cluster: > > > > http://dev.mysql.com/doc/mysql/en/NDBCluster.html > > I'm just curious if there's any other solution that will work on FreeBSD. > I have about 5 mysql servers (4 slaves, 1 master) and one application in > particular is not smart enough to try other servers if the configured > server does not answer. Is there any type of local proxy that can > intelligently route requests to the "best" server? > I too was curious about the MySQL Clustering support and its status on FreeBSD, since it wasn't as a supported OS. Over the last couple of hours I was able to set up a cluster consisting of a management process and data node running in one jail, and a MySQL server and another data node running in a different jail. Once everything was up and running, the cluster seemed to be working excellent, data was synchronizing flawlessly throughout the cluster. Nuking either of the data node processes did not affect access to the data in the cluster, so failover seemed to be working as well. The only problem that I ran into, and it may be user error on my part, is that when the cluster is shut down (or all data node processes are killed), the data contained in the node is lost when the cluster is brought back online. Perhaps there is some recovery step that is required before the cluster can be used again. If someone else has already tested MySQL's clustering ability with FreeBSD, then please let us know the results so that I don't recreate the wheel here. If not, I'll continue seeing how far I can get with it, as I would definitely like to implement this functionality on several of the more critical databases that I manage. -- Justin Hopper UNIX Systems Engineer BSDHosting.net Hosting Division of Digital Oasys Inc. http://www.bsdhosting.net