MySQL Forums
Forum List  »  NDB clusters

Initial cluster setup
Posted by: Andy
Date: July 05, 2005 12:09PM

Hi all,

I'm a little confused about a couple things.

The background is that I want to deploy an HA cluster with MySQL 4.1.12 on FreeBSD. An application will connect to the database and do database things.

First question is: I need at least three servers, correct? According to this thread, Jonathan Miller says I need at least two, but everything else I read seems to say I need at least three to avoid splitbrain.,30251,30362#msg-30362

Secondly, I understand that I can run two management nodes and obviously two data nodes, but I can find nothing that says that I can run two MySQL nodes.

If I only have one MySQL node, I only have essentially one 'entry point' into the data store. If the MySQL node goes down, do I have to change the application to point to a different node? If so, then what's the point of having a cluster?

My goal is to have three machines - one will be just a management node (among other things), the other two will be data storage nodes and hopefully MySQL nodes as well.

Options: ReplyQuote

Written By
Initial cluster setup
July 05, 2005 12:09PM
July 05, 2005 04:54PM
July 06, 2005 05:13AM
July 06, 2005 03:45PM
July 06, 2005 03:57PM
July 06, 2005 07:19PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.