MySQL Forums
Forum List  »  NDB clusters

Re: SQL Node failed to start
Posted by: Chuck Rock
Date: June 14, 2018 09:08AM

That is pretty much all I did. I'm using CentOS 7 for all the machines.

I removed all the previous installation files and started over with each machine. Not the O/S, just all the MySQL software.

rpm -e or yum erase.

The one major thing I did different this time was use the auto-installer under Windows.

All the videos I could find used the auto-installer from windows instead of Linux. I honestly don't know if that matters, but I put the installer on my workstation and went from there.

Another thing, if you didn't do it, is to make sure you connect ssh from the installer computer to each machine first. This will get you to accept the connection question so the installer doesn't error out on that.

This is the video I watched. https://www.youtube.com/watch?v=nYiIwgjcRWI

After the first failure, I realized what I had to tweak and it worked for me other than the API nodes.

What I haven't seen noted was that on each computer the software is being installed on, I had to install these from the zip file manually before trying the installer.

rpm -Uvh perl-Class-MethodMaker-2.20-1.el7.x86_64.rpm
yum -y install perl-Data-Dumper
rpm -e --nodeps mariadb-libs
rpm -Uvh mysql-cluster-community-common-7.5.10-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-libs-7.5.10-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-client-7.5.10-1.el7.x86_64.rpm
yum install libaio
rpm -Uvh mysql-cluster-community-server-7.5.10-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-data-node-7.5.10-1.el7.x86_64.rpm
mkdir /var/lib/MySQL_Cluster/

The management servers also needs these.

rpm -Uvh mysql-cluster-community-common-7.6.6-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-libs-7.6.6-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-client-7.6.6-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-management-server-7.6.6-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-server-7.6.6-1.el7.x86_64.rpm
yum install python-paramiko python2-crypto
rpm -Uvh mysql-cluster-community-auto-installer-7.6.6-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-ndbclient-7.6.6-1.el7.x86_64.rpm

Data node:
rpm -Uvh mysql-cluster-community-data-node-7.6.6-1.el7.x86_64.rpm

My guess is either I needed to install something else on the API/management nodes to get the API part to start, or I missed something else.

I hope this helps.

Chuck

Options: ReplyQuote


Subject
Views
Written By
Posted
1008
June 04, 2018 11:17AM
465
June 06, 2018 10:32AM
471
June 13, 2018 01:09PM
Re: SQL Node failed to start
1152
June 14, 2018 09:08AM
528
June 17, 2018 05:13AM
368
June 18, 2018 08:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.