MySQL Forums
Forum List  »  NDB clusters

Re: Any benefit to have more than 1 mgm running?
Posted by: Alex Davies
Date: December 04, 2005 11:22AM

> I have two sun servers , and want to install a
> mysql cluster
> on the two servers.

You need THREE servers for a highly available MySQL cluster. You can't do it with two. Google "split brain problem" for a technical explanation.

You can then install a standard 1mgm/2storage nodes and as many SQL nodes as you need. You could install two mgm nodes but as pointed out above it is likely to be pointless - the mgm node going down is not a big issue.

Alex

Alex Davies
http://www.davz.net | alex@davz.net

Options: ReplyQuote




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.