Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 17 MySQL Cluster
- 17.1 MySQL Cluster Overview
- 17.2 Simple Multi-Computer How-To
- 17.3 MySQL Cluster Configuration
- 17.4 MySQL Cluster Options and Variables
- 17.5 Upgrading and Downgrading MySQL Cluster
- 17.6 Process Management in MySQL Cluster
- 17.7 Management of MySQL Cluster
- 17.8 MySQL Cluster Security Issues
- 17.9 On-line Backup of MySQL Cluster
- 17.10 MySQL Cluster Utility Programs
- 17.11 MySQL Cluster Replication
- 17.12 MySQL Cluster Disk Data Tables
- 17.13 Using High-Speed Interconnects with MySQL Cluster
- 17.14 Known Limitations of MySQL Cluster
- 17.15 MySQL Cluster Development Roadmap
- 17.16 MySQL Cluster Glossary
- 17.17 Changes in MySQL Cluster 6.x
[+/-]
In this section, we discuss changes in the implementation of MySQL Cluster in MySQL 5.1 and MySQL Cluster NDB as compared to MySQL 5.0.
We also discuss our roadmap for further improvements to MySQL Cluster planned for MySQL Cluster NDB 6.4, currently in Alpha development status.
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 |
User Comments
Add your own comment.