Solved

My SQL Clustering in RHEL 5

Posted on 2009-05-07
8
1,429 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
  • 4
  • 4
8 Comments
 
LVL 5

Accepted Solution

by:
louislietaer earned 500 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all 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: 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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linux Mailserver setup & redundancy 2 84
lunix and unix command 21 121
can i read my emails on lamp ftp 4 31
check the file dates in unix 14 33
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

696 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