MySQL Cluster :: 1 MySQL Cluster Overview :: 1.4 MySQL Cluster Development History
Section Navigation [Toggle]
- 1 MySQL Cluster Overview
- 1.1 MySQL Cluster Core Concepts
- 1.2 MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- 1.3 MySQL Cluster Hardware, Software, and Networking Requirements
- 1.4 MySQL Cluster Development History
- 1.4.1 Development History of MySQL Cluster in MySQL 5.1
- 1.4.2 MySQL Cluster Development in MySQL Cluster NDB 6.1
- 1.4.3 MySQL CLuster Development in MySQL Cluster NDB 6.2
- 1.4.4 MySQL Cluster Development in MySQL Cluster NDB 6.3
- 1.4.5 MySQL Cluster Development in MySQL Cluster NDB 7.0
- 1.4.6 MySQL Cluster Development in MySQL Cluster NDB 7.1
- 1.5 Known Limitations of MySQL Cluster
[+/-]
- 1.4.1. Development History of MySQL Cluster in MySQL 5.1
- 1.4.2. MySQL Cluster Development in MySQL Cluster NDB 6.1
- 1.4.3. MySQL CLuster Development in MySQL Cluster NDB 6.2
- 1.4.4. MySQL Cluster Development in MySQL Cluster NDB 6.3
- 1.4.5. MySQL Cluster Development in MySQL Cluster NDB 7.0
- 1.4.6. MySQL Cluster Development in MySQL Cluster NDB 7.1
In this section, we discuss changes in the implementation of MySQL Cluster in MySQL 5.1 and MySQL Cluster NDB 6.x as compared to MySQL 5.0.
We also discuss our roadmap for further improvements to MySQL Cluster planned for MySQL Cluster NDB 7.0 and later.
There are a number of significant changes in the implementation of
the NDBCLUSTER storage engine in
mainline MySQL 5.1 releases up to and including MySQL 5.1.23 as
compared to that in MySQL 5.0; MySQL Cluster NDB makes further
changes and improvements in MySQL Cluster in addition to these.
The changes and features most likely to be of interest are shown
in the following table:
| MySQL 5.1 (through 5.1.23) |
|---|
| MySQL Cluster Replication |
| Disk Data storage |
| Variable-size columns |
| User-defined partitioning |
| Autodiscovery of table schema changes |
| Online adding and dropping of indexes |
| MySQL Cluster NDB 6.1 |
|---|
| Greater number of cluster nodes |
| Disabling of arbitration |
Additional DUMP commands |
| Faster Disk Data backups |
| Batched slave updates |
| MySQL Cluster NDB 6.2 |
|---|
Improved backup status reporting
(BackupReportFrequency, REPORT
BackupStatus) |
| Multiple connections per SQL node |
Data access with NdbRecord (NDB API) |
REPORT MemoryUsage command |
| Memory allocation improvements |
| Management client connection control |
| Micro-GCPs |
Online ADD COLUMN; improved online index creation |
| MySQL Cluster NDB 6.3 |
|---|
| Conflict detection and resolution for multi-master replication |
| Compressed backups and local checkpoints |
Support for OPTIMIZE TABLE
|
| Parallel data node recovery |
| Enhanced transaction coordinator selection |
| Improved SQL statement performance metrics |
| Transaction batching |
| ndb_restore attribute promotion |
Support for epoll (Linux only) |
| Distribution awareness |
NDB thread locks; realtime extensions for
multiple CPUs |
| MySQL Cluster NDB 7.0 |
|---|
| Multi-threaded data nodes (ndbmtd data node daemon) |
| Online addition of data nodes; online data redistribution |
| MySQL on Windows (alpha; source releases only) |
| Configuration cache |
Backup snapshots (START BACKUP ... SNAPSHOTSTART,
START BACKUP ... SNAPSHOTEND commands) |
| IPv6 support for geo-replication |
| Protected DDL operations |
| Dynamic buffering for NDB transporters |
Increased flexibility in determining arbitration handling, via a new
Arbitration data node configuration
parameter |
| MySQL Cluster NDB 7.1 |
|---|
NdbInfo meta-information database |
| MySQL Cluster Connector for Java, including CLusterJ and OpenJPA support |
| Native support for default column values |
