MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle.
RPMs are available for both 32-bit and 64-bit Linux platforms. The filenames for these RPMs use the following pattern:
MySQL-Cluster-component
-producttype
-ndbversion
.distribution
.architecture
.rpmcomponent
:= {server | client [|other
]}producttype
:= {gpl | advanced}ndbversion
:=major
.minor
.release
distribution
:= {sles10 | rhel5 | el6}architecture
:= {i386 | x86_64}
The component
can be
server
or client
. (Other
values are possible, but since only the
server
and client
components are required for a working NDB Cluster installation,
we do not discuss them here.) The
producttype
for Community RPMs
downloaded from https://dev.mysql.com/downloads/cluster/ is
always gpl
; advanced
is
used to indicate commercial releases.
ndbversion
represents the three-part
NDB
storage engine version number in
7.3.x
or
7.4.x
format. The
distribution
can be one of
sles11
(SUSE Enterprise Linux 11),
rhel5
(Oracle Linux 5, Red Hat Enterprise
Linux 4 and 5), or el6
(Oracle Linux 6, Red
Hat Enterprise Linux 6) The
architecture
is
i386
for 32-bit RPMs and
x86_64
for 64-bit versions.
For an NDB Cluster, one and possibly two RPMs are required:
The server
RPM (for example,
MySQL-Cluster-server-gpl-7.3.32-1.sles11.i386.rpm
or
MySQL-Cluster-server-gpl-7.4.31-1.sles11.i386.rpm
),
which supplies the core files needed to run a MySQL Server
with NDBCLUSTER
storage engine
support (that is, as an NDB Cluster SQL node) as well as all
NDB Cluster executables, including the management node, data
node, and ndb_mgm client binaries. This
RPM is always required for installing NDB Cluster.
If you do not have your own client application capable of
administering a MySQL server, you should also obtain and
install the client
RPM (for example,
MySQL-Cluster-client-gpl-7.3.32-1.sles11.i386.rpm
or
MySQL-Cluster-client-gpl-7.4.31-1.sles11.i386.rpm
),
which supplies the mysql client
The NDB Cluster version number in the RPM file names (shown here
as 7.3.32
or
7.4.31
, depending on
whether you are installing NDB Cluster 7.3 or NDB Cluster 7.4)
can vary according to the version which you are actually using.
It is very important that all of the Cluster RPMs to
be installed have the same version number. The
architecture
designation should also
be appropriate to the machine on which the RPM is to be
installed; in particular, you should keep in mind that 64-bit
RPMs cannot be used with 32-bit operating systems.
Data nodes.
On a computer that is to host a cluster data node it is
necessary to install only the server
RPM.
To do so, copy this RPM to the data node host, and run the
following command as the system root user, replacing the name
shown for the RPM as necessary to match that of the RPM
downloaded from the MySQL website:
shell> rpm -Uhv MySQL-Cluster-server-gpl-7.3.32-1.sles11.i386.rpm
or
shell> rpm -Uhv MySQL-Cluster-server-gpl-7.4.31-1.sles11.i386.rpm
Although this installs all NDB Cluster binaries, only the
program ndbd or ndbmtd
(both in /usr/sbin
) is actually needed to
run an NDB Cluster data node.
SQL nodes.
On each machine to be used for hosting a cluster SQL node,
install the server
RPM by executing the
following command as the system root user, replacing the name
shown for the RPM as necessary to match the name of the RPM
downloaded from the MySQL website:
shell> rpm -Uhv MySQL-Cluster-server-gpl-7.3.32-1.sles11.i386.rpm
or
shell> rpm -Uhv MySQL-Cluster-server-gpl-7.4.31-1.sles11.i386.rpm
This installs the MySQL server binary
(mysqld) with
NDB
storage engine support in the
/usr/sbin
directory, as well as all needed
MySQL Server support files. It also installs the
mysql.server and
mysqld_safe startup scripts (in
/usr/share/mysql
and
/usr/bin
, respectively). The RPM installer
should take care of general configuration issues (such as
creating the mysql
user and group, if needed)
automatically.
To administer the SQL node (MySQL server), you should also
install the client
RPM, as shown here:
shell> rpm -Uhv MySQL-Cluster-client-gpl-7.3.32-1.sles11.i386.rpm
or
shell> rpm -Uhv MySQL-Cluster-client-gpl-7.4.31-1.sles11.i386.rpm
This installs the mysql client program.
Management nodes.
To install the NDB Cluster management server, it is necessary
only to use the server
RPM. Copy this RPM
to the computer intended to host the management node, and then
install it by running the following command as the system root
user (replace the name shown for the RPM as necessary to match
that of the server
RPM downloaded from the
MySQL website):
shell> rpm -Uhv MySQL-Cluster-server-gpl-7.3.32-1.sles11.i386.rpm
or
shell> rpm -Uhv MySQL-Cluster-server-gpl-7.4.31-1.sles11.i386.rpm
Although this RPM installs many other files, only the management
server binary ndb_mgmd (in the
/usr/sbin
directory) is actually required
for running a management node. The server
RPM
also installs ndb_mgm, the
NDB
management client.
See Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”, for general information about installing MySQL using RPMs supplied by Oracle.
After installing from RPM, you still need to configure the cluster as discussed in Section 18.2.3, “Initial Configuration of NDB Cluster”.