Debugging MySQL Clusters
In this recipe, we will cover some of the common things to check in the case of a problem with a MySQL Cluster.
Getting ready
Prior to attempting to debug a problem, it is advisable to take some time to write down exactly what is wrong. In particular,
- What is supposed to happen (if anything)
- What is happening
- What has changed recently
With this information, it is likely that you will be able to find the solution with a methodical approach rather than to look for the problem directly.
How to do it...
Often, the problem is an error message. So the first step is to check the following places for error logs:
stdout—when you start management or storage nodes (this is printed to the console)- Node error logs—
/var/lib/mysql-cluster/ndb_<nodeid>_out.log ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
