?
Solved

My SQL Clustering in RHEL 5

Posted on 2009-05-07
8
Medium Priority
?
1,447 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

777 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