MySQL Forums
Forum List  »  NDB clusters

Re: Test My Cluster ?
Posted by: Jeremy Smyth
Date: February 24, 2015 05:49AM

The MySQL server node is set up as any other MySQL server (in addition to its ability to use NDB as a storage engine), so if you do not currently have a root password you will need to set one up.

To test the cluster, you could try the following:

- Create a table using the NDB cluster storage engine (ENGINE=ndbcluster in your CREATE TABLE statement)
- Add some rows to that table
- Query how the data node memory is used in the ndbinfo.memoryusage table
- Stop one of the data nodes to see if the table still works
- Restart that node, then stop the other node to see it still works
- Stop both data nodes to see that the cluster (and therefore the new table) is unavailable

Options: ReplyQuote


Subject
Views
Written By
Posted
2069
February 24, 2015 02:07AM
753
February 24, 2015 05:13AM
702
February 24, 2015 05:32AM
Re: Test My Cluster ?
804
February 24, 2015 05:49AM
714
February 24, 2015 06:08AM
709
February 24, 2015 07:01AM
705
February 25, 2015 03:39AM
681
February 25, 2015 09:50AM
804
February 26, 2015 03:16AM


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.