Amazon RDS for MySQL LTS version 9.7 is now generally available
Database Blog
This article announces general availability of Amazon RDS for MySQL 9.7, the latest Long-Term Support version from the MySQL community.
- MySQL 9.7 is the second LTS release, incorporating features from Innovation Releases 9.0-9.6 with enhanced stability and backward compatibility
- Introduces JSON Duality Views for accessing relational tables as JSON documents with DML support
- Hypergraph Optimizer available to improve query plans for complex multi-join queries
- Group Replication enhancements include applier metrics, flow control statistics, resource manager, and primary election components
- mysql_native_password plugin removed; accounts must migrate to caching_sha2_password before upgrading
- MD5() and SHA1() SQL functions no longer available; use SHA2() instead
- require_secure_transport defaults to ON, requiring TLS for all client connections
- Blue/Green deployments recommended for safe testing and minimal downtime during upgrades
- Multi-AZ DB clusters with two readable standbys not supported at launch
- Comprehensive migration checklist provided covering pre-upgrade tasks, parameter changes, and new capabilities
Customers upgrading from MySQL 8.4 should review security changes, removed functions, and parameter defaults while leveraging new features like JSON Duality Views and improved replication components.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.