MySQL Forums
Forum List  »  NDB clusters

Re: SQL Node failed to start
Posted by: Tonci Grgin
Date: June 17, 2018 05:13AM

Hi Chuck,

Quoting from manual:
--
The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster data. None of the parameters shown is required. If no computer or host name is provided, any host can use this SQL or API node.

Generally speaking, a [mysqld] section is used to indicate a MySQL server providing an SQL interface to the cluster, and an [api] section is used for applications other than mysqld processes accessing cluster data, but the two designations are actually synonymous; you can, for instance, list parameters for a MySQL server acting as an SQL node in an [api] section.
--
Some points here; SQL node is also an API node but we distinguish between the two for the sake of clarity.
The reason API nodes are not shown as "started" in MCC is simple because no Cluster client is running on them. So you can safely ignore this and assume Cluster is fully started once MGMT, DATA and SQL nodes are started.

You can find more about this in my (http://toncigrgin.blogspot.com/2018/06/mysql-cluster-76-in-cloud-rpmyum.html) and Mikaels (http://mikaelronstrom.blogspot.com/2017/04/setting-up-mysql-cluster-in-oracle-bare.html) posts.

Thanks for your interest in MySQL Cluster and MCC.

Options: ReplyQuote


Subject
Views
Written By
Posted
1008
June 04, 2018 11:17AM
465
June 06, 2018 10:32AM
471
June 13, 2018 01:09PM
1153
June 14, 2018 09:08AM
Re: SQL Node failed to start
528
June 17, 2018 05:13AM
368
June 18, 2018 08:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.