Single storage node failure
MySQL Clusters can survive the failure of any single storage node as long as NoOfReplicas is greater than 1 (and there is almost no point in a cluster if it is not). In this recipe, we will demonstrate how a MySQL Cluster detects and handles the failure of a single storage node (where all other nodes are working). In the next recipe, we will cover how a cluster copes with multiple storage node failures.
Getting ready
MySQL Cluster has an algorithm for high availability with two, slightly competing, aims:
- Prevent database inconsistencies in the event of a split-brain
- Keep the database up and running (that is, to keep the database users happy)
In every MySQL Cluster, there are many copies of each fragment of data (using
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.
