MySQL Forums
Forum List  »  NDB clusters

Re: A question about remote connection via ndb api to mgm
Posted by: Rafael Mateo
Date: April 18, 2016 07:42AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: A question about remote connection via ndb api to mgm
706
April 18, 2016 07:42AM


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.