Re: A question about remote connection via ndb api to mgm

[Rafael Mateo]

Hi Mikael:

The linux box that runs the connection binary, doen't have any mysql process (mgm,ndbmtd or mysqld), it isn't an API node, SQL node or MGM.

How do i add the ip of this linux box into config.ini ???

this is the config.ini

#
# Configuration file for MyCluster
#

[NDB_MGMD DEFAULT]
...
...
...

[NDB_MGMD]
NodeId=100
HostName=<x.x.x.x>
Portnumber=10000
ArbitrationRank=1

[NDBD]

NodeId=10
HostName=<y.y.y.y>
ThreadConfig=ldm={count=2,cpubind=0,1},main={cpubind=2},rep={cpubind=3}

[NDBD]
NodeId=11
HostName=<z.z.z.z>
ThreadConfig=ldm={count=2,cpubind=0,1},main={cpubind=2},rep={cpubind=3}

[MYSQLD]

NodeId=248 # slot nodo api ndb-cluster-connection-pool.
HostName=<x.x.x.x>
[MYSQLD]

NodeId=249 # slot nodo api ndb-cluster-connection-pool.
HostName=<x.x.x.x>
[MYSQLD]

NodeId=250 # slot nodo api ndb-cluster-connection-pool.
HostName=<x.x.x.x>
[MYSQLD]

NodeId=251 # slot nodo api ndb-cluster-connection-pool.
HostName=<x.x.x.x>
[MYSQLD]

NodeId=252 # slot nodo api ndb-cluster-connection-pool.
HostName=<w.w.w.w.>

[MYSQLD]

NodeId=253 # slot nodo api ndb-cluster-connection-pool.
HostName=<w.w.w.w.>
[MYSQLD]

NodeId=254 # slot nodo api ndb-cluster-connection-pool.
HostName=<w.w.w.w.>

[MYSQLD]

NodeId=255
HostName=<w.w.w.w.>

[MYSQLD]

NodeId=200
#HostName=<x.x.x.x>
ArbitrationRank=0

[MYSQLD]
NodeId=201
HostName=<w.w.w.w.>
ArbitrationRank=0


for example if the connection binary linux box has got the 192.168.1.1 ip

how must i add this server without process mysql cluster into config.ini ?¿?¿?¿



Regard in advance Mikael.