comebui
asked on
My SQL Clustering in RHEL 5
I am using following RPM for mysql and clustering
Mysql
---------
MySQL-server-community-5.0 .77-0.rhel 5
MySQL-client-community-5.0 .77-0.rhel 5
Cluster
---------
MySQL-clustermanagement-co mmunity-5. 0.77-0.rhe l5
MySQL-clusterstorage-commu nity-5.0.7 7-0.rhel5
MySQL-clustertools-communi ty-5.0.77- 0.rhel5
After installing all these above rpm I create config.ini in /var/lib/mysql-cluster/
[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
# the IP of THIS SERVER
HostName=192.168.0.218
# Storage Engines
[NDBD]
# the IP of the FIRST SERVER (STORAGE NODE)
HostName=192.168.0.236
DataDir=/var/lib/mysql-clu ster
[NDBD]
# the IP of the SECOND SERVER (STORAGE NODE)
HostName=192.168.0.42
DataDir=/var/lib/mysql-clu ster
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
[MYSQLD]
And on the other hand I configured nodes and restarted all mysql
But in when I tried to run ndb_mgm it shows
[root@testDev mysql-cluster]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 2
Can u please guide me what can be the possible reasons behind that.
=============
Mysql
---------
MySQL-server-community-5.0
MySQL-client-community-5.0
Cluster
---------
MySQL-clustermanagement-co
MySQL-clusterstorage-commu
MySQL-clustertools-communi
After installing all these above rpm I create config.ini in /var/lib/mysql-cluster/
[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
# the IP of THIS SERVER
HostName=192.168.0.218
# Storage Engines
[NDBD]
# the IP of the FIRST SERVER (STORAGE NODE)
HostName=192.168.0.236
DataDir=/var/lib/mysql-clu
[NDBD]
# the IP of the SECOND SERVER (STORAGE NODE)
HostName=192.168.0.42
DataDir=/var/lib/mysql-clu
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
[MYSQLD]
And on the other hand I configured nodes and restarted all mysql
But in when I tried to run ndb_mgm it shows
[root@testDev mysql-cluster]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 2
Can u please guide me what can be the possible reasons behind that.
=============
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As it is the first time
# ndb_mgm --initial
# ndb_mgm --initial
ASKER
When I tried with it shows
# ndb_mgm --initial
ndb_mgm: unknown option '--initial'
When I tried without it shows
# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 2
# ndb_mgm --initial
ndb_mgm: unknown option '--initial'
When I tried without it shows
# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 2
ASKER
and please check the list of the rmp what I have installed. If anything I am missing please let me know
ASKER
What is described I tried all option , But I am not able to run ndbd , it says
# ndbd
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 12 11
If there any packages I m missing ?
# ndbd
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 12 11
If there any packages I m missing ?
ASKER
I tried netstat -ntlp for checking which port is listening, but I saw
tcp 0 0 0.0.0.0:1186 0.0.0.0:* LISTEN 4942/ndb_mgmd
After that I tired
netstat -a
here
..........
tcp 0 0 *:mysql-cluster *:* LISTEN
..................
but not connected .
What will be the next approach ?