I want install mysql cluster in two servers, but a have problem with node of SQL with next configuration:
I configurate based this guide:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-multi-config.html
Firewall disable in all servers.
ndbd(NDB) 2 with ips 192.168.2.10 and 192.168.2.20
ndb_mgmd(MGM) 1 with ip 192.168.2.10
mysqld(SQL) 1 with ip 192.168.2.10
My configurations:
my.cnf in 192.168.2.10
[mysqld]
ndbcluster # run NDB engine
ndb-connectstring=192.168.2.10 # location of MGM node
[MYSQL_CLUSTER] # Options for ndbd process:
ndb-connectstring=192.168.2.10 # location of MGM node
cluster configuration /var/lib/mysql-cluster/config.ini
[NDBD DEFAULT]
NoOfReplicas=1
[TCP DEFAULT]
portnumber=2202
[NDB_MGMD]
hostname=192.168.2.10
datadir=/var/lib/mysql-cluster
[NDBD]
hostname=192.168.2.10
datadir=/var/lib/mysql-cluster
[NDBD]
hostname=192.168.2.20
datadir=/var/lib/mysql-cluster
[MYSQLD]
hostname=192.168.2.10
-------------------------------------
I run cluster in 192.168.2.10 with:
ndb_mgmd -f /var/lib/mysql-cluster/config.ini
ndbd --initial
service mysql restart
[root@server12f mysql-cluster]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.2.10:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.2.10 (Version: 5.0.26, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 192.168.2.20)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.2.10 (Version: 5.0.26)
[mysqld(API)] 1 node(s)
id=4 (not connected, accepting connect from 192.168.2.10)
I look log ndb_1_cluster.log:
2006-10-20 16:16:13 [MgmSrvr] INFO -- Node 2: Start phase 0 completed
2006-10-20 16:16:13 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened
2006-10-20 16:16:13 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c con$
2006-10-20 16:16:14 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000002.
2006-10-20 16:16:16 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c con$
2006-10-20 16:16:19 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c con$
2006-10-20 16:16:22 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c con$
2006-10-20 16:16:25 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c con$
2006-10-20 16:16:27 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 213.251.147.15, m_reserved_nodes 0000000000000012.
2006-10-20 16:16:27 [MgmSrvr] INFO -- Node 4: mysqld --server-id=0
2006-10-20 16:16:28 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c co
and log mysql:
061020 16:16:27 mysqld started
061020 16:16:27 InnoDB: Started; log sequence number 0 43710
061020 16:16:37 [Note] /usr/sbin/mysqld-max: ready for connections.
Version: '5.0.26-max' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)
Please I need help. Thanks
Edited 4 time(s). Last edit at 10/20/2006 08:43AM by David Garcia.