MySQL Cluster NDB 7.1.18 is a new release of MySQL Cluster,
incorporating new features in the
NDBCLUSTER storage engine and
fixing recently discovered bugs in previous MySQL Cluster NDB
7.1 releases.
Obtaining MySQL Cluster NDB 7.1. The latest MySQL Cluster NDB 7.1 binaries for supported platforms can be obtained from http://dev.mysql.com/downloads/cluster/. Source code for the latest MySQL Cluster NDB 7.1 release can be obtained from the same location. You can also access the MySQL Cluster NDB 7.1 development source tree at https://code.launchpad.net/~mysql/mysql-server/mysql-cluster-7.1.
This release also incorporates all bugfixes and changes made in previous MySQL Cluster releases, as well as all bugfixes and feature changes which were added in mainline MySQL 5.1 through MySQL 5.1.56 (see Changes in MySQL 5.1.56 (2011-03-01)).
Bugs Fixed
Added the MinFreePct
data node configuration parameter, which specifies a percentage
of data node resources to hold in reserve for restarts. The
resources monitored are
DataMemory,
IndexMemory, and any
per-table MAX_ROWS settings (see
CREATE TABLE Syntax). The default value of
MinFreePct is 5, which
means that 5% from each these resources is now set aside for
restarts.
(Bug #13436216)
Because the log event buffer used internally by data nodes was circular, periodic events such as statistics events caused it to be overwritten too quickly. Now the buffer is partitioned by log event category, and its default size has been increased from 4K to 8K. (Bug #13394771)
The BatchSize and
BatchByteSize
configuration parameters, used to control the maximum sizes of
result batches, are defined as integers. However, the values
used to store these were incorrectly interpreted as numbers of
bytes in the NDB kernel. This caused the
DBLQH kernel block to fail to detect when the
specified BatchByteSize
was consumed.
In addition, the DBSPJ kernel block could
miscalculate statistics for adaptive parallelism.
(Bug #13355055)
Previously, forcing simultaneously the shutdown of multiple data
nodes using SHUTDOWN -F in the
ndb_mgm management client could cause the
entire cluster to fail. Now in such cases, any such nodes are
forced to abort immediately.
(Bug #12928429)
A SubscriberNodeIdUndefined error was previously unhandled, resulting in a data node crash, but is now handled by NDB Error 1429, Subscriber node undefined in SubStartReq. (Bug #12598496)
SELECT statements using
LIKE
CONCAT(...) OR LIKE
CONCAT(...) in the WHERE clause
returned incorrect results when run against
NDB tables.
(Bug #11765142, Bug #58073)
Cluster Replication:
With many SQL nodes, all writing binary logs, connected to a
MySQL Cluster, RENAME TABLE could
cause data node processes (ndbmtd) to fail.
(Bug #13447705)
Cluster Replication:
It was possible for
PURGE MASTER
LOGS and SHOW BINARY
LOGS to deadlock when run concurrently.
(Bug #13400021)