Aurora MySQL database engine updates 2019-11-25 (version 1.22.0) (Deprecated)
Version: 1.22.0
Aurora MySQL 1.22.0 is generally available. Aurora MySQL 1.* versions are compatible with MySQL 5.6 and Aurora MySQL 2.* versions are compatible with MySQL 5.7.
This engine version is scheduled to be deprecated on February 28, 2023. For more information, see Preparing for Amazon Aurora MySQL-Compatible Edition version 1 end of life.
Currently supported Aurora MySQL releases are 1.19.5, 1.19.6, 1.22.*, 1.23.*, 2.04.*, 2.07.*, 2.08.*, 2.09.*, 2.10.*, 3.01.* and 3.02.*.
To create a cluster with an older version of Aurora MySQL, please specify the engine version through the Amazon Web Services Management Console, the Amazon CLI or the RDS API. You have the option to upgrade existing Aurora MySQL 1.* database clusters to Aurora MySQL 1.22.0.
Note
This version is currently not available in the following Amazon Regions: Amazon GovCloud (US-East) [us-gov-east-1], Amazon GovCloud (US-West) [us-gov-west-1], China (Ningxia) [cn-northwest-1], Asia Pacific (Hong Kong) [ap-east-1], Middle East (Bahrain) [me-south-1], and South America (São Paulo) [sa-east-1]. There will be a separate announcement once it is made available.
If you have any questions or concerns, Amazon Support is available on the community forums and through
Amazon Support
Note
The procedure to upgrade your DB cluster has changed. For more information, see Upgrading the minor version or patch level of an Aurora MySQL DB cluster in the Amazon Aurora User Guide.
Improvements
New features:
-
Aurora MySQL clusters now support the instance types r5.8xlarge, r5.16xlarge and r5.24xlarge.
-
Binlog has new enhancements for improved commit time latency when very large transactions are involved.
-
Aurora MySQL now has a mechanism to minimize the time window during which events of a large transaction are written to binlog on commit. This effectively prevents lengthy offline recovery incurred when database crashes occur during that time window. This feature also fixes the issue where a large transaction blocks small transactions on binlog commit. This feature is off by default and can be enabled by the service team if needed for your workload. When enabled, it will be triggered when a transaction size is > 500MB.
-
Added support for the ANSI
READ COMMITTED
isolation level on the read replicas. This isolation level enables long-running queries on the read replica to execute without impacting the high throughput of writes on the writer node. For more information, see Aurora MySQL isolation levels. -
Global Databases now allow adding secondary read-only replica regions for database clusters deployed in these Amazon Regions: regions: US East (N. Virginia) [us-east-1], US East (Ohio) [us-east-2], US West (N. California) [us-west-1], US West (Oregon) [us-west-2], Europe (Ireland) [eu-west-1], Europe (London) [eu-west-2], Europe (Paris) [eu-west-3], Asia Pacific (Tokyo) [ap-northeast-1], Asia Pacific (Seoul) [ap-northeast-2], Asia Pacific (Singapore) [ap-southeast-1], Asia Pacific (Sydney) [ap-southeast-2], Canada (Central) [ca-central-1], Europe (Frankfurt) [eu-central-1], and Asia Pacific (Mumbai) [ap-south-1].
-
The hot row contention feature is now generally available and does not require the Aurora lab mode setting to be ON. This feature substantially improves throughput for workloads with many transactions contending for rows on the same page.
-
This version has updated timezone files to support the latest Brazil timezone update for new clusters.
Critical fixes:
High priority fixes:
-
Fixed an issue in the DDL recovery component that resulted in prolonged database downtime. Clusters that become unavailable after executing
TRUNCATE TABLE
query on a table with anAUTO_INCREMENT
column should be updated. -
Fixed an issue in the DDL recovery component that resulted in prolonged database downtime. Clusters that become unavailable after executing
DROP TABLE
query on multiple tables in parallel should be updated.
General stability fixes:
-
Fixed an issue that caused read replicas to restart during a long-running transaction. Customers who encounter replica restarts that coincide with an accelerated drop in freeable memory should consider upgrading to this version.
-
Fixed an issue that incorrectly reported
ERROR 1836
when a nested query is executed against a temporary table on the read replica. -
Fixed a parallel query abort error on an Aurora reader instance while a heavy write workload is running on the Aurora writer instance.
-
Fixed an issue that causes a database configured as a Binlog Master to restart while a heavy write workload is running.
-
Fixed an issue of prolonged unavailability while restarting the engine. This addresses an issue in the buffer pool initialization. This issue occurs rarely but can potentially impact any supported release.
-
Fixed an issue that generated inconsistent data in the
information_schema.replica_host_status
table. -
Fixed a race condition between the parallel query and the standard execution paths that caused the Reader nodes to restart intermittently.
-
Improved stability of the database when the number of number of client connections exceeds the
max_connections
parameter value. -
Improved stability of the reader instances by blocking unsupported DDL and
LOAD FROM S3
queries.
Integration of MySQL community edition bug fixes
-
Bug#16346241 - SERVER CRASH IN ITEM_PARAM::QUERY_VAL_STR
-
Bug#17733850 - NAME_CONST() CRASH IN ITEM_NAME_CONST::ITEM_NAME_CONST()
-
Bug #20989615 - INNODB AUTO_INCREMENT PRODUCES SAME VALUE TWICE
-
Bug #20181776 - ACCESS CONTROL DOESN'T MATCH MOST SPECIFIC HOST WHEN IT CONTAINS WILDCARD
-
Bug #27326796 - MYSQL CRASH WITH INNODB ASSERTION FAILURE IN FILE PARS0PARS.CC
-
Bug #20590013 - IF YOU HAVE A FULLTEXT INDEX AND DROP IT YOU CAN NO LONGER PERFORM ONLINE DDL