Revision as of 12:54, 17 October 2024 edit OXYLYPSE (talk \| contribs) Extended confirmed users 5,398 edits →Replication: Move line about replication being async Tag: 2017 wikitext editor ← Previous edit		Revision as of 12:58, 17 October 2024 edit undo 2a00:23c8:8690:9701:c87b:66ab:2ab9:e879 (talk) Re-order release version descriptions newest -> oldest + add some info for 8.4 Next edit →
Line 92: Higher versions of MySQL Cluster include all of the features of lower versions, plus some new features. Older versions (no longer in development):▼ * Ndb included in MySQL 5.1.X source tree▼ * MySQL Cluster 6.2 based on MySQL 5.1.A▼ :First 'telco' or 'carrier grade edition' release. Supports 255 nodes, online table alter, replication latency and throughput enhancements etc.▼ * MySQL Cluster 6.3 based on MySQL 5.1.B▼ :Includes compressed backup + LCP, circular replication support, conflict detection/resolution, table optimization etc.▼ * MySQL Cluster 7.0 based on MySQL 5.1.C▼ :Includes multi-threaded data nodes (ndbmtd), Transactional DDL, Windows support.▼ * MySQL Cluster 7.1 based on MySQL 5.1.D▼ :Includes ClusterJ and ClusterJPA connectors▼ * MySQL Cluster 7.2 based on MySQL 5.5▼ :Includes Adaptive Query Localization (pushes JOIN operations down to the data nodes), Memcached API, simplified Active/Active Geographic replication, multi-site clustering, data node scalability enhancements, consolidated user privileges.<ref>[http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2-ga.html New features of MySQL Cluster 7.2], MySQL Developer Zone</ref>▼ * MySQL Cluster 7.3 based on MySQL 5.6▼ :Includes support for [[foreign key]] constraints, [[Node.js]] / [[JavaScript]] API and an auto-installer.<ref>[http://www.clusterdb.com/mysql-cluster/mysql-cluster-7-3-is-now-ga/ MySQL Cluster 7.3 is now Generally Available – an overview], MySQL Cluster 7.3 Summary</ref>▼ Currently available versions: * MySQL Cluster 79.4X ~~based~~Innovation onRelease ~~MySQL 5.6~~series * MySQL Cluster 8.4 LTS based on MySQL 8.4 LTS release :Includes enhanced conflict detection and resolution, improved node restart times, new Event API.<ref>[http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.4.html MySQL Cluster 7.4 GA: 200 Million QPS, Active-Active Geographic Replication and more], MySQL Cluster 7.4 Summary</ref>▼ :Add support for TLS on cluster internal connections * MySQL Cluster 7.5 based on MySQL 5.7▼ :Includes support for bigger datasets(more than 128TB per node), improved read scalability through read optimized tables, improved SQL support.<ref>[https://blogs.oracle.com/MySQL/entry/mysql_cluster_7_5_is MySQL Cluster 7.5 Is Now GA!], Oracle's MySQL Blog, 18 October 2016</ref>▼ * MySQL Cluster 7.6 based on MySQL 5.7▼ :Improved restart and recovery times, reduced disk space usage, improved join performance, new import tool, shared memory communication, improved topology awareness for cloud.<ref>[https://blogs.oracle.com/mysql/mysql-cluster-76-is-now-generally-available MySQL Cluster 7.6 is now Generally Available], Oracle's MySQL Blog, 1 June 2018 </ref>▼ * MySQL Cluster 8.0 based on MySQL 8.0 :Increase in max row size to 30kB, Support for up to 144 data nodes, Improved distributed filtering and joining, Support for parallel outer joins and semi joins, Improved schema and ACL handling, Online column rename, Simplified configuration, Multithreaded parallel backup and restore, Disk data performance improvements, Enhanced support for 3 and 4 replica configurations, Support for multi socket mesh networking, Support for restore transformations, Improved Blob write performance, Backup encryption, Support for IPv6, Threading autoconfiguration, Improved recovery performance, Improved query multithreading. <ref>{{Cite web\|url=https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html\|title=MySQL :: MySQL 8.0 Reference Manual :: 22.1.4 What is New in NDB Cluster\|website=dev.mysql.com}}</ref> ▲* MySQL Cluster 7.56 based on MySQL 5.7 ▲:Improved restart and recovery times, reduced disk space usage, improved join performance, new import tool, shared memory communication, improved topology awareness for cloud.<ref>[https://blogs.oracle.com/mysql/mysql-cluster-76-is-now-generally-available MySQL Cluster 7.6 is now Generally Available], Oracle's MySQL Blog, 1 June 2018 </ref> ▲Older versions (no longer in development): * MySQL Cluster 8.1 based on MySQL 8.1 Innovation release * MySQL Cluster 8.2 based on MySQL 8.2 Innovation release * MySQL Cluster 8.3 based on MySQL 8.3 Innovation release * MySQL Cluster 87.~~4 LTS~~5 based on MySQL 85.~~4 LTS release~~7 ▲:Includes support for bigger datasets(more than 128TB per node), improved read scalability through read optimized tables, improved SQL support.<ref>[https://blogs.oracle.com/MySQL/entry/mysql_cluster_7_5_is MySQL Cluster 7.5 Is Now GA!], Oracle's MySQL Blog, 18 October 2016</ref> * MySQL Cluster 9 Innovation Release series ▲* MySQL Cluster 7.64 based on MySQL 5.76 ▲:Includes enhanced conflict detection and resolution, improved node restart times, new Event API.<ref>[http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.4.html MySQL Cluster 7.4 GA: 200 Million QPS, Active-Active Geographic Replication and more], MySQL Cluster 7.4 Summary</ref> ▲* MySQL Cluster 7.3 based on MySQL 5.6 ▲:Includes support for [[foreign key]] constraints, [[Node.js]] / [[JavaScript]] API and an auto-installer.<ref>[http://www.clusterdb.com/mysql-cluster/mysql-cluster-7-3-is-now-ga/ MySQL Cluster 7.3 is now Generally Available – an overview], MySQL Cluster 7.3 Summary</ref> ▲* MySQL Cluster 7.2 based on MySQL 5.5 ▲:Includes Adaptive Query Localization (pushes JOIN operations down to the data nodes), Memcached API, simplified Active/Active Geographic replication, multi-site clustering, data node scalability enhancements, consolidated user privileges.<ref>[http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2-ga.html New features of MySQL Cluster 7.2], MySQL Developer Zone</ref> ▲* MySQL Cluster 7.1 based on MySQL 5.1.D ▲:Includes ClusterJ and ClusterJPA connectors ▲* MySQL Cluster 7.0 based on MySQL 5.1.C ▲:Includes multi-threaded data nodes (ndbmtd), Transactional DDL, Windows support. ▲* MySQL Cluster 6.3 based on MySQL 5.1.B ▲:Includes compressed backup + LCP, circular replication support, conflict detection/resolution, table optimization etc. ▲* MySQL Cluster 6.2 based on MySQL 5.1.A ▲:First 'telco' or 'carrier grade edition' release. Supports 255 nodes, online table alter, replication latency and throughput enhancements etc. ▲* Ndb included in MySQL 5.1.X source tree ==Requirements==

MySQL Cluster: Difference between revisions