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.

http://forums.mysql.com/read.php?25,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


Subject
Views
Written By
Posted
Initial cluster setup
2686
July 05, 2005 12:09PM
1789
July 05, 2005 04:54PM
1991
July 06, 2005 05:13AM
1934
July 06, 2005 03:45PM
1880
July 06, 2005 03:57PM
1857
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.