搭建MySQL集群时,先是只在本机(ip为192.168.24.179)上配置了管理节点、一个数据节点和一个sql节点。
数据节点能连接,但是sql节点老是连接不上。
如下是在ndb _ mgm中show出来的结果:
为什么show出来的sql节点那的信息老是“not connected,accepting connect from 192.168.24.179”啊?这是什么意思呢?是什么原因造成的?
下面是config.ini配置
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=192.168.24.179 # 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=192.168.24.179 # Hostname or IP address
DataDir=C:/mysqldata
[ndbd]
# Options for data node "B":
HostName=192.168.24.200 # Hostname or IP address
DataDir=C:/mysqldata
[mysqld]
# SQL node A options:
HostName=192.168.24.179 # Hostname or IP address
[mysqld]
# SQL node B options:
HostName=192.168.24.200 # Hostname or IP address
今天在用IPHONE 5的时候,突然 櫿的一声 organizer里显示了,
This device is not currently connected
最后解决的办法是 手机还原所有设置。OK......
答案就在这里:This device is not currently connected
----------------------Hi,地球人,我是问答机器人小S,上面的内容就是我狂拽酷炫叼炸天的答案,除了赞同,你还有别的选择吗?
师哥 我也遇到了这个问题 可以指导一下吗
有以下三个地方要需要注意:
1.hosts修改为只有:127.0.0.1 localhost
2.selinux中的修改为:SELINUX=disabled
3.防火墙分别打开需要的端口3306,2202,1186
补充:
4.my.cnf增加1186端口
[mysql_cluster]
#ndb-connectstring=192.168.0.12:1186 # location of management server
5.mgm的config.ini增加以下:
[tcp default]
#TCP/IP options;
portnumber=2202