Aurora MySQL database engine updates 2023-10-17 (version 2.11.4, compatible with MySQL 5.7.12)
Version: 2.11.4
Aurora MySQL 2.11.4 is generally available. Aurora MySQL 2.11 versions are compatible with MySQL 5.7.12.
For more information on community changes, see Changes in MySQL 5.7.12 (2016-04-11, General Availability)
The currently supported Aurora MySQL releases are 2.07.9, 2.07.10, 2.11.*, 2.12.*, 3.01.*, 3.02.*, 3.03.*, and 3.04.*.
You can upgrade an existing Aurora MySQL 2.* database cluster to Aurora MySQL 2.11.4. You can also restore a snapshot from any currently supported Aurora MySQL release into Aurora MySQL 2.11.4.
If you upgrade an Aurora MySQL global database to version 2.11.*, you must upgrade your primary and secondary DB clusters to the exact same version, including the patch level. For more information on upgrading the minor version of an Aurora global database, see Minor version upgrades.
Immediately after an in-place engine version upgrade to Aurora MySQL 2.11.* is performed, an operating system upgrade is applied automatically to all affected instances on the db.r4, db.r5, db.t2, and db.t3 DB instance classes, if the instances are running an old operating system version. In a Multi-AZ DB cluster, all of the reader instances apply the operating system upgrade first. When the operating system upgrade on the first reader instance is finished, a failover occurs and the previous writer instance is upgraded.
Note
The operating system upgrade isn't applied automatically to Aurora global databases during major version upgrades.
Note
For information on how to upgrade your Aurora MySQL database cluster, see Upgrading the minor version or patch level of an Aurora MySQL DB cluster in the Amazon Aurora User Guide.
If you have any questions or concerns, Amazon Support is available on the community forums and through
Amazon Support
Improvements
Fixed security issues and CVEs listed below:
-
Fixed an issue where the events that were reported while processing audit log rotations might not be written to the audit log.
Availability improvements:
-
Fixed an issue where Aurora MySQL database instances using parallel query may experience a database restart when running a high number of concurrent parallel queries.
-
Fixed an issue which can cause a database instance to restart while executing I/O intensive read workloads.
-
Fixed an issue which can cause a database instance restart when attempting to read a database page that belongs to a dropped table.
-
Fixed an issue which can cause the reader instance to restart when the writer instance grows the database volume to a multiple of 160GB.
-
Fixed an issue which can cause database cluster unavailability if the writer instance restarts while the database is creating or dropping triggers on internal system tables.
-
Fixed an issue which can cause a reader instance to restart when executing Data Manipulation Language (DML) queries on a table containing a full-text index.
-
Fixed an issue which can cause a reader instance to restart while executing a query which utilizes an Aurora parallel query execution plan.
-
Fixed an issue that can cause the writer instance to restart while executing the
OPTIMIZE TABLE
query on a table with a Full Text Search (FTS) index. -
Fast insert isn't enabled in this Aurora MySQL version, due to an issue that can cause inconsistencies when running queries such as
INSERT INTO
,SELECT
, andFROM
. For more information on the fast insert optimization, see Amazon Aurora MySQL performance enhancements.
General improvements:
-
Fixed an issue where small read replica instances may experience increased replication lag after upgrading from versions below 2.11.*.
-
Fixed an issue that can cause excessive log messages when consulting the procs_priv grant table
for verification of requests that involve stored routines. -
Fixed a memory management issue which can cause the database instance to use excessive memory while executing queries using the hash join optimization.
-
Fixed an issue that caused a restart of the database when executing
SELECT
statements with partitioned tables (created in a version of MySQL supporting the oldha_partition
partition handler) and parallel query is chosen by the query planner. -
Fixed an issue which can prevent new client connections from being established to the database when write forwarding is enabled.
-
Reduced binary log (binlog) replication lag when an Aurora MySQL binlog replica is executing
QUERY
events written to the source's binlog file without a default database defined by theUSE
command. -
Fixed an issue involving index scans where an inaccurate result might be returned when executing a
SELECT
query with theGROUP BY
clause and theaurora_parallel_query
parameter turnedON
. -
Added support for enabling and disabling session-level binary logging. See Stored Procedures - Replicating in the Amazon Aurora User Guide.
-
Fixed an issue that can cause a binlog replica to restart if the system variable server_uuid
of the source is missing or has an invalid value. -
Added support for setting session-level binary log format. See Stored Procedures - Replicating in the Amazon Aurora User Guide.
-
Fixed an issue which can cause the
CommitLatency
CloudWatch metric to be incorrectly reported when theinnodb_flush_log_at_trx_commit
parameter is not set to 1. -
Fixed an issue to prevent InnoDB statistics from getting stale, which can sometimes generate a sub-optimal query execution plan that may lead to an increase in query execution time.
-
Fixed an issue which can cause a database restart when connected binary log (binlog) consumers are using duplicate binlog replication server IDs.
Integration of MySQL Community Edition bug fixes
This release includes all community bug fixes up to and including 5.7.12, in addition to the below. For more information, see MySQL bugs fixed by Aurora MySQL 2.x database engine updates.
-
Replication: Some binary log events were not always handled correctly. (Bug #34617506)
-
Fixed an issue which can cause higher CPU utilization due to background TLS certificate rotation (Community Bug Fix #34284186).
-
In prepared statements, some types of subqueries could cause a server exit. (Bug #33100586)
Features not supported in Aurora MySQL version 2
The following features are currently not supported in Aurora MySQL version 2 (compatible with MySQL 5.7).
-
Scan batching. For more information, see Aurora MySQL database engine updates 2017-12-11 (version 1.16) (Deprecated).
MySQL 5.7 compatibility
This Aurora MySQL version is wire-compatible with MySQL 5.7 and includes features such as JSON support, spatial indexes, and generated columns. Aurora MySQL uses a native implementation of spatial indexing using z-order curves to deliver >20x better write performance and >10x better read performance than MySQL 5.7 for spatial datasets.
This Aurora MySQL version does not currently support the following MySQL 5.7 features:
-
Group replication plugin
-
Increased page size
-
InnoDB buffer pool loading at startup
-
InnoDB full-text parser plugin
-
Multisource replication
-
Online buffer pool resizing
-
Password validation plugin
-
Query rewrite plugins
-
Replication filtering
-
The
CREATE TABLESPACE
SQL statement