Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th June 2008, 12:16
sanocli sanocli is offline
Junior Member
 
Join Date: Jun 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation How To Set Up A Load-Balanced MySQL Cluster => can't connect API node

Hello guys,

I have followed this HOWTO : http://www.howtoforge.com/loadbalanc...cluster_debian. Everything is okay for the management node and Data Node but no SQL/API node is connected. I don't know why I have tried several things but nothing has worked. If someone could tell me what is wrong with my configuration.

This is my configuration file present in /var/lib/mysql-cluster
Code:
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=10MB
IndexMemory=10MB
Diskless=1

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

# Managment Server

[NDB_MGMD]
HostName=127.0.0.1

# Storage Engines

[NDBD]
HostName=127.0.0.1
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=127.0.0.1
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=127.0.0.1
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=127.0.0.1
DataDir=/var/lib/mysql-cluster

# 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]
HostName=127.0.0.1

[MYSQLD]

And this my my.cnf present in /etc/
Code:
[mysqld]
ndbcluster
# IP address of the cluster management node
ndb-connectstring=127.0.0.1

[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=127.0.0.1
Thank you for helping in anyway.


Have a good day
Reply With Quote
Sponsored Links
  #2  
Old 19th June 2008, 16:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

You're using 127.0.0.1 everywhere. That's the problem. Compare this to the setup on http://www.howtoforge.com/loadbalanc...cluster_debian where different IP addresses are used.
__________________
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
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
Load balancing on Fedora with Heartbeat (MySQL Cluster) rwillie6 HOWTO-Related Questions 7 17th December 2009 12:32
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
How to monitor the load balanced workload in apache cluster + mysql cluster ??? lychee_lch HOWTO-Related Questions 3 24th April 2007 19:17
Question about the hardware requirement for mysql cluster with load balancing??? johN5Five^ HOWTO-Related Questions 3 12th April 2007 17:06
newbie ububtu 6.0.6 error PHP binary line 816 davidsky73 Installation/Configuration 8 17th September 2006 11:51


All times are GMT +2. The time now is 07:34.


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