Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication
- 99.999% High Availability with no single point of failure
and on-line maintenance
- NoSQL and SQL APIs (including C++, Java, http, Memcached
and JavaScript/Node.js)
MySQL Cluster 7.5.13 has been released and can be downloaded from
http://www.mysql.com/downloads/cluster/
where you will also find Quick Start guides to help you get your
first MySQL Cluster database up and running.
The release notes are available from
http://dev.mysql.com/doc/relnotes/mysql-cluster/7.5/en/index.html
MySQL Cluster enables users to meet the database challenges of next
generation web, cloud, and communications services with uncompromising
scalability, uptime, and agility.
More details can be found at
http://www.mysql.com/products/cluster/
Enjoy !
==============================================================================
Changes in MySQL NDB Cluster 7.5.13 (5.7.25-ndb-7.5.13) (
2019-01-22, General Availability)
MySQL NDB Cluster 7.5.13 is a new release of MySQL NDB
Cluster 7.5, based on MySQL Server 5.7 and including features
in version 7.5 of the NDB
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster.html)
storage engine, as well as fixing recently discovered bugs in
previous NDB Cluster releases.
Obtaining MySQL NDB Cluster 7.5. MySQL NDB Cluster 7.5
source code and binaries can be obtained from
https://dev.mysql.com/downloads/cluster/.
For an overview of changes made in MySQL NDB Cluster 7.5, see
What is New in NDB Cluster 7.5
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html).
This release also incorporates all bug fixes and changes made
in previous NDB Cluster releases, as well as all bug fixes
and feature changes which were added in mainline MySQL 5.7
through MySQL 5.7.25 (see Changes in MySQL 5.7.25
(2019-01-21, General Availability)
(http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-25.html)).
Bugs Fixed
* Important Change: When restoring to a cluster using data
node IDs different from those in the original cluster,
ndb_restore tried to open files corresponding to node ID
0. To keep this from happening, the --nodeid
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-pro
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html#option_ndb_restore_nodeid>
grams-ndb-restore.html#option_ndb_restore_nodeid
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html#option_ndb_restore_nodeid>)
and
--backupid
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-pro
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html#option_ndb_restore_backupid>
grams-ndb-restore.html#option_ndb_restore_backupid
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html#option_ndb_restore_backupid>)
options---neither of which has a default value---are both
now explicitly required when invoking ndb_restore. (Bug
#28813708)
* Packaging; MySQL NDB ClusterJ: libndbclient was missing
from builds on some platforms. (Bug #28997603)
* NDB Replication: When writes on the master---done in such
a way that multiple changes affecting BLOB
(http://dev.mysql.com/doc/refman/5.7/en/blob.html) column
values belonging to the same primary key were part of the
same epoch---were replicated to the slave, Error 1022
occurred due to constraint violations in the
NDB$BLOB_id_part table. (Bug #28746560)
* When only the management server but no data nodes were
started, RESTART ALL timed out and eventually failed.
This was because, as part of a restart, ndb_mgmd starts a
timer, sends a STOP_REQ signal to all the data nodes, and
waits for all of them to reach node state SL_CMVMI. The
issue arose becaue no STOP_REQ signals were ever sent,
and thus no data nodes reached SL_CMVMI. This meant that
the timer always expired, causing the restart to fail.
(Bug #28728485, Bug #28698831)
References: See also: Bug #11757421.
* Running ANALYZE TABLE
(http://dev.mysql.com/doc/refman/5.7/en/analyze-table.html)
on an NDB table with an index having longer than the
supported maximum length caused data nodes to fail. (Bug
#28714864)
* It was possible in certain cases for nodes to hang during
an initial restart. (Bug #28698831)
References: See also: Bug #27622643.
* The output of ndb_config --configinfo
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-pro
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html#option_ndb_config_configinfo>
grams-ndb-config.html#option_ndb_config_configinfo
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html#option_ndb_config_configinfo>)
--xml
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-pro
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html#option_ndb_config_xml>
grams-ndb-config.html#option_ndb_config_xml
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html#option_ndb_config_xml>)
--query-all
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-pro
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html#option_ndb_config_query-all>
grams-ndb-config.html#option_ndb_config_query-all
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html#option_ndb_config_query-all>)
now
shows that configuration changes for the ThreadConfig
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbmtd-threadconfig>
d-definition.html#ndbparam-ndbmtd-threadconfig
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbmtd-threadconfig>)
and
MaxNoOfExecutionThreads
(http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbmtd-maxnoofexecutionthreads>
d-definition.html#ndbparam-ndbmtd-maxnoofexecutionthreads
<http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbmtd-maxnoofexecutionthreads>
) data node parameters require system initial restarts
(restart="system" initial="true"). (Bug #28494286)
* Executing SELECT
(http://dev.mysql.com/doc/refman/5.7/en/select.html) *
FROM INFORMATION_SCHEMA.TABLES
(http://dev.mysql.com/doc/refman/5.7/en/tables-table.html
) caused SQL nodes to restart in some cases. (Bug
#27613173)
* When running a cluster with 4 or more data nodes under
very high loads, data nodes could sometimes fail with
Error 899 Rowid already allocated. (Bug #25960230)
* When starting, a data node copies metadata, while a local
checkpoint updates metadata. To avoid any conflict, any
ongoing LCP activity is paused while metadata is being
copied. An issue arose when a local checkpoint was paused
on a given node, and another node that was also
restarting checked for a complete LCP on this node; the
check actually caused the LCP to be completed before
copying of metadata was complete and so ended the pause
prematurely. Now in such cases, the LCP completion check
waits to complete a paused LCP until copying of metadata
is finished and the pause ends as expected, within the
LCP in which it began. (Bug #24827685)
* Asynchronous disconnection of mysqld from the cluster
caused any subsequent attempt to start an NDB API
transaction to fail. If this occurred during a bulk
delete operation, the SQL layer called
HA::end_bulk_delete(), whose implementation by
ha_ndbcluster assumed that a transaction had been
started, and could fail if this was not the case. This
problem is fixed by checking that the transaction pointer
used by this method is set before referencing it. (Bug
#20116393)
* NdbScanFilter did not always handle NULL according to the
SQL standard, which could result in sending
non-qualifying rows to be filtered (otherwise not
necessary) by the MySQL server. (Bug #92407, Bug
#28643463)
* NDB attempted to use condition pushdown on greater-than
(>) and less-than (<) comparisons with ENUM
(http://dev.mysql.com/doc/refman/5.7/en/enum.html) column
values but this could cause rows to be omitted in the
result. Now such comparisons are no longer pushed down.
Comparisons for equality (=) and inequality (<> / !=)
with ENUM values are not affected by this change, and
conditions including these comparisons can still be
pushed down. (Bug #92321, Bug #28610217)
On Behalf of Oracle/MySQL Release Engineering Team
Prashant Tekriwal