Re: SQL Node failed to start
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.
Subject
Views
Written By
Posted
1255
June 04, 2018 11:17AM
611
June 05, 2018 06:34AM
585
June 06, 2018 10:32AM
587
June 13, 2018 01:09PM
1308
June 14, 2018 09:08AM
Re: SQL Node failed to start
668
June 17, 2018 05:13AM
493
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.