I have two servers, where

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

Second server 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 @ (mysql-5.1.56 ndb-7.1.17, Nodegroup: 0)

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

[ndb_mgmd(MGM)] 1 node(s)

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

[mysqld(API)] 2 node(s)

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

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

When i shutdown first machine -, 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 ?



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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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