Date: Wed, 24 Nov 2004 23:08:38 -0800 From: Justin Hopper <jhopper@bsdhosting.net> To: freebsd-hackers@freebsd.org Subject: Re: HD Mirroring Message-ID: <1101366517.15634.318.camel@work.gusalmighty.com> In-Reply-To: <Pine.OSX.4.61.0411241629510.787@oof.local> References: <41A467DB.29212.9F2DEC@localhost> <20041124171358.GG545@numachi.com> <Pine.OSX.4.61.0411241629510.787@oof.local>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <jhopper@bsdhosting.net> UNIX Systems Engineer BSDHosting.net Hosting Division of Digital Oasys Inc. http://www.bsdhosting.net
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1101366517.15634.318.camel>