Clicky

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 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)                             
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 

Select allOpen in new window



On all the 3 machines mysql-server & client(apt-get install mysql-server mysql-client) were alrady installed and I completely stopped them and also at the system start up.
Now the mysqld is from extracted cluster tar ball(/usr/local/mysql/support-files/mysql.server). As for testing, 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 similar but somewhere it's going wrong. Anymore extra package is required?, Could anyone help me here..?

Thank you!

asked 11/22/2011 10:19

Thyagaraj03's gravatar image

Thyagaraj03 ♦♦


7 Answers:
Check that no firewall cuts the traffic to port 1186.
link

answered

pfrancois's gravatar image

pfrancois

All are testing servers and no firewall(iptables) rules applied ever!.
link

answered 2011-11-24 at 01:42:07

Thyagaraj03's gravatar image

Thyagaraj03

It worked after removing mysql(apt-get remove mysql-*) which are installed from apt. I don't understand why this is so when I stopped and removed starting from system startup.

link

answered 2011-11-24 at 02:03:54

Thyagaraj03's gravatar image

Thyagaraj03

I've requested that this question be closed as follows:

Accepted answer: 0 points for Thyagaraj03's comment http:/Q_27461884.html#37237249

for the following reason:

I had to spend some days and find out mysql

link

answered 2011-12-05 at 05:03:02

Thyagaraj03's gravatar image

Thyagaraj03

Don't know what happened suddenly, it's not working since yesterday. Actually I am unable to find out the pkg requirement for mysql-cluster, is mysql-server or mysql-client should be installed and running along with cluster or a mysql-cluster alone is enough for running SQL(mysqld) and data nodes?. Now it's not woking, mysqld(/etc/init.d/mysql.server) is not starting and giving the following error:
1:
2:
Starting MySQL
 * Couldn't find MySQL manager (/usr/bin/mysqlmanager) or server (/usr/bin/mysqld_safe)

On another node(having same problem) I even tried copying /usr/local/bin/* to /usr/bin but still no use and it was showing the below error when I try to start mysqld in this machine:
1:
................... * Manager of pid-file quit without updating file.

This happened after installing libaprutil1-dev(apt-get install libaprutil1-dev) on both the machines. Anybody has any working link of mysql-cluster setup on ubuntu?

link

answered 2011-12-05 at 05:04:29

Thyagaraj03's gravatar image

Thyagaraj03

I go the issues resolved, I would like to get this post closed!
link

answered 2011-12-07 at 16:57:07

Thyagaraj03's gravatar image

Thyagaraj03

I had to spend much time and fix the issues myself

link

answered 2011-12-13 at 17:04:52

Thyagaraj03's gravatar image

Thyagaraj03

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×2
×31

Asked: 11/22/2011 10:19

Seen: 371 times

Last updated: 12/17/2011 05:21