Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have two servers, where

First server 10.100.15.150: 1. one mgm server 2. one ndbd 3. one mysql api

Second server 10.100.15.160: 1. one ndbd 2. one mysql api

When i start all 'parts' of cluster it looks :

Cluster Configuration

[ndbd(NDB)] 2 node(s)

id=21 @10.100.15.150 (mysql-5.1.56 ndb-7.1.17, Nodegroup: 0)

id=22 @10.100.15.160 (mysql-5.1.56 ndb-7.1.17, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)

id=3 @10.100.15.150 (mysql-5.1.56 ndb-7.1.17)

[mysqld(API)] 2 node(s)

id=11 @10.100.15.150 (mysql-5.1.56 ndb-7.1.17)

id=12 @10.100.15.160 (mysql-5.1.56 ndb-7.1.17)

When i shutdown first machine - 10.100.15.150, on second the nbdb process also has been shutdown so i cannot use this data node and cluster fail ...

How i must configure this cluster to get FailOver working ?

Thx

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

You can't. In this case, the ndbd on server2 can't determine that it is the only viable cluster (because server1 shutdown), or if server1 is still working but just can't communicate with server2. Note that shutting down server2 would allow server1 to continue to run because the mgm server is running on server1.

Two options:

1.) Run a a second mgm on server2. This will allow for planned failovers, by shutting down the mgm on server1, allowing the server2 mgm to takeover, and then shutting off server1.

2.) Get a third server for the mgm.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.