List:Cluster« Previous MessageNext Message »
From:Andrew Morgan Date:February 27 2013 2:26pm
Subject:RE: Three node mysql cluster setup issues
View as plain text  
Ashutosh,

 

The config.ini and my.cnf attachments didnt' make it through -maybe simpler just to paste
into the body of your email. 

 

ndb_mgm is only showing 3 data nodes configured - you should really add data nodes in
pairs so that they can form a new node group.

 

Did you perform a rolling restart (restart management node, each data node and each mysqld
in sequence) after adding the new data node sections to your config.ini file? 

 

The docs describe how to add new data nodes to a running cluster...
http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-online-add-node.html 

 

Node that for a fault-tolerant configuration your management node should not be on the
same host as any of your data nodes.

 

Regards, Andrew.

 

From: Ashutosh Narayan [mailto:aashutoshnarayan@stripped] 
Sent: 27 February 2013 13:30
To: cluster@stripped
Subject: Three node mysql cluster setup issues

 

Hi folks,

 

We are facing issues in setting up three node mysql cluster for high availability.

We have set management server on one machine and the same machine has two 

nodes running locally on them. The connection seems to be working fine after following

the documentations in the following HYPERLINK
"http://downloads.mysql.com/tutorials/cluster/mysql_wp_cluster_quickstart_linux.pdf"
\nlink . Everything works like a charm.

 

But when we attach a third node which is another machine with a different IP address. 

We get into lot of issues. The commands that we ran to start management server, 

ndb_mgm, ndbd and then mysqld can be seen below :

 

status of localhost can be seen below :

 

[root@test bin]# ./ndb_mgm -e show

Connected to Management Server at: localhost:1186

Cluster Configuration

---------------------

[ndbd(NDB)]            2 node(s)

id=3   @HYPERLINK "http://127.0.0.1"127.0.0.1  (mysql-5.5.29 ndb-7.2.10, Nodegroup: 0,
Master)

id=4   @HYPERLINK "http://127.0.0.1"127.0.0.1  (mysql-5.5.29 ndb-7.2.10, Nodegroup: 0)

 

[ndb_mgmd(MGM)]            1 node(s)

id=1   @HYPERLINK "http://127.0.0.1"127.0.0.1  (mysql-5.5.29 ndb-7.2.10)

 

[mysqld(API)]           1 node(s)

id=50            @HYPERLINK "http://192.168.105.40"192.168.105.40  (mysql-5.5.29
ndb-7.2.10)

 

Status of localhost after connecting third node can be seen below :

 

[root@test bin]# ./ndb_mgm -e show

Connected to Management Server at: localhost:1186

Cluster Configuration

---------------------

[ndbd(NDB)]            3 node(s)

id=3 (not connected, accepting connect from 192.168.105.40)

id=4 (not connected, accepting connect from 192.168.105.40)

id=11 (not connected, accepting connect from 192.168.105.63)

 

[ndb_mgmd(MGM)]            1 node(s)

id=1   @HYPERLINK "http://192.168.105.40"192.168.105.40  (mysql-5.5.29 ndb-7.2.10)

 

[mysqld(API)]           3 node(s)

id=50 (not connected, accepting connect from any host)

id=51 (not connected, accepting connect from 192.168.105.63)

id=52 (not connected, accepting connect from any host)

 

Error while starting mysqld service on management server :

 

bash-4.1$ /devops/mysqlc/bin/mysqld --defaults-file=/devops/my_cluster/conf/my.cnf &

[1] 22598

bash-4.1$ 130227 17:27:47 [Note] Plugin 'FEDERATED' is disabled.

130227 17:27:47 InnoDB: The InnoDB memory heap is disabled

130227 17:27:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins

130227 17:27:47 InnoDB: Compressed tables use zlib 1.2.3

130227 17:27:47 InnoDB: Using Linux native AIO

130227 17:27:47 InnoDB: Initializing buffer pool, size = 128.0M

130227 17:27:47 InnoDB: Completed initialization of buffer pool

130227 17:27:47 InnoDB: highest supported file format is Barracuda.

130227 17:27:47  InnoDB: Waiting for the background threads to start

130227 17:27:48 InnoDB: 1.1.8 started; log sequence number 1595675

130227 17:28:23 [Warning] NDB: server id set to zero - changes logged to bin log with
server id zero will be logged with another server id by slave mysqlds

130227 17:28:23 [Note] Starting Cluster Binlog Thread

130227 17:28:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 5000

130227 17:28:23 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

130227 17:28:23 [Note] Server socket created on IP: '0.0.0.0'.

130227 17:28:23 [Note] Event Scheduler: Loaded 0 events

130227 17:28:23 [Note] /devops/mysqlc/bin/mysqld: ready for connections.

Version: '5.5.29-ndb-7.2.10-cluster-gpl'  socket: '/tmp/mysql.sock'  port: 5000  MySQL
Cluster Community Server (GPL)

130227 17:28:53 [Warning] NDB : Tables not available after 30 seconds.  Consider
increasing --ndb-wait-setup value

 

I am also attaching config.ini and my.cnf files of management server and data node
respectively.

 

config_management_server.ini : management server config.ini file

my_cnf_data_node.cnf : my.cnf on third data node

 

Please let us know where are we going wrong.

 

Thank you,

 

-- 

Ashutosh Narayan

http://ashutoshn.wordpress.com/

Thread
Three node mysql cluster setup issuesAshutosh Narayan27 Feb
  • RE: Three node mysql cluster setup issuesAndrew Morgan27 Feb
    • Re: Three node mysql cluster setup issuesAshutosh Narayan28 Feb
      • RE: Three node mysql cluster setup issuesAndrew Morgan28 Feb