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

最新推荐文章于 2021-08-14 15:29:39 发布

?Briella

最新推荐文章于 2021-08-14 15:29:39 发布

阅读量413

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/out1kiss/blog/1817877

版权

2019独角兽企业重金招聘Python工程师标准>>>

坑点集锦

安装步骤->安装步骤

查看错误->错误集锦

节点作用->节点作用

测试结果->测试结果

[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进行数据交互.

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

转载于:https://my.oschina.net/out1kiss/blog/1817877