MySQL Forums
Forum List  »  NDB clusters

Re: A question about remote connection via ndb api to mgm
Posted by: Mikael Ronström
Date: April 18, 2016 02:22PM

Hi,

According to below you can start API/MYSQL Server at x.x.x.x
and w.w.w.w

So if you start from different hostname then you need to add
[API]

and if you want to provide the hostname of the machine you can
do it or you can simply skip that.

Rgrds Mikael

Rafael Mateo Wrote:
-------------------------------------------------------
> 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={cpubi
> nd=2},rep={cpubind=3}
>
> [NDBD]
> NodeId=11
> HostName=<z.z.z.z>
> ThreadConfig=ldm={count=2,cpubind=0,1},main={cpubi
> nd=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
861
April 18, 2016 02:22PM


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.