streetboy85 发表于 2014-05-06 14:27

Mysql Cluster MaxNoOfAttributes参数无效疑问

配置文件参数如下,在导入cacti的数据库和syslog数据库是都报了一下的错误:
ERROR 1296 (HY000): Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER

请问是什么原因导致MaxNoOfAttributes参数无效的?如何查看当前NDBD节点的各个默认值?

# vi /etc/mycluster.cnf


NoOfReplicas=2
DataMemory=64M
IndexMemory=18M
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000

#
#portnumber=2202


nodeid=1
hostname=10.16.147.20
datadir=/var/lib/mysql-cluster


nodeid=2
hostname=10.16.147.21


nodeid=3
hostname=10.16.147.22


nodeid=4
hostname=10.16.147.23
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000


nodeid=5
hostname=10.16.147.24
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000
# cat /etc/mycluster.cnf

NoOfReplicas=2
DataMemory=64M
IndexMemory=18M
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000

#
#portnumber=2202


nodeid=1
hostname=10.16.147.20
datadir=/var/lib/mysql-cluster


nodeid=2
hostname=10.16.147.21


nodeid=3
hostname=10.16.147.22


nodeid=4
hostname=10.16.147.23
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000


nodeid=5
hostname=10.16.147.24
datadir=/var/lib/mysql-cluster
MaxNoOfTables=1024
MaxNoOfAttributes=5000000
MaxNoOfOrderedIndexes=10000


-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.16.147.20:1186
Cluster Configuration
---------------------
   2 node(s)
id=4    @10.16.147.23(mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
id=5    @10.16.147.24(mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)

1 node(s)
id=1    @10.16.147.20(mysql-5.6.17 ndb-7.3.5)

   2 node(s)
id=2    @10.16.147.21(mysql-5.6.17 ndb-7.3.5)
id=3    @10.16.147.22(mysql-5.6.17 ndb-7.3.5)

streetboy85 发表于 2014-05-06 15:15

终于找到原因了,原来修改了配置文件后,需要添加--initial参数重新读取才行的...没想到居然有一个这么纠结的选项....
ndb_mgmd -f /etc/mycluster.cnf --initial

查看当前的参数,配置已生效
# ndb_config -q MaxNoOfAttributes
   50000 50000

560130911 发表于 2015-01-03 18:11

可以分享下怎么搭建起来的吗?我搭建了很多次都失败了
页: [1]
查看完整版本: Mysql Cluster MaxNoOfAttributes参数无效疑问