Menu

MySQL Cluster – Missing Piece

July 4, 2018 - Server Maintenance
MySQL Cluster – Missing Piece

If you are brave enough to using latest version of MySQL Cluster (current version: 7.6.6) keep in mind that some settings has been moved. For example, if you used to place DataMemory config in [ndbd default] section, please save your time by move it to each [ndbd] section.

For example:

This should work

[ndb_mgmd]
# Management process options:
hostname=manager.sql # Hostname of the manager
datadir=/var/lib/mysql-cluster # Directory for the log files

[ndbd]
hostname=node01.sql # Hostname of the first data node
datadir=/usr/local/mysql/data # Remote directory for the data files
DataMemory=7G

[ndbd]
hostname=node02.sql # Hostname of the second data node
datadir=/usr/local/mysql/data # Remote directory for the data files
DataMemory=7G

[mysqld]
# SQL node options:
hostname=manager.sql # In our case the MySQL server/client is on the same Droplet as the cluster manager

[NDBD DEFAULT]

While this settings below won’t affect anything.

[ndb_mgmd]
# Management process options:
hostname=manager.sql # Hostname of the manager
datadir=/var/lib/mysql-cluster # Directory for the log files

[ndbd]
hostname=node01.sql # Hostname of the first data node
datadir=/usr/local/mysql/data # Remote directory for the data files

[ndbd]
hostname=node02.sql # Hostname of the second data node
datadir=/usr/local/mysql/data # Remote directory for the data files

[mysqld]
# SQL node options:
hostname=manager.sql # In our case the MySQL server/client is on the same Droplet as the cluster manager

[NDBD DEFAULT]
DataMemory=7G

Another note, when installing node on Debian 9, I used the installer from https://dev.mysql.com/downloads/cluster/ and select Debian Linux 9 (x86, 64-bit), DEB Bundle. After extracting, here is the sequence of commands that I’ve been use to install the node correctly:

apt install python-paramiko libclass-methodmaker-perl libaio1
dpkg -i mysql-cluster-community-auto-installer_7.6.6-1debian9_amd64.deb
apt install libnuma1 libatomic1
dpkg -i mysql-common_7.6.6-1debian9_amd64.deb
dpkg -i mysql-cluster-community-data-node_7.6.6-1debian9_amd64.deb

Hope it would save anyone time that had a hard time configuring this little beast.

Leave a Reply

Your email address will not be published. Required fields are marked *