【MySQL Cluster構築:2】管理ノード編

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)