22.2.2.1 Installing an NDB Cluster Binary Release on Linux

Check your /etc/passwd and /etc/group files (or use whatever tools are provided by your operating system for managing users and groups) to see whether there is already a mysql group and mysql user on the system. Some OS distributions create these as part of the operating system installation process. If they are not already present, create a new mysql user group, and then add a mysql user to this group:

shell> groupadd mysql
shell> useradd -g mysql -s /bin/false mysql

The syntax for useradd and groupadd may differ slightly on different versions of Unix, or they may have different names such as adduser and addgroup.

Change location to the directory containing the downloaded file, unpack the archive, and create a symbolic link named mysql to the mysql directory.

shell> cd /var/tmp
shell> tar -C /usr/local -xzvf mysql-cluster-gpl-8.0.19-linux-glibc2.12-x86_64.tar.gz
shell> ln -s /usr/local/mysql-cluster-gpl-8.0.19-linux-glibc2.12-x86_64 /usr/local/mysql

Change location to the mysql directory and set up the system databases using mysqld --initialize as shown here:

shell> cd mysql
shell> mysqld --initialize

This generates a random password for the MySQL root account. If you do not want the random password to be generated, you can substitute the --initialize-insecure option for --initialize. In either case, you should review Section 2.10.1, “Initializing the Data Directory”, for additional information before performing this step. See also Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”.

Set the necessary permissions for the MySQL server and data directories:

shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .

Copy the MySQL startup script to the appropriate directory, make it executable, and set it to start when the operating system is booted up:

shell> cp support-files/mysql.server /etc/rc.d/init.d/
shell> chmod +x /etc/rc.d/init.d/mysql.server
shell> chkconfig --add mysql.server

(The startup scripts directory may vary depending on your operating system and version—for example, in some Linux distributions, it is /etc/init.d.)

Here we use Red Hat's chkconfig for creating links to the startup scripts; use whatever means is appropriate for this purpose on your platform, such as update-rc.d on Debian.

Change location to the /var/tmp directory, and extract the ndbd and ndbmtd binaries from the archive into a suitable directory such as /usr/local/bin:

shell> cd /var/tmp
shell> tar -zxvf mysql-cluster-gpl-8.0.19-linux-glibc2.12-x86_64.tar.gz
shell> cd mysql-cluster-gpl-8.0.19-linux-glibc2.12-x86_64
shell> cp bin/ndbd /usr/local/bin/ndbd
shell> cp bin/ndbmtd /usr/local/bin/ndbmtd

(You can safely delete the directory created by unpacking the downloaded archive, and the files it contains, from /var/tmp once ndb_mgm and ndb_mgmd have been copied to the executables directory.)

Change location to the directory into which you copied the files, and then make both of them executable:

shell> cd /usr/local/bin
shell> chmod +x ndb*

Change location to the /var/tmp directory, and extract the ndb_mgm and ndb_mgmd from the archive into a suitable directory such as /usr/local/bin:

shell> cd /var/tmp
shell> tar -zxvf mysql-cluster-gpl-8.0.19-linux-glibc2.12-x86_64.tar.gz
shell> cd mysql-cluster-gpl-8.0.19-linux-glibc2.12-x86_64
shell> cp bin/ndb_mgm* /usr/local/bin

(You can safely delete the directory created by unpacking the downloaded archive, and the files it contains, from /var/tmp once ndb_mgm and ndb_mgmd have been copied to the executables directory.)

Change location to the directory into which you copied the files, and then make both of them executable:

shell> cd /usr/local/bin
shell> chmod +x ndb_mgm*