Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

My SQL Clustering in RHEL 5

Posted on 2009-05-07
8
Medium Priority
?
1,453 Views
Last Modified: 2012-05-06
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
Comment
Question by:comebui
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 5

Accepted Solution

by:
louislietaer earned 1500 total points
ID: 24333678
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
 
LVL 1

Author Closing Comment

by:comebui
ID: 31579330
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
 
LVL 5

Expert Comment

by:louislietaer
ID: 24333929
As it is the first time

# ndb_mgm --initial


0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:comebui
ID: 24334202
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
 
LVL 1

Author Comment

by:comebui
ID: 24334212
and please check the list of the rmp what I have installed. If anything I am missing please let me know
0
 
LVL 5

Expert Comment

by:louislietaer
ID: 24334261
0
 
LVL 1

Author Comment

by:comebui
ID: 24334647
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
 
LVL 5

Expert Comment

by:louislietaer
ID: 24334803
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question