I am unable to setup MySQL Cluster on ubuntu servers. As a starting point I started from the link but I am not successful and the tar ball version I download is 6.3.45. As I wanted to test the mysql cluster, the Data node and SQL node are same but sql never appeared as connected(mysqld on sql node is running/etc/init.d/mysql.server start
) in management node console and it looks like below.
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.107 (Version: version number, Nodegroup: 0, Master)
id=3 @192.168.1.108 (Version: version number, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.105 (Version: version number)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.1.107)
id=5 (not connected, accepting connect from 192.168.1.108)
On all the 3 machines mysql-server & client(apt-get install mysql-server mysql-client
) were already installed and I completely stopped and also removed them at the system start up.
Now the mysqld is from extracted cluster tar ball(/usr/local/mysql/support-files/mysql.server
). As for testing, I created a test database on both the data nodes but the tables are also not syncing on other node. I checked many links, configurations are remained similar in all the links but somewhere it's going wrong. Any more extra package is required?, Could anyone help me here? I am trying this for past 3 days.
Update 1:
Is there any bug with Ubuntu and mysql-cluster, I am still not successful with cluster 7. Everywhere it's same configuration and working for everyone and why not for me?. Anymore help? please!
Update 2:
Anybody give me working tutorial of mysql-cluster
on ubuntu(10.04
), just a successfully working guide...
EDIT 3:
Anybody take up and guide me please...?