mysql-cluster7.5

Data nodes:

Shell> RPM-UHV mysql-cluster-community-data-node-7.5.5-1.1.el7.x86_64.rpm

SQL nodes:

Shell> RPM-UHV mysql-cluster-community-server-7.5.5-1.1.el7.x86_64.rpm
Shell> RPM-UHV mysql-cluster-community-client-7.5.5-1.1.el7.x86_64.rpm

Management nodes:

Shell> RPM-UHV mysql-cluster-commercial-management-server-7.5.5-1.1.el7.x86_64.rpm

Configuring the data nodes and SQL nodes:
Shell> vi/etc/my.cnf
[Mysqld]
Ndbcluster # run NDB storage engine
[Mysql_cluster]
NDB-CONNECTSTRING=192.168.0.10 # Location of Management Server

Configuring the Management node:
Shell> Mkdir/var/lib/mysql-cluster
Shell> Cd/var/lib/mysql-cluster
Shell> VI Config.ini

[NDBD Default]
noofreplicas=2 # of Replicas
datamemory=80m # How much memory to allocate for data storage
indexmemory=18m # How much memory to allocate for index storage

[TCP Default]
# TCP/IP options:
portnumber=2202 # this default; However, you can use any

[NDB_MGMD]
HOSTNAME=192.168.0.10 # hostname or IP address of MGM node
Datadir=/var/lib/mysql-cluster # Directory for MGM node log files

[NDBD]
HOSTNAME=192.168.0.30 # hostname or IP address
Datadir=/usr/local/mysql/data # Directory for this data node ' s data files

[NDBD]
HOSTNAME=192.168.0.40 # hostname or IP address
Datadir=/usr/local/mysql/data # Directory for this data node ' s data files

[Mysqld]
HOSTNAME=192.168.0.20 # hostname or IP address

Cluster management nodes is 1186; The default port for data nodes is 2202.

On the management host:
Shell> ndb_mgmd-f/var/lib/mysql-cluster/config.ini

On the data node hosts:
Shell> NDBD

On each of the SQL node hosts:
Shell> Mysqld_safe &
Shell> Mysqld_safe--user=mysql &

Safe Shutdown and Restart of MySQL Cluster
Shell> ndb_mgm-e shutdown

mysql-cluster7.5