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

[Mikael Ronström]

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.