2012/04/02

在 RHEL 6 安裝 MySQL Cluster

各個 MySQL Cluster 套件的描述:
MySQL-Cluster-server-gpl.x86_64 : a very fast and reliable SQL database server
MySQL-Cluster-client-gpl.x86_64 : MySQL Cluster - Client
MySQL-Cluster-devel-gpl.x86_64 : Development header files and libraries
MySQL-Cluster-embedded-gpl.x86_64 : embedded library
MySQL-Cluster-gpl-shared-compat.x86_64 : MySQL shared client libraries for MySQL 5.1.61-1, 5.0.95-1, 4.1.23-0, 4.0.27-0
MySQL-Cluster-shared-compat-gpl.x86_64 : MySQL shared client libraries for MySQL 5.1.61-1, 5.0.95-1, 4.1.23-0, 4.0.27-0
MySQL-Cluster-shared-gpl.x86_64 : Shared libraries

http://forums.mysql.com/read.php?25,519007,519073
This one package replaces the following packages from previous versions.

$ rpm -qp --obsoletes MySQL-Cluster-server-gpl-7.2.4-1.el6.x86_64.rpm
MySQL-Cluster-server
MySQL-Cluster-management
MySQL-Cluster-storage
MySQL-Cluster-extra
MySQL-Cluster-tools
# MySQL-Cluster-server 中即包含了以上幾個舊版的 rpm 內容

[角色]

MySQL Cluster 內有三種角色:
Management Node
MySQL Node
Data Node

三種角色可以分別由三臺(或者三臺以上)的主機來擔任,也可以是一臺主機擔任三種角色。
三種角色是不會互相衝突的,亦即不同角色可以共存在同一臺主機中。
但是,傳統的 MySQL 及其相關的 lib 不可以混在 MySQL Cluster 的主機上。

Management Node 核心是 ndb_mgmd(ndb management daemon),


MySQL Node 核心是 mysqld(看起來很像是傳統單機版的 MySQL Server),


Data Node 核心是 ndbd(ndb daemon),

[安裝]

yum erase mysql* mysql-*
yum install MySQL-Cluster-server
yum install MySQL-Cluster-client

Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : MySQL-Cluster-server-gpl-7.2.4-1.el6.x86_64
                                                             
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h test-ndb-node02.mfc.cwb password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

[設定]

[管理]