Deploys a new MySQL Cluster (NDB) by Oracle. The cluster consists of management nodes, MySQL API nodes, and data nodes. The database cluster will be automatically added into ClusterControl once deployed. A minimum of 4 nodes (2 SQL and management + 2 data nodes) is recommended.
Attention
Every data node must have at least 1.5 GB of RAM for the deployment to succeed.
General & SSH Settings
Field
Description
SSH User
Specify root if you have root credentials.
If you use sudo to execute system commands, specify the name that you wish to use here. The user must exist on all nodes. See Operating System User.
SSH Key Path
Specify the full path of the SSH key (the key must exist in the ClusterControl node) that will be used by the SSH User to perform passwordless SSH. See Passwordless SSH.
Sudo Password
If you use sudo with a password, specify it here. Ignore this if SSH User is root or sudoer does not need a sudo password.
SSH Port
Specify the SSH port for target nodes. ClusterControl assumes SSH is running on the same port on all nodes.
Cluster Name
Specify a name for the cluster.
Install Software
Check the box if you use clean and minimal VMs. Existing MySQL dependencies will be removed. New packages will be installed and existing packages will be uninstalled when provisioning the node with the required software. – If unchecked, existing packages will not be uninstalled, and nothing will be installed. This requires that the instances have already provisioned the necessary software.
Disable Firewall
Check the box to disable the firewall (recommended).
Disable AppArmor/SELinux
Check the box to let ClusterControl disable AppArmor (Ubuntu) or SELinux (RedHat/CentOS) if enabled (recommended).
Define Management Servers
Field
Description
Server Port
MySQL Cluster management port. Default to 1186.
Server Data Directory
MySQL Cluster data directory for NDB. Default is /var/lib/mysql-cluster.
Management Server 1
Specify the IP address or hostname of the first management server.
Management Server 2
Specify the IP address or hostname of the second management server.
Define Data Nodes
Field
Description
Server Port
MySQL Cluster data node port. Default to 2200.
Server Data Directory
MySQL Cluster data directory for NDB. Default is /var/lib/mysql-cluster.
Add Nodes
Specify the IP address or hostname of the MySQL Cluster data node. It’s recommended to have data nodes in pairs. You can add up to 14 data nodes to your cluster. Every data node must have at least 1.5GB of RAM.
Define MySQL Servers
Field
Description
my.cnf Template
MySQL configuration template file under /etc/cmon/templates or /usr/share/cmon/templates. See Base Template Files for details.
Server Port
MySQL server port. Default to 3306.
Server Data Directory
MySQL data directory. Default is /var/lib/mysql.
Root Password
Specify MySQL root password. ClusterControl will configure the same MySQL root password for all nodes in the cluster.
Add Nodes
Specify the IP address or hostname of the MySQL Cluster API node. You can use the same IP address with the management node, co-locate both roles in the same host.
Deploy
Starts the MySQL Cluster deployment.
Attention
Starting from ClusterControl 1.9.7 (September 2023), ClusterControl GUI v2 is the default frontend graphical user interface (GUI) for ClusterControl. Note that the GUI v1 is considered a feature-freeze product with no future development. All new developments will be happening on ClusterControl GUI v2. See User Guide (GUI v2).