Simple configuration of Mysql database cluster
Environment:
192.168.5.155 mysql-mgm-node
192.168.5.156 mysql-sql-node1 mysql-data-node1
192.168.5.157 mysql-sql-node2 mysql-data-node2
Download the cluster software and upload it to each server.
1. Install the MGM node:
Create an installation directory
Mkdir-p / usr/local/mysql/bin
Mkdir-p / usr/local/mysql/ndbdata
Add execution file path
Vi / .bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
Copy execution file
Cp bin/ndb_mgmd / usr/local/mysql/bin
Cp bin/ndb_mgm / usr/local/mysql/bin
Create a log file storage directory
Mkdir / var/log/mysql-cluster
Create configuration file directories and files
Mkdir / usr/local/mysql/cluster-conf
Vi / usr/local/mysql/cluster-conf/config.ini
Edit the configuration file:
[ndbd default]
NoOfReplicas=2
DataMemory=2048M
IndexMemory=512M
[ndb_mgmd]
Id=1
Hostname=192.168.5.155
DataDir=/var/log/mysql-cluster
[ndbd]
Id=11
HostName=192.168.5.156
DataDir=/usr/local/mysql/ndbdata
[ndbd]
Id=12
HostName=192.168.5.157
DataDir=/usr/local/mysql/ndbdata
[mysqld]
Id=21
HostName=192.168.5.156
[mysqld]
Id=22
HostName=192.168.5.157
[mysqld]
Id=23
2. Install data node and SQL node:
Yum install libaio
# groupadd mysql
# useradd mysql-g mysql
# mv mysql-cluster-gpl-7.2.9-linux2.6-x86_64.tar.gz / usr/local/
# cd / usr/local/
# tar zxvf mysql-cluster-gpl-7.2.9-linux2.6-x86_64.tar.gz
# rm-f mysql-cluster-gpl-7.2.9-linux2.6-x86_64.tar.gz
# mv mysql-cluster-gpl-7.2.9-linux2.6-x86_64 mysql
# chown-R mysql:mysql mysql
# cd mysql
# scripts/mysql_install_db-user=mysql
# cp support-files/my-medium.cnf / etc/my.cnf
# cp support-files/mysql.server / etc/init.d/mysqld
# vi / etc/my.cnf
Add:
Datadir=/usr/local/mysql/data/
Ndbcluster
Ndb-connectstring=192.168.5.155
[ndbd]
Connect-string=192.168.5.155
[mysql_cluster]
Ndb-connectstring=192.168.5.155
[ndb_mgm]
Connect-string=192.168.5.155
[ndb_mgmd]
Config-file=/var/lib/mysql-cluster/config.ini
3. Start related services
(1) start the services related to the management node:
# / usr/local/mysql/bin/ndb_mgmd-f / var/lib/mysql-cluster/config.ini
# netstat-lntpu
Tcp 0 0 0.0.0. 0. 0. 0. 0. 0. 0. 0. 0.
LISTEN 22907/ndb_mgmd
(2) start data node related services:
# / usr/local/mysql/bin/ndbd-- initial (the parameter-- initial is required for the first startup)
# netstat-lntpu
Mkdir / usr/local/mysql/ndbdata
Chmod 755 / usr/local/mysql/ndbdata
# service mysqld start
4. Functional testing:
[root@localhost bin] #. / ndb_mgm
-NDB Cluster-Management Client--
Ndb_mgm > show
Connected to Management Server at: localhost:1186
Cluster Configuration
-
[ndbd (NDB)] 2 node (s)
Id=11 @ 192.168.5.156 (mysql-5.5.28 ndb-7.2.9, Nodegroup: 0)
Id=12 @ 192.168.5.157 (mysql-5.5.28 ndb-7.2.9, Nodegroup: 0, Master)
[ndb_mgmd (MGM)] 1 node (s)
Id=1 @ 192.168.5.155 (mysql-5.5.28 ndb-7.2.9)
[mysqld (API)] 3 node (s)
Id=21 @ 192.168.5.156 (mysql-5.5.28 ndb-7.2.9)
Id=22 @ 192.168.5.157 (mysql-5.5.28 ndb-7.2.9)
Id=23 (not connected, accepting connect from any host)
You can close master to see whether the master status is transferred to another server; when An is off, modify B database and start A to see if the data is synchronized.
