MySql Cluster 集成安装,Centos,坑点集锦

原创
2018/05/24 11:25
阅读数 1.3K

坑点集锦

安装步骤->安装步骤

查看错误->错误集锦

节点作用->节点作用

测试结果->测试结果

[MgmtSrvr] ERROR -- Failed to delete file '/usr/local/mysql/mysql-cluster/ndb_1_config.bin.1',

权限不足,使用root启动


[MgmtSrvr] INFO -- The default config directory '/usr/local/mysql/mysql-cluster' does not exist. Trying to create it...

Failed to create directory '/usr/local/mysql/mysql-cluster', error: 2

[MgmtSrvr] ERROR -- Could not create directory '/usr/local/mysql/mysql-cluster'. Either create >it manually or specify a different directory with --configdir=<path>

缺少目录/usr/local/mysql/mysql-cluster,自己去创建一个


查看管理节点日志ndb_1_cluster.log


ERROR Message: The cluster configuration is not yet confirmed by all defined management servers. This management server is still waiting for node 1 to connect.

解决办法:等待第二个另外一个管理节点启动


Failed to allocate nodeid for API at 192.168.31.48. Returned error: 'No free node id found for mysqld(API).'

解决办法:第一个可能,管理节点配置问题,节点id分配问题.

解决办法:第二个,其他节点配置问题,比如连接地址错误.


如果发现sql节点和数据节点无法连接,或者正常启动,但是管理节点还是显示未连接,请检查 防火墙.

如果发现sql节点时有时无,会闪现的情况,可能是有一个sql节点的配置错误导致


[ndbd] WARNING -- Cannot change directory to '/usr/local/mysql/data', error: 2

[ndbd] ERROR -- Couldn't start as daemon, error: 'Failed to open logfile '/usr/local/mysql/data/ndb_8_out.log' for write, errno: 2'

解决办法:创建./usr/local/mysql/data.


Forced node shutdown completed. Occured during startphase 1. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.

原因:在一定时间内,DB节点没有全部启动,轮流重启不能间隔太久时间.

解决办法:短时间内启动所有DB节点.


添加数据节点的时候,不能修改NoOfReplicas=2参数,一旦修改,需要全部数据节点重新初始化才能启动.否在,数据节点是启动不起来的.


Unable to setup transporter service port: 192.168.31.45:2202!

Please check if the port is already used,

(perhaps the node is already running)

globalTransporterRegistry.start_service() failed

解决:端口被占用....停掉所有集群服务,有些服务还在启动情况下,会和2202进行数据交互.


这里错误可能补全,由于有些错误都是粗心导致,忘记记录.如果你有发现其他错误,欢迎交流.

展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部