View Single Post
Old 10th April 2007, 19:19
lychee_lch lychee_lch is offline
Junior Member
Join Date: May 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts

What do you mean "which distribution" ?
I follow the "How To Set Up A Load-Balanced MySQL Cluster".

The following are the spec i used;
Operating system : Ubuntu 5.10
* MySQL cluster node 1 ( 1 NIC )
* MySQL cluster node 2 ( 1 NIC )
* Load Balancer 1 / MySQL cluster ( 1 NIC )
management server ( 1 NIC )
* Load Balancer 2 ( 1 NIC )
All connected to 1 switch then to internet.
All package using apt-get as in tutorial except the mysql-max 5.0.27 version changed.

From the tutorial, i succeed follow until page 4 and completed it with no problem. Mysql clustering work fine and pass all test mentioned. ( So i comfirm until here with 100% no mistake).

So the following step is "6 Configure The Load Balancers" until the end of "page 7 Create A Database Called ldirector" which required to type "ifup lo:0" command at the last page. When i ifup lo:0 the network interface at the sql1 node and sql2 node , the mysql cluster management (ndb_mgm) will automatically show

Cluster Configuration
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from
id=3 (not connected, accepting connect from

[ndb_mgmd(MGM)] 1 node(s)
id=1 @ (Version: 5.0.27)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)


The mysql cluster disconnected. Without any error log or error specificed. The situation just like i pull out the cable.
Can you let me know is this situation normal after i type ifup lo:0 at sql node mysql clustering with disconnected?

I think i misunderstand or misconfiguring some part of the network. But i dono which part. I am sure there were no typo error( All have been re-check several times). So i wont ask many question first. I hope falko can correct me step by step. If any information needed please state it, i will provide it as soon as possible.

Thanks falko for reply..... thanks !
Reply With Quote