[原創(chuàng)]Mysql集群服務(wù)器 windows mysql cluster 7.2.5 快速安裝指南

zyme

Mysql集群服務(wù)器 windows mysql cluster 7.2.5 快速安裝指南

2012-3-26 by zyme QQ:710055 歡迎指正!

前言：親愛的CU朋友們，大家好，好久不見了，想大家了。

正題：以下是把所有服務(wù)都裝在一臺服務(wù)器上方法，多臺機(jī)器可依IP拆分。
準(zhǔn)備工作：下載安裝windows x64 mysql cluster 7.2.5，不用它的向?qū)�配置和啟動服�?wù)等。
準(zhǔn)備工作：給服務(wù)器加6個IP：192.168.130.11/12/21/22/31/32

1、建好配置文件：
A、文件 C:\Program Files\MySQL\MySQL Cluster 5.5\conf\mysqld_1.ini 的內(nèi)容
[mysqld]
datadir = "D:\MysqlData\mysqld_1_data"
bind-address = 192.168.130.11
ndb-connectstring = 192.168.130.31:8186
port = 8306
ndbcluster
basedir = "C:\Program Files\MySQL\MySQL Cluster 5.5"
-------------
B、文件 C:\Program Files\MySQL\MySQL Cluster 5.5\conf\mysqld_2.ini 的內(nèi)容
[mysqld]
datadir = "D:\MysqlData\mysqld_2_data"
bind-address = 192.168.130.12
ndb-connectstring = 192.168.130.32:8186
port = 8306
ndbcluster
basedir = "C:\Program Files\MySQL\MySQL Cluster 5.5"
-------------
C、文件 C:\Program Files\MySQL\MySQL Cluster 5.5\conf\ndbd_all.ini 的內(nèi)容
[ndb_mgmd]
NodeId = 31
hostname = 192.168.130.31
datadir = D:\MysqlData\ndbd_1_data
PortNumber = 8186
[ndb_mgmd]
NodeId = 32
hostname = 192.168.130.32
datadir = D:\MysqlData\ndbd_2_data
PortNumber = 8186
[ndbd default]
NoOfReplicas = 2
[ndbd]
NodeId = 21
hostname = 192.168.130.21
datadir = D:\MysqlData\ndbd_1_data
[ndbd]
NodeId = 22
hostname = 192.168.130.22
datadir = D:\MysqlData\ndbd_2_data
[mysqld]
NodeId = 11
hostname = 192.168.130.11
[mysqld]
NodeId = 12
hostname = 192.168.130.12
##注意這里mysqld的hostname寫ip意味著測試時啟動mysqld可能要--skip-grant-tables(不安全)或修改mysql.user.host的權(quán)限
-------------------------------------------------------------------------------------------------------------------------------------------------

2、啟動管理服務(wù)器：
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndb_mgmd.exe" --config-file="C:\Program Files\MySQL\MySQL Cluster 5.5\conf\ndbd_all.ini" --skip-config-cache --ndb-nodeid=31 --bind-address=192.168.130.31
及
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndb_mgmd.exe" --config-file="C:\Program Files\MySQL\MySQL Cluster 5.5\conf\ndbd_all.ini" --skip-config-cache --ndb-nodeid=32 --bind-address=192.168.130.32
注意：第一次啟動都要加--initial參數(shù)，以后啟動別加這個參數(shù)。
-------------------------------------------------------------------------------------------------------------------------------------------------

3、檢查管理服務(wù)器狀態(tài)：
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndb_mgm.exe" -c 192.168.130.31:8186 -e show
能看到
Connected to Management Server at: 192.168.130.31:8186
Cluster Configuration
[ndbd(NDB)]     2 node(s)
id=21 (not connected, accepting connect from 192.168.130.21)
id=22 (not connected, accepting connect from 192.168.130.22)
[ndb_mgmd(MGM)] 2 node(s)
id=31   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5)
id=32   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5)
[mysqld(API)]   2 node(s)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)
-------------------------------------------------------------------------------------------------------------------------------------------------

4、啟動ndbd服務(wù)器：
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndbd.exe" -c 192.168.130.31:8186 --ndb-nodeid=21 --bind-address=192.168.130.21
及
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndbd.exe" -c 192.168.130.32:8186 --ndb-nodeid=22 --bind-address=192.168.130.22
注意：第一次啟動要加--initial參數(shù)，以后啟動別加這個參數(shù)(千萬別加否則后果自負(fù))。
-------------------------------------------------------------------------------------------------------------------------------------------------

5、啟動mysqld服務(wù)器：
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\mysqld.exe" --defaults-file="C:\Program Files\MySQL\MySQL Cluster 5.5\conf\mysqld_1.ini" --ndb-nodeid=11 --skip-grant-tables
及
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\mysqld.exe" --defaults-file="C:\Program Files\MySQL\MySQL Cluster 5.5\conf\mysqld_2.ini" --ndb-nodeid=12 --skip-grant-tables
-------------------------------------------------------------------------------------------------------------------------------------------------

6、現(xiàn)在完整的啟動完了，可以看看變化：
A、命令 "C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndb_mgm.exe" -c 192.168.130.31:8186 -e show 有如下內(nèi)容
Connected to Management Server at: 192.168.130.31:8186
Cluster Configuration
[ndbd(NDB)]     2 node(s)
id=21   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0, Master)
id=22   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0)
[ndb_mgmd(MGM)] 2 node(s)
id=31   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5)
id=32   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5)
[mysqld(API)]   2 node(s)
id=11   @192.168.130.31  (mysql-5.5.20 ndb-7.2.5)
id=12   @192.168.130.32  (mysql-5.5.20 ndb-7.2.5)
-------------
B、目錄 D:\MysqlData\ndbd_1_data 和 D:\MysqlData\ndbd_2_data 下面，分別有5個文件加一個文件夾，分別共111個文件和35個夾，分別占了1G空間
-------------
C、命令 netstat -an 有如下內(nèi)容
  TCP    192.168.130.11:8306    0.0.0.0:0              LISTENING
  TCP    192.168.130.12:8306    0.0.0.0:0              LISTENING
  TCP    192.168.130.21:63033   0.0.0.0:0              LISTENING
  TCP    192.168.130.21:63034   0.0.0.0:0              LISTENING
  TCP    192.168.130.21:63035   0.0.0.0:0              LISTENING
  TCP    192.168.130.22:63043   0.0.0.0:0              LISTENING
  TCP    192.168.130.22:63044   0.0.0.0:0              LISTENING
  TCP    192.168.130.31:8186    0.0.0.0:0              LISTENING
  TCP    192.168.130.32:8186    0.0.0.0:0              LISTENING
-------------------------------------------------------------------------------------------------------------------------------------------------

7、關(guān)閉集群服務(wù)器：
A、先關(guān)mysqld
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\mysqladmin.exe" -u root -h 192.168.130.11 -P8306 shutdown
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\mysqladmin.exe" -u root -h 192.168.130.12 -P8306 shutdown
-------------
B、再關(guān)ndbd及mgm
"C:\Program Files\MySQL\MySQL Cluster 5.5\bin\ndb_mgm.exe" -c 192.168.130.31:8186 -e shutdown
-------------
顯示
Connected to Management Server at: 192.168.130.31:8186
4 NDB Cluster node(s) have shutdown.
Disconnecting to allow management server to shutdown.
即正常關(guān)閉了所有東東
-------------------------------------------------------------------------------------------------------------------------------------------------

8、把以上命令加為服務(wù)，以及服務(wù)的依賴性，看windows的sc命令吧

結(jié)語：現(xiàn)在比較懶了，寫個筆記不容易，轉(zhuǎn)載請保留原樣，謝謝！

zyme

坐回沙發(fā).

小版主殺手

多謝分享

send_linux

歡迎老版主回歸，嘿嘿

caabcal

能不能寫個Linux平臺下的？

謝謝！