配置环境:windows xp和win7
软件:mysql-cluster-gpl-7.2.8
各个电脑的功能和配置如下:
节点 ip地址
manage node 172.19.66.4(电脑A)
sql node (A ) 172.19.66.5(电脑B)
sql node(B) 172.19.66.7(电脑C)
data node(A) 172.19.66.5
data node(B) 172.19.66.7
第一步 从网站上
http://www.mysql.com/downloads/cluster/ 下载 mysql-cluster-gpl-7.2.8-win32.zip
第二步 配置manage 节点
1. 将压缩包解压到 电脑A 的C盘下;(bin中暂时有ndb_mgmd.exe 和ndb_mgm.exe有用,其余可以拷贝到其他地方去)
2.在c:mysql(就是根目录,为了方便,我把mysql-cluster-gpl-7.2.8-win32该为了mysql)新建my.ini;
3.将my-small.ini下的内容全部拷贝到my.ini中(当管理控制节点的服务器与客户端不在同一主机上时,在最后添加如下代码)
[mysql_cluster]
# Options for management node process
ndb-connectstring=172.19.66.4
4.在bin目录下新建config.ini文件,内容下载
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data files
# Forward slashes used in directory path,
# rather than backslashes. This is correct;
# see Important note in text
DataMemory=80M # Memory allocated to data storage
IndexMemory=18M # Memory allocated to index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[ndb_mgmd]
# Management process options:
HostName=172.19.66.4 # Hostname or IP address of management node
DataDir=C:/mysql/bin/cluster-logs # Directory for management node log files
[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
HostName=172.19.66.5 # Hostname or IP address
[ndbd]
# Options for data node "B":
HostName=172.19.66.7 # Hostname or IP address
[mysqld]
# SQL node options:
HostName=172.19.66.5 # Hostname or IP address
[mysqld]
# SQL node options:
HostName=172.19.66.7 # Hostname or IP address
到目前为止,manage节点就配置好了,现在测试一下
在开一个命令行窗口
出现以上效果,manage节点就没问题了。
第三步 配置data 节点
1.直接将压缩包解压到电脑:C盘(其实这里暂时只是用ndbd.exe,如果这台电脑只作为data 节点,就可以把其余的文件删除掉);
2.在c:mysql新建my.ini;
3.将my-small.ini下的内容全部拷贝到my.ini中并在最后添加
[mysql_cluster]
# Options for data node process:
ndb-connectstring=172.19.66.4 # location of management server
成功运行效果如下:
第四步 配置sql 节点
直接在my.ini中添加
[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
ndb-connectstring=172.19.66.4 # location of management server
成功运行效果如下:
这样就全部配置好了
功能测试:
出现如下效果,就OK了
如下界面说明部分节点未连接:
——————————————————————配置中可能遇到的错误—————————————————————————————————————————————
问题一:端口被占用(常见的如3306),解决方法:只需找到占用该端口的程序,关闭即可
问题二:找不到“C:\mysql\bin\cluster-logs/log2out”,解决方法:在bin目录下新建cluster-logs文件
问题三:如觉得每次运行都需要转到当前目录太烦躁,解决方法:设置一下环境变量