Comments on How to Install a MySQL Cluster on Ubuntu 16.04

It is possible to install all the elements in the same machine?I'm trying it and everything its OK but i cant start the API(mysqld)

Thanks in advance.

Hello all,

there are any points which can be actualized:

1) MySQL Cluster can be installed on Ubuntu 15.04 and newer.

2) NDB can be downloaded in the newest version. I actualy tested: - http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.5/mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64.tar.gz

 

 

3) If you will install cluster in v7.5.4, then the install (initial) command is not:./scripts/mysql_install_db --user=mysql... but you need to use this command:bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

When you do a "show" on the management node, one of the data nodes is showing up.  Also, add 'wget' to the command in the "Download the mysql cluster package from the site, extract and rename it:" section.

I installed this mysql cluster, working fine but SQL node replicate databases only to the one NODE (node1 or node2) depend which node is cooperating with SQLfor example: SQL with NODE1.When NODE1 drop down SQL start cooperating with NODE2, butis it possible to replicate NODE2 and NODE1 all the time? because in this scenario I have only one NODE server online and second is in "backup mode"

My problem was the same.

I have the same problem

I am setting this cluster up and am  having the same issue.  Were you able to resolve and if so what did you do?  Thank you.

Hi, guys

i've reach step 2 : start mysql on data node

when I type the command systemctl start mysql

It found an error

Job for mysql.service failed because the control process exited with error code.                          See "systemctl status mysql.service" and "journalctl -xe" for details.

anyone can help me ?

Hello Jaeger, your problem is relation with the installation steps. Try to do it again with care. I had the same error.

Buena noche yo tengo el mismo problema de que no se puede iniciar mysql y ya volvi a realizar todo el proceso incluso en otra maquina virtual y sigue pasando lo mismo, ayuda :(

"Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details."

You can fix with this

cd /usr/local/

chown -R mysql:mysql mysql

Hello people, I have a error. I want to replicate TABLES in data nodes (not only data bases). I have done this, with the command ENGINE=NDBCLUSTER or ENGINE=NDB, but this don't work.

For example in MYSQL node:

create table table1.database1 (id int) ENGINE=NDB;

result: "error 1296 (hy000) got error 4009 'cluster failure' from ndbcluster". What is my problem? Please help me.

I have searched for a lot of information. But this don't work.

Thank you very much

I got the same error when trying to start mysql service. I've repeated the setup for a number of times.  What other workarounds should be done? Please help guys :D

hi, I have a trouble after step3 installed sql node. I can't be connected cluster but sql node is running.like it,

[ndbd(NDB)] 2 node(s)

id=2 @172.31.16.200  (mysql-5.6.31 ndb-7.4.12, starting, Nodegroup: 0)

id=3 @172.31.29.118  (mysql-5.6.31 ndb-7.4.12, starting, Nodegroup: 0)

 

[ndb_mgmd(MGM)] 1 node(s)

id=1 @172.31.22.251  (mysql-5.6.31 ndb-7.4.12)

 

[mysqld(API)] 2 node(s)

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

id=5 (not connected, accepting connect from 172.31.23.227)

Can you help me?

I've fix this trouble. In AWS, The 8GB memory is not enough by this seting. I've updated to 16GB memory, It's connected cluster and sql node is runnig.

Hello,

Thank's for this how-to !

For data node configuration, I have to set [ndbcluster] instead of ndbcluster in /etc/my.cnf to make MySQL start : 

# MySQL Config[mysqld]datadir=/usr/local/mysql/datasocket=/tmp/mysql.sockuser=mysql # Run ndb storage engine[ndbcluster]# IP address management nodendb-connectstring=192.168.1.11 [mysql_cluster]# IP address management nodendb-connectstring=192.168.1.11 # MySQL Pid and Log[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

Cheers,

Hi, I successfully ran Mysql cluster in my virtual machine.

But Mysql cluster can't run when i try it in my VPSs. Each VPS have a different IP Public in different location.

After i ran 'ndbd --initial'  in data node, then in management node stuck in 'starting' state.

Any idea?

Thank you..

 Hello I set this up yesterday and it seemed to work fine but now each time after creating the file in VIM it gets these errors on the next command?

2017-12-14 13:25:25 [MgmtSrvr] ERROR    -- at line 2: [DB] Unknown parameter: OfReplicas2017-12-14 13:25:25 [MgmtSrvr] ERROR    -- at line 2: Could not parse name-value pair in config file.2017-12-14 13:25:25 [MgmtSrvr] ERROR    -- Could not load configuration from '/var/lib/mysql-cluster/config.ini'2017-12-14 13:25:25 [MgmtSrvr] ERROR    -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid=<nodeid                       > on command line

but if I change the config to add node id's it still produces the same error?

Thanks in advance

Hi, I need your help.

i try to setup Mysql Cluster with two data node, one management node and one sql node. process setup is success i try to testing. i create a databases ( testing) and  i create one tables ( Tables_testing ) on sql node, next i check on data node, databases testing success to create on data node but tables Tables_testing no create on data node, so only database is success. why ?

 

can you help me to resolve this issue ?

 

 

thank you

Khai

You can fix with this

cd /usr/local/

chown -R mysql:mysql mysql

When is the mysql.sock file in /tmp/ created? I followed the node guide step by step and I cannot complete the "mysql_secure_installation" step because there is no /tmp/mysql.sock file.

This is created by MySQL when it is started. Try to start or restart mysql.

Hello till, thanks for your reply.

When is MySQL supposed to be started? Do I have to install MySQL server individually?

Also, I'm following this tutorial on Ubuntu 18.04. I don't think that's an issue, but maybe the mysql.sock (or mysqld.sock, idk if they're the same) is located somewhere else.

Oh, also, when I changed the location of the .sock file in /etc/my.cnf file, seems like the changes weren't being effective... mysql_secure_installation kept taking the old location. Any ideas of why that happened?

I have a problem with the data node when i try to connect with a EC2 instance of AWS. I got this message.

ndbd --initial

2021-06-27 22:22:22 [ndbd] INFO     -- Angel connected to '181.198.241.207:1186'

2021-06-27 22:22:22 [ndbd] INFO     -- Angel allocated nodeid: 3

2021-06-27 22:22:22 [ndbd] ERROR    -- Could not fetch configuration/invalid configuration, error: 'The hostname this node should have according to the configuration does not match a local interface. Attempt to bind '18.116.*.*' failed with error: 99 'Cannot assign requested address''How can i solve this problem?