1.準備編 → 2.管理ノード編 → 3.データー/SQLノード編
MySQLクラスタのrpmを本家から拾ってきてインストール
cent6-cluster-mgrで実施
shell
cd /usr/local/src/
wget http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.3/MySQL-Cluster-server-gpl-7.3.3-1.el6.x86_64.rpm
rpm -ivh MySQL-Cluster-server-gpl-7.3.3-1.el6.x86_64.rpm
結果準備中... ########################################### [100%] 1:MySQL-Cluster-server-gp########################################### [100%]
管理ノードのデータディレクトリと設定ファイルの作成
cent6-cluster-mgrで実施
shell
mkdir -p /var/lib/mysql-cluster
vi /var/lib/mysql-cluster/config.ini
/var/lib/mysql-cluster/config.ini[NDB_MGMD DEFAULT] Portnumber=1186 [NDB_MGMD] NodeId=1 HostName=192.168.1.100 DataDir=/var/lib/mysql-cluster Portnumber=1186 [TCP DEFAULT] SendBufferMemory=2M ReceiveBufferMemory=2M [NDBD DEFAULT] BackupMaxWriteSize=1M BackupDataBufferSize=16M BackupLogBufferSize=4M BackupMemory=20M BackupReportFrequency=10 MemReportFrequency=30 LogLevelStartup=15 LogLevelShutdown=15 LogLevelCheckpoint=8 LogLevelNodeRestart=15 DataMemory=1M IndexMemory=1M MaxNoOfTables=4096 MaxNoOfTriggers=3500 NoOfReplicas=2 StringMemory=25 DiskPageBufferMemory=64M SharedGlobalMemory=20M LongMessageBuffer=32M MaxNoOfConcurrentTransactions=16384 BatchSizePerLocalScan=512 FragmentLogFileSize=64M NoOfFragmentLogFiles=16 RedoBuffer=32M MaxNoOfExecutionThreads=2 StopOnError=false LockPagesInMainMemory=1 TimeBetweenEpochsTimeout=32000 TimeBetweenWatchdogCheckInitial=60000 TransactionInactiveTimeout=60000 HeartbeatIntervalDbDb=15000 HeartbeatIntervalDbApi=15000 [NDBD] NodeId=11 HostName=192.168.1.101 [NDBD] NodeId=12 HostName=192.168.1.102 [MYSQLD DEFAULT] [MYSQLD] NodeId=21 HostName=192.168.1.101 [MYSQLD] NodeId=22 HostName=192.168.1.102
管理ノード起動
cent6-cluster-mgrで実施
shell
ndb_mgmd -f /var/lib/mysql-cluster/config.ini
結果MySQL Cluster Management Server mysql-5.6.14 ndb-7.3.3
確認
shell
ndb_mgm -e show
結果Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=11 (not connected, accepting connect from 192.168.1.101) id=12 (not connected, accepting connect from 192.168.1.102) [ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.1.100 (mysql-5.6.14 ndb-7.3.3) [mysqld(API)] 2 node(s) id=21 (not connected, accepting connect from 192.168.1.101) id=22 (not connected, accepting connect from 192.168.1.102)