HD Mirroring

[Justin Hopper]

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 at bsdhosting.net>
UNIX Systems Engineer
BSDHosting.net
Hosting Division of Digital Oasys Inc.
http://www.bsdhosting.net