Skip to content

Instantly share code, notes, and snippets.

@mazdel
Created June 20, 2025 19:04
Show Gist options
  • Select an option

  • Save mazdel/f3bd9ae3eddf03d723103d5ab78f5102 to your computer and use it in GitHub Desktop.

Select an option

Save mazdel/f3bd9ae3eddf03d723103d5ab78f5102 to your computer and use it in GitHub Desktop.
# ===============================================================
# MySQL NDB Cluster Configuration
#
# - Total Data Nodes: 4
# - Partitions (Node Groups): 2
# - Replicas (Backups per partition): 2
# ===============================================================
[ndbd default]
# This sets the replication factor. 2 replicas means 1 primary + 1 backups.
NoOfReplicas=2
DataMemory=2G
MaxNoOfConcurrentOperations=1000000
MaxNoOfAttributes=2560000
MaxNoOfTables=1024
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=1024
# -- Management Nodes (ndb_mgmd) --
# Two for redundancy is recommended.
[ndb_mgmd]
NodeId=11
hostname=172.16.3.11
datadir=/var/lib/mysql
[ndb_mgmd]
NodeId=12
hostname=172.16.3.12
datadir=/var/lib/mysql
# -- Data Nodes (ndbd) --
# Node Group 0
[ndbd]
NodeId=31
hostname=172.16.3.31
NodeGroup=0
datadir=/var/lib/mysql
[ndbd]
NodeId=32
hostname=172.16.3.32
NodeGroup=0
datadir=/var/lib/mysql
# Node Group 1
[ndbd]
NodeId=41
hostname=172.16.3.41
NodeGroup=1
datadir=/var/lib/mysql
[ndbd]
NodeId=42
hostname=172.16.3.42
NodeGroup=1
datadir=/var/lib/mysql
# MySQL Interface
[mysqld]
NodeId=20
hostname=172.16.3.20
[mysqld]
NodeId=21
hostname=172.16.3.21
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment