我试图从完整的 AMI 映像在不同的 EC2 主机(具有不同的 ip 地址)上启动我的 MemSQL、社区版、单主机集群。 我已经尝试了如何更改memsql节点的IP地址中的建议,但我无法使其工作。 我可以通过Web界面连接到MemSQL-ops。 它在具有新 IP 地址的新本地主机上显示主聚合器。 但是,它仍在旧 IP 地址处查找群集。 我试图取消监视/监视主聚合器和叶子。命令和错误的输出如下:
10.0.0.232: ~$ sudo memsql-ops memsql-start --all
Starting cluster
MemSQL node BD090F1 failed to start: Failed to connect to MemSQL node BD090F1: No error in tracelog
10.0.0.232: ~$ sudo memsql-ops memsql-unmonitor
Index ID Agent Id Process State Cluster State Role Host Port Version
1 6A15216 Aec14b6 NOT RUNNING CONNECTED MASTER 10.0.0.181 3306 5.5.11
2 BD090F1 Aec14b6 NOT RUNNING CONNECTED LEAF 10.0.0.181 3307 5.5.11
Select an option: 2
Would you additionally like to remove the leaf node from the MemSQL cluster? (You can specify this behavior with --remove-leaf.) [y/n] n
2017-01-18 15:38:29: J5ba705 [INFO] Stopping monitoring for MemSQL node BD090F1
2017-01-18 15:38:29: J5ba705 [INFO] No longer monitoring MemSQL node BD090F1
10.0.0.232: ~$ sudo memsql-ops memsql-monitor -h 127.0.0.1 -P 3307
2017-01-18 15:38:53: Jb697d2 [INFO] Monitoring MemSQL node at 10.0.0.232:3307
2017-01-18 15:38:55: Jb697d2 [ERROR] Failed to connect to MemSQL at 10.0.0.232:3307:
10.0.0.232: ~$ sudo memsql-ops memsql-monitor -h 127.0.0.1 -P 3306
2017-01-18 15:40:32: J18a2de [INFO] Monitoring MemSQL node at 10.0.0.232:3306
2017-01-18 15:40:32: J18a2de [ERROR] Failed to connect to MemSQL at 10.0.0.232:3306:
10.0.0.232: ~$ sudo memsql-ops memsql-start --all
Starting cluster
MemSQL node 6A15216 failed to start: Failed to connect to MemSQL node 6A15216: No error in tracelog
看起来 memsql ops 正在使用 memsql-ops 代理的 IP 地址。要修复它,您需要一个额外的步骤:
- Memsql-ops MemSQL-Unmonitor for each Memsql node
- sudo memsql-ops stop
- sudo memsql-ops start --host 127.0.0.1
- memsql-ops memsql-monitor [-h 127.0.0.1] [-P PORT] for each memsql node