MySQL Forums :: NDB clusters :: MySQL Cluster setup for a private network


Advanced Search

MySQL Cluster setup for a private network
Posted by: Mikael Ronström ()
Date: January 18, 2017 02:14AM

The previous question on the forum regarding use of private
versus public IP addresses made me think about how to achieve
a setup of the MySQL Cluster where all MySQL Server ports are
using public IP addresses whereas all communication with
NDB data nodes and the management server is using a private
network to ensure that the data nodes and management server
is not possible to connect to using the public network.

This assumes that the data nodes and management server only have
one IP address which is part of the private network. The MySQL
Server(s) have one IP address connected to the private network
and one connected to the public network.

Here is how one could do that for a small cluster with 2 data
nodes, 1 SQL node and 1 management server.

1) Write the following config file (there could be more details
needed, here I focus on the network setup).

[NDB_MGMD]
NodeId: 49
Hostname: private_ip_addr_mgm_server

[NDBD]
NodeId: 1
Hostname: private_ip_addr_data_node_1

[NDBD]
NodeId: 2
Hostname: private_ip_addr_data_node_2

[MYSQLD]
NodeId: 53
Hostname: private_ip_addr_mysql_server

Next we want to start the MySQL Server with
the parameter
--bind-address=public_ip_addr_mysql_server

Finally when starting the MySQL Server we
want to use the following NDB connectstring
--ndb-connectstring="bind-address=private_ip_addr_mysql_server, private_ip_addr_mgm_server"

We also set the node id of the MySQL Server to 53 when
starting it to ensure that we get the correct Hostname
used for communicating with the NDB data nodes by
using:
--ndb-nodeid=53
when starting the MySQL Server.

The NDB connectstring ensures that we use the private
IP address for setting up the communication to the management
server. The node id ensures that we set up the transporters
to connect to the data nodes using the private IP address.
The last part on setting the node id might not be absolutely
required, but definitely what I would recommend to ensure that
we know exactly how the setup is done.

Options: ReplyQuote


Subject Views Written By Posted
MySQL Cluster setup for a private network 195 Mikael Ronström 01/18/2017 02:14AM


Sorry, only registered users may post in this forum.

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.