Debian 上学习着搭建 MySQL 集群报 The hostname this node should have according to …… 的错误， why？
开门见山地放一下错误信息：
2020-11-07 16:35:20 [MgmtSrvr] ERROR — The hostname this node should have according to the configuration does not match a local interface. Attempt to bind ’42.a1.b1.c1′ failed with error: 99 ‘Cannot assign requested
Host1:
ip: 42.a1.b1.c1
这台主机上安装了 mysql-cluster-community-server, mysql-cluster-community-management-server and mysql-cluster-community-data-node 这三个软件，也就是说我希望它同时担当管理节点，SQL 节点和数据节点。
Host2:
ip: 119.a2.b2.c2
这台主机上同时安装了 mysql-cluster-community-server and mysql-cluster-community-data-node 这两个软件，即同时担当 SQL 节点和数据节点。
这样同时担当不可行嘛？一个主机只能担任一种节点？
一台早就买了的学生机，一台最近双 11 刚入的云服务器，可以看到它们两个 IP 差距很大。再多云服务器买不起了，所以希望一台主机多个角色。
软件仅仅只是安装，在下面的任何操作前，没有任何软件被启动。安装的方式来自这篇官方文档。
在 host1 上执行 cat /var/lib/mysql-cluster/config.ini，产生如下输出：
[ndbd default] # Options affecting ndbd processes on all data nodes: NoOfReplicas=1 # Number of fragment replicas DataMemory=80M # How much memory to allocate for data storage IndexMemory=18M # How much memory to allocate for index storage # For DataMemory and IndexMemory, we have used the # default values. Since the "world" database takes up # only about 500KB, this should be more than enough for # this example NDB Cluster setup. # NOTE: IndexMemory is deprecated in NDB 7.6 and later; in # these versions, resources for all data and indexes are # allocated by DataMemory and any that are set for IndexMemory # are added to the DataMemory resource pool ServerPort=2202 # This the default value; however, you can use any # port that is free for all the hosts in the cluster # Note1: It is recommended that you do not specify the port # number at all and simply allow the default value to be used # instead # Note2: The port was formerly specified using the PortNumber # TCP parameter; this parameter is no longer available in NDB # Cluster 7.5. [ndb_mgmd] # Management process options: HostName=42.a1.b1.c1 # Hostname or IP address of management node DataDir=/var/lib/mysql-cluster # Directory for management node log files #[ndbd] #Options for data node "A": # (one [ndbd] section per data node) #HostName=42.a1.b1.c1 # Hostname or IP address #NodeId=2 # Node ID for this data node #DataDir=/usr/local/mysql/data # Directory for this data node's data files [ndbd] #Options for data node "B": HostName=119.a2.b2.c2 # Hostname or IP address NodeId=3 # Node ID for this data node DataDir=/usr/local/mysql/data # Directory for this data node's data files [mysqld] #SQL node options: HostName=119.a2.b2.c2 # Hostname or IP address # (additional mysqld connections can be # specified for this node for various # purposes such as running ndb_restore) 在 host1 上执行 ndb_mgmd -f /var/lib/mysql-cluster/config.ini --ndb-nodeid=1，报错信息如下：
MySQL Cluster Management Server mysql-5.7.32 ndb-7.6.16 2020-11-07 16:35:20 [MgmtSrvr] WARNING -- at line 5: [DB] IndexMemory is deprecated, will use Number bytes on each ndbd(DB) node allocated for storing indexes instead 2020-11-07 16:35:20 [MgmtSrvr] ERROR -- The hostname this node should have according to the configuration does not match a local interface. Attempt to bind '42.a1.b1.c1' failed with error: 99 'Cannot assign requested address' 这里的 The hostname this node should have according to the configuration does not match a local interface. Attempt to bind ’42.a1.b1.c1′ failed with error: 99 ‘Cannot assign requested 是什么情况啊，如何解决？
感谢！