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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.