What is MySQL NDB Cluster and how does it differ from InnoDB Cluster?

MySQL NDB Cluster uses the NDB (Network DataBase) storage engine with a shared-nothing architecture where data is stored in-memory across distributed data nodes. Unlike InnoDB Cluster which uses Group Replication over InnoDB, NDB Cluster provides automatic sharding, sub-millisecond latency, and carrier-grade 99.999% availability. NDB is ideal for real-time, high-throughput workloads like telecom and financial services, while InnoDB Cluster is better suited for general-purpose OLTP applications.

What uptime does MySQL NDB Cluster provide?

MySQL NDB Cluster is designed for carrier-grade 99.999% availability, which translates to less than 5.26 minutes of downtime per year. This is achieved through its shared-nothing architecture with no single point of failure, automatic failover in under 1 second, online schema changes, rolling upgrades, and node-level redundancy with synchronous replication across data node groups.

How does auto-sharding work in MySQL NDB Cluster?

NDB Cluster automatically partitions (shards) data across all data nodes using a hash-based distribution on the primary key. Each partition is stored with one or more replicas on different data nodes for redundancy. This happens transparently — applications interact with SQL nodes using standard MySQL queries and the cluster handles data distribution, rebalancing, and replica management automatically.

What are the hardware requirements for MySQL NDB Cluster?

NDB Cluster data nodes require sufficient RAM to hold the entire dataset in memory (plus indexes and overhead). A minimum of 2 data nodes is required for redundancy, plus at least 1 management node and 1 SQL node. For production deployments, we recommend dedicated servers with 64GB+ RAM for data nodes, fast local storage for disk-based data and checkpoints, and low-latency networking (10GbE or better) between all nodes.

Can MySQL NDB Cluster handle geographic replication?

Yes, MySQL NDB Cluster supports geographic replication through NDB Cluster Replication, which uses asynchronous MySQL replication between two or more NDB Cluster deployments. This enables active-passive and active-active multi-site configurations for disaster recovery and geographic data distribution. Conflict detection and resolution functions are built in for active-active setups.

What industries benefit most from MySQL NDB Cluster?

MySQL NDB Cluster is widely used in telecommunications (subscriber databases, real-time billing, HLR/HSS), financial services (real-time fraud detection, payment processing), gaming (session state, leaderboards, matchmaking), IoT (sensor data ingestion, device management), and any industry requiring sub-millisecond response times, continuous availability, and high write throughput.

Carrier-Grade MySQL Clustering

MySQL NDB Cluster Services

In short: MySQL NDB Cluster is a distributed, shared-nothing database that uses the in-memory NDB storage engine to spread data and automatic hash-based sharding across multiple data nodes. With no single point of failure, sub-millisecond latency, and synchronous replication, it targets carrier-grade 99.999% availability for real-time, high-throughput workloads.

Deploy carrier-grade MySQL NDB Cluster with in-memory real-time performance, automatic sharding, and shared-nothing architecture for mission-critical applications demanding 99.999% uptime.

Get Started Today View Architecture

99.999%

Uptime SLA

<1ms

Latency

144

Max Data Nodes

NDB Cluster Architecture

Management Nodes

ndb_mgmd

Data Nodes

ndbd / ndbmtd

SQL Nodes

mysqld

API Nodes

NDB API / ClusterJ

Shared-Nothing, In-Memory Architecture

Comprehensive Services

Comprehensive MySQL NDB Cluster Services

From initial deployment to advanced optimization, we provide end-to-end MySQL NDB Cluster solutions for carrier-grade environments.

NDB Cluster Deployment

Complete setup and configuration of MySQL NDB Cluster with data, SQL, and management nodes

Management node (ndb_mgmd) setup
Data node (ndbd/ndbmtd) configuration
SQL node (mysqld with NDB) integration
config.ini and my.cnf optimization

Auto-Sharding & Partitioning

Automatic data distribution and partitioning across data nodes for linear scalability

Hash-based partition key design
Node group planning and balancing
Table schema optimization for NDB
Online repartitioning and rebalancing

High Availability & Failover

Carrier-grade 99.999% availability with no single point of failure and sub-second failover

Automatic node failure detection
Sub-second failover orchestration
Node group redundancy planning
Split-brain prevention strategies

Performance Optimization

In-memory tuning, batch operations, and NDB API for maximum throughput and minimal latency

In-memory vs disk data configuration
Batch operation optimization
NDB API and ClusterJ tuning
Adaptive send and receive thread tuning

Geo-Replication

Multi-site NDB Cluster replication for disaster recovery and geographic data distribution

NDB Cluster Replication setup
Active-active conflict resolution
Cross-datacenter DR planning
Epoch-based conflict detection

Monitoring & Management

Comprehensive monitoring, alerting, and ongoing cluster management with MySQL Cluster Manager

ndb_mgm and ndbinfo monitoring
MySQL Cluster Manager (MCM) setup
Performance metrics and dashboards
24/7 alerting and incident response

Why NDB

Why Choose MySQL NDB Cluster?

MySQL NDB Cluster delivers carrier-grade availability with in-memory performance, automatic sharding, and a shared-nothing architecture designed for zero downtime.

In-Memory Real-Time Performance

All data is stored in-memory across data nodes, delivering sub-millisecond read and write latency. Disk-based data tables are available for larger datasets that don't require in-memory speed.

Shared-Nothing Architecture

No shared disks or storage — each data node owns its partition of the data. This eliminates single points of failure and enables linear horizontal scaling by adding more data nodes.

Automatic Failover (<1 Second)

When a data node fails, the cluster automatically promotes replicas and reroutes traffic in under 1 second. Applications experience no interruption thanks to transparent failover.

Linear Horizontal Scaling

Add data nodes online to increase both capacity and throughput linearly. NDB Cluster supports up to 144 data nodes with automatic data redistribution across the expanded cluster.

NDB Cluster Key Metrics

Availability(Five nines uptime)

99.999%

Read Latency(In-memory access)

<1ms

Failover Time(Automatic recovery)

<1s

Max Data Nodes(Linear scaling)

144

Max Replicas(Per node group)

Online Operations(Schema changes, upgrades)

Yes

Comparison

NDB Cluster vs InnoDB Cluster

Choose the right MySQL clustering solution based on your workload characteristics and availability requirements.

Recommended for Real-Time

MySQL NDB Cluster

In-memory, shared-nothing, carrier-grade

In-memory storage engine (NDB)

Automatic hash-based sharding

99.999% availability (five nines)

Sub-millisecond latency

Up to 144 data nodes

NDB API for direct node access

Online rolling upgrades

Built-in geo-replication

Best for: Telecom, real-time billing, fraud detection, gaming

Recommended for OLTP

MySQL InnoDB Cluster

Disk-based, Group Replication, general-purpose

InnoDB storage engine (disk-based)

Group Replication consensus

99.99% availability (four nines)

Millisecond latency

Up to 9 nodes

Standard MySQL protocol

MySQL Shell AdminAPI

MySQL Router integration

Best for: General OLTP, web applications, e-commerce

Architecture

NDB Cluster Architecture Components

Understanding the node types that make up a production MySQL NDB Cluster deployment.

Management Nodes

ndb_mgmd

Manage cluster configuration and orchestrate node startup, shutdown, and failover. Stores and distributes config.ini to all nodes.

Cluster configuration management
Node arbitration
Online config changes
Backup coordination

Data Nodes

ndbd / ndbmtd

Store and replicate data in-memory. Handle data partitioning, transaction execution, and checkpointing to disk.

In-memory data storage
Synchronous replication
Local checkpoints (LCP)
Global checkpoints (GCP)

SQL Nodes

mysqld (NDB)

Standard MySQL servers with the NDB storage engine. Provide SQL interface for applications to access cluster data.

Standard MySQL protocol
Query parsing and optimization
Join pushdown to data nodes
Connection pooling

API Nodes

NDB API / ClusterJ

Direct programmatic access to data nodes bypassing SQL overhead. Used for maximum performance in latency-sensitive applications.

Direct data node access
C++ NDB API
Java ClusterJ API
Node.js ndb adapter

Process

Our NDB Cluster Implementation Process

A proven methodology for deploying production-ready MySQL NDB Cluster with comprehensive testing and validation.

Architecture Planning

Analyze workload patterns, data model requirements, and availability targets. Design node topology, node group layout, and partition key strategy.

Cluster Deployment

Deploy management, data, and SQL nodes. Configure config.ini, memory allocation, data node replicas, and network transporter settings.

Integration & Testing

Migrate data to NDB tables, validate application compatibility, perform failover testing, and benchmark throughput and latency.

Production Go-Live

Cut over to production with monitoring, alerting, backup procedures, and runbooks. Provide training and ongoing 24/7 support.

Use Cases

NDB Cluster Use Cases

Industries and workloads where MySQL NDB Cluster delivers the greatest impact.

Telecommunications

Subscriber databases (HLR/HSS), real-time billing and charging, network element management, and session data stores for millions of concurrent users.

Financial Services

Real-time fraud detection, payment authorization, risk scoring, and high-frequency transaction processing with guaranteed data consistency.

Gaming

Player session state, real-time leaderboards, matchmaking engines, and in-game inventory management with sub-millisecond response times.

IoT & Edge

High-velocity sensor data ingestion, device state management, real-time analytics on device telemetry, and edge-to-cloud data pipelines.

FAQ

MySQL NDB Cluster — Frequently Asked Questions

Common questions about MySQL NDB Cluster deployment, architecture, and management.

Related Services

Related MySQL Services

Explore complementary MySQL high availability and clustering solutions from JusDB.

MySQL High Availability

Architect resilient MySQL with replication, automated failover, and zero-downtime topologies.

Learn more

MySQL InnoDB Cluster

Deploy Group Replication with MySQL Shell AdminAPI and MySQL Router for general-purpose OLTP HA.

Learn more

Aurora MySQL

Run managed, cloud-native MySQL on Amazon Aurora with auto-scaling storage and fast failover.

Learn more

Ready to Deploy Carrier-Grade MySQL Clustering?

Let our experts implement MySQL NDB Cluster for your mission-critical applications with 99.999% uptime and sub-millisecond latency.

Start Your Project Schedule Consultation