MySQL NDB Cluster: High Availability

With its distributed, shared-nothing architecture, MySQL Cluster has been carefully designed to deliver 99.999% availability ensuring resilience to failures and the ability to perform scheduled maintenance without downtime.

Protecting against outages:

• Synchronous Replication - Data within each data node is synchronously replicated to another data node.
• Automatic Failover - MySQL Cluster's heartbeating mechanism instantly detects any failures and automatically fails over, typically within one second, to other nodes in the cluster, without interrupting service to clients.
• Self Healing - Failed nodes are able to self-heal by automatically restarting and resynchronizing with other nodes before re-joining the cluster, with complete application transparency
• Shared Nothing Architecture, No Single Point of Failure - each node has its own disk and memory, so the risk of a failure caused by shared components such as storage, is eliminated.
• Geographical Replication - Geographic replication enables nodes to be mirrored to remote data centers for disaster recovery.

MySQL Cluster also protects against the estimated 30% of downtime resulting from scheduled maintenance activities by allowing on-line operations, including:

• On-Line schema updates
• On-Line scaling (adding nodes for capacity and performance)
• On-Line upgrades and patching of hosts, OS and database
• On-Line backup