Hello
I am following the guide:
https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04
My config files are as below:
Cluster-Manager Config file:
-----------------------------------
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=3500M # How much memory to allocate for data storage
IndexMemory=1000M # How much memory to allocate for index storage
MaxNoOfConcurrentOperations=1048576
MaxNoOfConcurrentTransactions= 1048576
MaxNoOfLocalOperations=1048576
MaxNoOfConcurrentIndexOperations=16384
MaxNoOfConcurrentScans=500
[ndb_mgmd]
# Management process options:
hostname=172.31.63.143 # Hostname of the manager
datadir=/var/lib/mysql-cluster # Directory for the log files
[ndbd]
hostname=172.31.50.227 # Hostname/IP of the first data node
NodeId=2 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[ndbd]
hostname=172.31.48.145 # Hostname/IP of the second data node
NodeId=3 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[ndbd]
hostname=172.31.52.45 # Hostname/IP of the second data node
NodeId=4 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[ndbd]
hostname=172.31.49.125 # Hostname/IP of the second data node
NodeId=5 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[mysqld]
# SQL node options:
hostname=172.31.63.143 # In our case the MySQL server/client is on the same Droplet as the cluster manager
NodeId=10
[mysqld]
# SQL node options:
hostname=172.31.55.144 # In our case the MySQL server/client is not on the same Droplet as the cluster manager
NodeId=11
[mysqld]
# SQL node options:
hostname=172.31.49.54 # In our case the MySQL server/client is not on the same Droplet as the cluster manager
NodeId=12
[API]
[API]
[API]
[API]
[API]
[API]
[API]
[API]
[API]
[API]
Data Node Config file:
--------------------------
[mysql_cluster]
# Options for NDB Cluster processes:
ndb-connectstring=172.31.63.143 # location of cluster manager
Server Config File:
-----------------------------------
[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
max_connections = 1000000
max_connect_errors=1000000
thread_cache_size=16384
back-log=65535
max_user_connections=1000000
ndb_cluster_connection_pool=16
ndb_autoincrement_prefetch_sz=65536
table_open_cache=524288
[mysql_cluster]
# Options for NDB Cluster processes:
ndb-connectstring=172.31.63.143 # location of management server
bind-address=0.0.0.0
Edited 2 time(s). Last edit at 06/23/2021 07:14AM by Deepak Goel.