Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th December 2009, 11:30
longvnit longvnit is offline
Junior Member
 
Join Date: Mar 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Cool Problems with MySQL Cluster (Help)

Hi ,
I am tring to install one MySQL Cluster ,
But i have some problems,

Network topologies includes :
a . 01 Server cluster management IP : 192.168.1.5
b . 03 Server Cluster Node : IP 192.168.1.2 -> 192.168.1.4

Code:
File /usr/local/mysql/var/mysql-cluster/config.ini
Code:
[NDBD DEFAULT]
NoOfReplicas=3
DataMemory=80M    # How much memory to allocate for data storage
IndexMemory=18M   # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the .world. database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
NodeId = 1
# IP address of the management node (this system)
HostName=192.168.1.5
# Section for the storage nodes
[NDBD]
NodeId = 2
# IP address of the first storage node
HostName=192.168.1.3
DataDir=/usr/local/mysql/var/mysql-cluster
BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
DataMemory=100M
[NDBD]
NodeId = 3
# IP address of the second storage node
HostName=192.168.1.4
DataDir=/usr/local/mysql/var/mysql-cluster
BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
DataMemory=100M
 
[NDBD]
NodeId = 4
# IP address of the second storage node
HostName=192.168.1.2
DataDir=/usr/local/mysql/var/mysql-cluster
BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
DataMemory=100M
 
 
 
# one [MYSQLD] per storage node
[MYSQLD]
NodeId = 5
[MYSQLD]
NodeId = 6
[MYSQLD]
NodeId = 7
Code:
File /etc/my.cnf
Code:
[client]
socket=/tmp/mysql.sock
[mysqld]
ndbcluster
ndb-connectstring=192.168.1.5
default-storage-engine=NDBCLUSTER
[mysql_cluster]
ndb-connectstring=192.168.1.5
I have some problems bellow :

1. not connected, accepting connect from any hosts
I don't know why that ?

2. I run ndbd on three servers then only server 192.168.1.3 have connect into server Cluster Management , although three server is same.
Code:
[ndbd(NDB)]     3 node(s)
id=2    @192.168.1.3  (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 192.168.1.4)
id=4 (not connected, accepting connect from 192.168.1.2)
 
[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.1.5  (mysql-5.1.39 ndb-7.0.9)
 
[mysqld(API)]   3 node(s)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
Server 192.168.5.2 & .5.4 can't connect to server cluster management 192.168.1.5

When i run command : ndbd on server 192.168.1.2 or .4 then server cluster management show :

Node 4: Forced node shutdown completed. Occured during startphase 0. Caused by error 2805: 'Illegal file system path(Configuration error). Permanent error, external action needed'.

Please help me slove these problems.
Thanks so much.
Reply With Quote
Sponsored Links
  #2  
Old 9th December 2009, 14:41
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Quote:
Originally Posted by longvnit View Post
Server 192.168.5.2 & .5.4 can't connect to server cluster management 192.168.1.5
Is that a typo? Do you mean 192.168.1.2 and 192.168.1.4?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 9th December 2009, 17:22
longvnit longvnit is offline
Junior Member
 
Join Date: Mar 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko View Post
Is that a typo? Do you mean 192.168.1.2 and 192.168.1.4?

oh yes, i fixed my problems ,
Because i removed /usr/local/mysql/var/mysql-cluster/backup folder,so when Node Server load config from Cluster management server which check does not exist this folder, therefore show error Illegal file system path(Configuration error).

System show good
Code:

Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @192.168.1.3 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=3 @192.168.1.10 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)
id=4 @192.168.1.2 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.5 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 5 node(s)
id=5 @192.168.1.3 (mysql-5.1.39 ndb-7.0.9)
id=6 @192.168.1.2 (mysql-5.1.39 ndb-7.0.9)
id=7 @192.168.1.10 (mysql-5.1.39 ndb-7.0.9)

Thanks for helping me .
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
MySQL Cluster - Tables not synced tfunky Server Operation 4 6th April 2007 22:22
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55


All times are GMT +2. The time now is 02:36.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.