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.

Phần thưởng bắn cá 3DProtecting 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.

With no single point of failure, MySQL Cluster delivers extreme resilience to failures.

Phần thưởng bắn cá 3DFigure 1: With no single point of failure, MySQL Cluster delivers extreme resilience to failures.


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