Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1462
  • Last Modified:

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.
=============
0
comebui
Asked:
comebui
  • 4
  • 4
1 Solution
 
louislietaerCommented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now