Re: SQL Node failed to start

[Tonci Grgin]

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.