Hi!

After searching google for a while, not finding anything, RTFM, and
trying out varios thing with no result, I finaly ask the profs:

I have set up a MySQL-Cluster:
two nodes, two management servers, two hosts:
ndb_mgmd.cnf:
-----
[ndbd default]
noofreplicas=2
DataMemory=1024M
IndexMemory=256M

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

[ndbd]
hostname=192.168.180.44
id=1

[ndbd]
hostname=192.168.180.45
id=2

[ndb_mgmd]
id = 101
hostname=192.168.180.44

[ndb_mgmd]
id = 102
hostname=192.168.180.45

[mysqld]
id=51
hostname=192.168.180.44

[mysqld]
id=52
hostname=192.168.180.45
-----

my.1.cnf (relevant parts):
-----
[mysqld]
ndb-nodeid = 51
server-id = 51
ndb-cluster
ndb-connectstring = 192.168.180.44

[mysql_cluster]
ndb-connectstring = 192.168.180.44
-----

my.2.cnf (relevant parts):
-----
[mysqld]
ndb-nodeid = 52
server-id = 52
ndb-cluster
ndb-connectstring = 192.168.180.45

[mysql_cluster]
ndb-connectstring = 192.168.180.45
-----

after starting ndb-mgmd, ndbd, and mysqld I get:
-----
root@zm1:/etc/mysql# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=2 @192.168.180.45 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=101 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9)
id=102 @127.0.0.1 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 2 node(s)
id=51 (not connected, accepting connect from 192.168.180.44)
id=52 (not connected, accepting connect from 192.168.180.45)
-----

looks all fine, but the mysqlds are not connecting to the management
nodes. Any idea why?

--
Thomas

Moin,

you are aware of de.comp.datenbanken.mysql?

Thomas Schweikle <tps (AT) vr-web (DOT) de> wrote:
<snip>

Looks good.

Should that not be "ndbcluster" (without the dash)?

No need to set the node-id here, because there is only one ndbd to be
running on each machine. And you need to set the connect string only
once, typically in the [mysql_cluster] section.

Correct the above. If it still not works, check the error log of the
mysqld nodes. And the cluster log written by the mgmd nodes.


XL

Am 16.02.2011 15:53, schrieb Axel Schwenke:
After searching around I've found plugin "ndbcluster" to be
disabled. I tried to restart mysql giving "--plugin-install
ndbcluster" or "--plugin-install ndbcluster" but with no success.

Any idea how I can enable this compiled in plugin?


--
Thomas

Thomas Schweikle <tps (AT) vr-web (DOT) de> wrote:
As I said. The option to enable the NDB storage engine is

ndbcluster

not "ndb-cluster" and it has to go into the [mysqld] section.

RTFM: http://dev.mysql.com/doc/refman/5.1/...ns-mysqld.html


XL