无法启动MySQL集群SQL节点
问题描述:
我在Windows上安装一个四个节点MySQL集群: 管理节点192.168.2.69 数据节点A 192.168.2.66 数据节点B 192.168.2.67 SQL节点192.168.2.78无法启动MySQL集群SQL节点
我可以开始第一次三无问题,但SQL节点被卡在以下警告:
2017-04-07T13:55:23.970111Z 0 [Note] IPv6 is available.
2017-04-07T13:55:23.970111Z 0 [Note] - '::' resolves to '::';
2017-04-07T13:55:23.970111Z 0 [Note] Server socket created on IP: '::'.
2017-04-07T13:55:24.110707Z 0 [Note] Event Scheduler: Loaded 0 events
2017-04-07T13:55:24.127269Z 0 [Note]
2017-04-07T13:55:24.127269Z 0 [Note] NDB Index Stat: Wait for cluster to start
2017-04-07T13:55:24.127269Z 2 [Note] NDB Util: Wait for cluster to start
2017-04-07T13:55:24.127269Z 1 [Note] NDB Binlog: Check for incidents
2017-04-07T13:55:24.127269Z 0 [Note] NDB Index Stat: Started
2017-04-07T13:55:24.127269Z 2 [Note] NDB Util: Started
2017-04-07T13:55:24.127269Z 1 [Note] NDB Binlog: Wait for cluster to start
2017-04-07T13:55:24.127269Z 0 [Note] NDB Index Stat: created Ndb object 'Ndb Index Stat', ref: 0x80070004
2017-04-07T13:55:24.141956Z 1 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$mysql/ndb_schema
2017-04-07T13:55:34.513769Z 0 [Note] NDB Index Stat: execute index stats listener failed: error 1427 line 2546
2017-04-07T13:56:15.502173Z 0 [Note] NDB Index Stat: execute index stats listener failed: error 1427 line 2546
此重复“NDB指数统计:执行索引统计信息侦听器失败:错误1427行2546” 我找不到任何帮助关于这个错误。有人可以帮我解决这个问题吗?
编辑
如果我安装在运行mysqld就好了一台服务器的所有节点。
答
问题转到数据节点机192.168.2.67上的windows防火墙上,关掉它解决问题。