I am new to MySQL cluster. I had installed MySQL cluster successfully with 2 data nodes and 1 Management Node and 1 SQL node.
I want to know where and how exactly the core data is getting stored. Whether data is storing in data nodes or SQL node and data is sharing from SQL node.
Also when I searched in internet, it is mentioned like Data is storing in Datamemory & Indexmemory nothing but RAM. Obviously data will be huge around 100 of GB's, then at that time, how does MySQL cluster will support.
Also when I am trying to access(Insert) more than 32768 rows, it is throwing error like "ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER"
For this I had changed the config.ini file and set MaxNoOfConcurrentOperations=65536 and restarted all nodes, but still the same issue is coming.
Also I would like to know which and all parameters to be monitored for MySQL cluster. Also any open source tools to monitor MySQL cluster.
Thanks in Advance.