My SQL Clustering in RHEL 5

I am using following RPM for mysql and clustering
Mysql
---------
MySQL-server-community-5.0.77-0.rhel5
MySQL-client-community-5.0.77-0.rhel5

Cluster
---------
MySQL-clustermanagement-community-5.0.77-0.rhel5
MySQL-clusterstorage-community-5.0.77-0.rhel5
MySQL-clustertools-community-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-cluster
[NDBD]
# the IP of the SECOND SERVER (STORAGE NODE)
HostName=192.168.0.42
DataDir=/var/lib/mysql-cluster
# 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.
=============
LVL 1
comebuiAsked:
Who is Participating?
 
louislietaerConnect With a Mentor Commented:
The probable answers is that the daemon is not listening port 1186 on localhost (127.0.0.1)

linux command :

netstat -a

 will prove that
0
 
comebuiAuthor Commented:
Thanks for the response.
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 ?
0
 
louislietaerCommented:
As it is the first time

# ndb_mgm --initial


0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
comebuiAuthor Commented:
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
0
 
comebuiAuthor Commented:
and please check the list of the rmp what I have installed. If anything I am missing please let me know
0
 
louislietaerCommented:
0
 
comebuiAuthor Commented:
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 ?
0
 
louislietaerCommented:
0
All Courses

From novice to tech pro — start learning today.