ndb_mgmd守护程序不会启动
我想configuration一个NDB Mysql集群,我跟着它的官方页面的文档。 安装mysql-cluster-community的7.5版本,我有以下scheme
1pipe理器节点:192.168.10.137
2个节点mysqld:192.168.10.140,192.168.10.139
2个节点的数据:192.168.10.138,192.168.10.141
这是pipe理器的configuration文件,我的config.ini;
[ndbd default] # Options affecting ndbd processes on all data nodes: NoOfReplicas = 2 # Number of 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. ServerPort = 1186 # This the default value; however, you can use any # port that is free for all 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 = 192.168.10.137 # Hostname or IP address of MGM node DataDir = / var / lib / mysql-cluster # Directory for MGM node log files NodeId = 1 [ndbd] # Configuration for the data node with ip 139 # (one [ndbd] section per data node) HostName = 192.168.10.139 # 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] # Configuration for the data node with ip 140 HostName = 192.168.10.140 # 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 = 192.168.10.138 # Hostname or IP address [mysqld] # SQL node options: HostName = 192.168.10.141 # Hostname or IP address
这是节点的configuration文件:
[mysqld] # Options for mysqld process: ndbcluster # run NDB storage engine
[mysql_cluster]
# Options for NDB Cluster processes: ndb-connectstring = 192.168.10.137 # location of management server
当我试图告诉mysql什么是configuration文件,它告诉我以下几点:
root @ mysql: /etc/mysql/mysql.conf.d# ndb_mgmd -f /var/lib/mysql-cluster/config.ini bash: ndb_mgmd: Order not found
但是,如果我input这个部分,如果我使用命令“ndb_mgm”:
- NDB Cluster - Management Client - ndb_mgm>
如果从那里我指出的顺序:
-f /var/lib/mysql-cluster/config.ini
它告诉我以下内容:
Unable to connect with connect string: nodeid = 0, localhost: 1186
我试图从config.ini文件所在的文件夹启动ndb_mgm,但是我无法执行它。