This is my first time running MySQL Cluster and I used the auto-installer to create the cluster. This is probably a newbie question but I can't find the answer.
So the basic situation is as follows:
The current state is all nodes are off.
- I start the management node from the command line -> all is good
- I start the data node from the command line -> all is good
When I use ndb_mgm and do "show" to see the status of the cluster I see the SQL Node has started automatically after I started the data node. From the documentation I should have had to start the SQL Node manually.
My question is why is the SQL Node starting automatically and if this is the normal functionality where are the command line options coming from to start the SQL Node. Is there some file that I don't know about?
The normal config file my.cnf is not being used since the port and data directory information in it does not match what is being used for the SQL Node. And the SQL Node has command line options since I can see the command line when I use ps with grep to view the MySQL processes. Any insight?? Where is the command line for starting the SQL Node coming from ?