แบบฝึกหัดที่ 2 Setup a MySQL Cluster with Basic Configuration

# rpm -e --allmatches --nodeps mysql

# rpm -e --allmatches --nodeps mysql-devel

# rpm -e --allmatches --nodeps mysql-server

# rpm -Uvh *

# Options for mysqld process:

[mysqld]

ndbcluster                # run NDB storage engine

ndb-connectstring=mgm1    # location of management server

# Options for ndbd process:

[mysql_cluster]

ndb-connectstring=mgm1

# Management process options:

[ndb_mgmd default]

DataDir=/var/lib/mysql-cluster       # Directory for management node log files

[ndb_mgmd]

NodeId=99

hostname=mgm1                        # Hostname or IP address of management node

# Options affecting ndbd processes on all data nodes:

[ndbd default]

DataMemory=64M                     # How much memory to allocate for data storage

IndexMemory=8M                     # How much memory to allocate for index storage

DataDir=/usr/local/mysql/data        # Directory for this data node's data files

NoOfReplicas=2                       # Number of replicas (Data Copies)

MaxNoOfExecutionThreads=2            # Max thread for Execution (Depend on CPU Cores)

[ndbd]

NodeId=1                             # (one [ndbd] section per data node)

hostname=ndb1                        # Hostname or IP address

[ndbd]

NodeId=2

hostname=ndb2                      

# SQL node options:

[mysqld]

NodeId=101

hostname=client1                      

shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini

shell> mkdir -p /usr/local/mysql/data

shell> chown -R mysql:mysql /usr/local/mysql

shell> ndbmtd

shell> service mysql start

shell> ndb_mgm

ndb_mgm> show

Cluster Configuration

---------------------

[ndbd(NDB)] 4 node(s)

id=1 @ndb1 (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0, Master)

id=2 @ndb2 (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)

id=99 @mgm1 (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)] 2 node(s)

id=101 @client1 (mysql-5.1.34 ndb-7.0.6)

create table member (

mem_id int(3) primary key auto_increment,

mem_name varchar(100) not null,

mem_email varchar(50) not null,

index (mem_name)

) ENGINE NDBCLUSTER;

ALTER TABLE tbl_name ENGINE=NDBCLUSTER;

shell> tar -xvf sakila-db.tar.gz

shell>cd sakila-db

shell>vi sakila-schema.sql (แก้ engine เป็น NDBCLUSTER)

shell>mysql -u root

mysql>source sakila-schema.sql

mysql>source sakila-data.sql