MySQLCluster構築 - のんびりSE備忘録 @ ウィキ

管理ノード手順

• データディレクトリ作成

# mkdir /var/lib/mysql-cluster
# chown mysql:mysql /var/lib/mysql-cluster
# chmod 750 /var/lib/mysql-cluster

• rpmインストール

# rpm -ivh MySQL-Cluster-gpl-management-7.0.6-0.rhel4.x86_64.rpm
# rpm -ivh MySQL-Cluster-gpl-tools-7.0.6-0.rhel4.x86_64.rpm

• config作成

# vi /var/lib/mysql-cluster/config.ini
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id= 1
HostName= 192.168.100.98

[ndbd]
Id= 2
HostName= 192.168.100.100

[ndbd]
Id= 3
HostName= 192.168.100.101

[mysqld]
Id = 4
HostName= 192.168.100.100

[mysqld]
Id= 5
HostName= 192.168.100.101

# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
PortNumber= 63132

# chmod 644 /var/lib/mysql-cluster/config.ini
# chown mysql:mysql /var/lib/mysql-cluster/config.ini

• 管理ノード起動

# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2009-07-10 13:42:22 [MgmSrvr] INFO     -- NDB Cluster Management Server. mysql-5.1.34 ndb-7.0.6
2009-07-10 13:42:22 [MgmSrvr] INFO     -- The default config directory '//mysql-cluster' does not exist. Trying to create it...
2009-07-10 13:42:22 [MgmSrvr] INFO     -- Sucessfully created config directory
2009-07-10 13:42:22 [MgmSrvr] INFO     -- Reading cluster configuration from '/var/lib/mysql-cluster/config.ini'

# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2 (not connected, accepting connect from 192.168.100.100)
id=3 (not connected, accepting connect from 192.168.100.101)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.100.98  (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)]   2 node(s)
id=4 (not connected, accepting connect from 192.168.100.100)
id=5 (not connected, accepting connect from 192.168.100.101)

データノード手順

• データディレクトリ作成

# mkdir /var/lib/mysql-cluster
# chown mysql:mysql /var/lib/mysql-cluster
# chmod 750 /var/lib/mysql-cluster

• rpmインストール

# rpm -ivh MySQL-Cluster-gpl-tools-7.0.6-0.rhel4.x86_64.rpm
# rpm -ivh MySQL-Cluster-gpl-storage-7.0.6-0.rhel4.x86_64.rpm

• my.cnf編集

# vi /etc/my.cnf
[mysql_cluster]
ndb-connectstring = 192.168.100.98

• ndbd起動（初回起動）

# ndbd --initial

• 管理ノードで実行

# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.100.100  (mysql-5.1.34 ndb-7.0.6, starting, Nodegroup: 0)
id=3    @192.168.100.101  (mysql-5.1.34 ndb-7.0.6, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.100.98  (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)]   2 node(s)
id=4 (not connected, accepting connect from 192.168.100.100)
id=5 (not connected, accepting connect from 192.168.100.101)

SQLノード手順

• rpmインストール

# rpm -ivh MySQL-Cluster-gpl-server-7.0.6-0.rhel4.x86_64.rpm
# rpm -ivh MySQL-Cluster-gpl-client-7.0.6-0.rhel4.x86_64.rpm
# rpm -ivh MySQL-Cluster-gpl-shared-7.0.6-0.rhel4.x86_64.rpm

• my.cnf編集

# vi /etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring = 192.168.100.98

• mysql起動

# mysql_install_db --user=mysql
# /etc/init.d/mysql start

• 管理ノードで実行

# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.100.100  (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0, Master)
id=3    @192.168.100.101  (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.100.98  (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)]   2 node(s)
id=4    @192.168.100.100  (mysql-5.1.34 ndb-7.0.6)
id=5    @192.168.100.101  (mysql-5.1.34 ndb-7.0.6)