MariaDB社区

标题: 谁在或做过mysql cluster NDB 7.2集群？ [打印本页]

作者: ifeelstupid 时间: 2012-11-8 10:50
标题: 谁在或做过mysql cluster NDB 7.2集群？
mysqld启动了，但是结果是这样的：
ndb_mgm> show;
Cluster Configuration
---------------------
[ndbd(NDB)]    2 node(s)
id=2 @192.168.1.12  (mysql-5.5.27 ndb-7.2.8, Nodegroup: 0, Master)
id=3 @192.168.1.13  (mysql-5.5.27 ndb-7.2.8, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.10  (mysql-5.5.27 ndb-7.2.8)
[mysqld(API)] 1 node(s)
id=4 (not connected, accepting connect from 192.168.1.10)

mysqld连不上啊！my.cnf主要配置如下：

[mysql_cluster]
# Options for ndbd process:
ndb-connectstring=192.168.1.10
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
ndbcluster
port          = 3306
user          =mysql
max_connections =5000
ndb-connectstring=192.168.1.10
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=bin-log
slow_query_log=1
slow_query_log_file=slow-log
log-error=error-log

mysql> show engines\G
*************************** 1. row ***************************
   Engine: ndbcluster
   Support: YES
   Comment: Clustered, fault-tolerant tables
Transactions: YES
      XA: NO
  Savepoints: NO
有ndb引擎！sql节点怎么不能加入到集群？

作者: baiyaj 时间: 2012-12-11 11:52
ndb-connectstring=192.168.1.10:1186

作者: Shaquile 时间: 2013-1-6 21:15
本帖最后由 Shaquile 于 2013-1-6 22:20 编辑

ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.10 (mysql-5.5.27 ndb-7.2.8)
[mysqld(API)] 1 node(s)
id=4 (not connected, accepting connect from 192.168.1.10)

这个配置说明了，只有一个ｓｌｏｔ留给ｉｄ＝４的节点，所以，别的node不能连接。
你可以在ｃｏｎｆｉｇ.ｉｎｉ中增加几个空的[mysqld]

欢迎光临 MariaDB社区 (http://123.56.88.72/)