Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

installing MySQL cluster 7.6.6 management node, SQL node and data node

Hi,

Now our MySQL cluster test platform do not have internet connection and we need to setup local repository for it.

I check out a lot of googled page and it seems no one exactly match what I am going to install, let see what I go from latest MySQL cluster 7.6.6 binary:

User generated image
so for management node, which rpm I should install and what is the command for it? just yum --noplugin localinstall <rpm name> ?

For data node, which rpm I should install?

For SQL  node, which rpm I should install ?
ASKER CERTIFIED SOLUTION
Avatar of Prabhin MP
Prabhin MP
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marrowyung
marrowyung

ASKER

hi,

the reason I show you is, I have a lot of study on that and finally as the MySQL Cluster 7.6.6 binary file name is NOT the same, so some procedure doesn't work and that's why I give you the file list.

As our machine do not have internet connection, that yum install command is not going to work for us.

also what is data dumper is about, we don't have it, that's one of the reason I come here.
According to me, you can achieve this clustering using the above documents.
if you don't have an internet connection, download the RPM files and install it.
In the above document, they are using yum only for installing dependencies.

Download all the files into a pen drive and move to server and install it.
"Download all the files into a pen drive and move to server and install it."

seems only the local repository will help on that, right?

tried to only rpm that but it will keep asking rpm dependency which I can't see where I can downoload it.

"In the above document, they are using yum only for installing dependencies."

you mean must need internet connection.
rather than strugllling like this, it's better to provide internet connection. either proxy nor direct.
because while installing these type of packages you need to satisfy the dependencies.
Every time you cannot download each and every dependency and move to the server.

Hope you understood what I'm saying
"Every time you cannot download each and every dependency and move to the server."

hi don't understand what you are saying

so by my files list, please suggest of rpm need for each of the node.
it's very difficult to install the package without an internet connection.
yeah, exactly! how about local repository  ?
so actually downloading the rpm doesn't make any sense at all, right?

yum doesn't works anyway in that situation.

but based on my screenshot, what rpm should I install for management node, data node and SQL node?

I can't do this already:

yum -y install perl-Data-Dumper

Open in new window


no data dumper at all.
yeah setting up local repo might help you
but that "no data dumper at all.", still as problem, that's why I list you the file list now and you can tell me which one to use for each node.

I am at the same time, working with mariaDB on MariaDB configuration, seems very easy to die !!! :):):):

now troubleshooting it.

mariaDB is a good helper and they keep helping me even I don't pay them. same as you ... :):)
what... one more rpm....... I tried similiar rpm before, but won't work....... :):)
hi,

one thing, we are enabling internet connection on all DB test machine to test the yum, but we do not allow ALL connection, so what internet domain we have to allow in order to get yum to work?

we are now allow:

1) *. centos.org.
2) *.mysql.com
3) *.fedoraproject.org
4) *.redhat.com

any other domain else?

any URL tell us ?
check the repo file and check the domains included in that.
I mean what is the full list of domain I should include, we keep seeing we missed some.

repo file is the linux repo file ? /etc/yum.repos.d/rhel7dvd.repo ?
Inside all the repository file have the domain name. so white list those..
hi,

in my file: /etc/yum.repos.d/rhel7dvd.repo , the content is :

User generated image
what to check? baseurl ? I am looking what else domain I need to add to make MariaDB and MySQL cluster yum installation works perfectly.

also what tools you use to connect to MariaDB?  workbench is not compatible with it!
hi,

when following this link:
https://www.howtoforge.com/tutorial/how-to-install-and-configure-mysql-cluster-on-centos-7/

when installing management node, this command:

yum -y install perl-Data-Dumper, this errors shown:

User generated image
User generated image
User generated image
is that mean I have to allow internet access to the domain shown in the HTTP error ?
Doesn't looks like that. For confirming can you enable internet and try.
no man.

"or confirming can you enable internet and try."

what URL or domain I have to allow internet to access?
You're getting errors when yum tries to connect to the any of the download sites (mirrors).

If you can enable access to any of them (probably the one on the top of the list so you don't see failures before success) the installation / upgrade has a chance.

Kent
you mean the one shown has HTTP error 403 ?
Yes.  The tool needs to connect to one of the mirrors to download the package and allowing access to any of those mirrors should work fine without compromising your network safety.
"any of those"

any but not all ?
I applied access to all of them listed, let's see what still missing..
I think you're making this harder than's required.

Some way you can access your cluster, because you'll have to populate your local repository some way.

If I had to do this, I wouldn't run a repository, I'd just rsync all the MariaDB package files to each node in the cluster.

Be sure you use MariaDB (working version of MySQL). Many Distros are switching completely to where MariaDB packages install when MySQL package targets/names are installed.

Also, if you're starting a new project, do yourself a favor + use Ubuntu rather than a RedHat derivative (your use of RPM files suggests this).

The primary reason is Ubuntu uses far more recent Kernels, so if you use an RPM based system you may end up dealing with Kernel problems which have been fixed for years, if you use Ubuntu.

Working with database clustering is super complex even with latest Kernels. Trying to debug problems on old Kernels... geez... I'd suggest you go with latest Kernels + skip trying to figure out if problems you have are database related or Kernel related.
hi Prabhin MP,

"Download perl data dumper from here,"

internet connection enabled for the domain in the list and this one seems working:

"yum -y install perl-Data-Dumper"

but I am looking this link : https://www.howtoforge.com/tutorial/how-to-install-and-configure-mysql-cluster-on-centos-7/

and when down to this steps on installing management node:

rpm -Uvh MySQL-Cluster-client-gpl-7.4.10-1.el7.x86_64.rpm

it complains :

User generated image
any idea ?

I want to kick off the auto installer, which node should i run the auto installer and what is the command for it?

it seems now all depends on the client module rpm !! even auto installer. So how can I find the perl module ?
David,

"I think you're making this harder than's required."

I am not sure, first time to install this ! what I read is using auto installer is better, but read above, it also depends on the client rpm and that rpm depends on the perl module! enabling the internet URL for yum to download doesn't include that.

" I'd just rsync all the MariaDB package files to each node in the cluster."

you mean setup local repository and download all rpm from MySQL.com and install it locally?

"Be sure you use MariaDB (working version of MySQL). Many Distros are switching completely to where MariaDB packages install when MySQL package targets/names are installed."

but I am install MysQL cluster, should I just use MysQL cluster rpm from MySQL.com ?

" rather than a RedHat derivative (your use of RPM files suggests this)."

already setup a redhat linux to simulate the real situtation .
hi all,
the perl module error still appear module when I am going to install the client RPM, it is the key point as by this :

https://www.howtoforge.com/tutorial/how-to-install-and-configure-mysql-cluster-on-centos-7/

all nodes need 3 x rpm to get ready, client rpm is one of this ! this is the bottleneck now.

User generated image
User generated image
where can I download this rpm ?
You mention...

David,

"I think you're making this harder than's required."

Open in new window


Be much easier for you if you setup an LXD environment, as I suggested in your other question.

The only hard part of any of this - trying to do what you're doing on a machine with no net connection.

If you fix the net connection issue, your entire complexity problem is solved instantly.

Refer to your other question, for how I typically arrange this type of setup for project work.
"Refer to your other question, for how I typically arrange this type of setup for project work."

We use VM anyway and MySQL staffs come here and say we should use MySQL Innodb cluster, NDB cluster is only for very high end requirement.

So we need to set it up again, and they DO NOT suggest YUM for installation but binary ! do you know how we get innodb cluster binary which don't need to yum ?

I only download tar and rpm,  if unzip tar it is another rpm, not binary at all, right ?
tks.
tks all, we forge NDB cluster and go for InnodB, please help on respective question if you have time.

MySQL product is a strange, can't cross site natively, must use replication ! then I can't see why people still using it except the reason  that MariaDB do not have local support in some country, like my country,