Upgrade AWS EKS – Older Version to Latest Otherwise Pay 500%! Learn More

Amazon RDS for MySQL 5.7 will reach end of standard support on February 29, 2024

Introduction:-

MySQL is a widely used relational database management system (RDBMS). MySQL is free and open-source. MySQL is ideal for both small and large applications. AWS RDS is managed SQL database service provided by AWS cloud.

In Groots, We use AWS MySQL RDS as the main database for our application and we are running MySQL 5.7 version. This blog post is about upgrading our RDS from MySQL 5.7 to MySQL 8.0.31

MySQL community plans to deprecate MySQL 5.7 in October-2023 and will not provide any security patches or bug fixes after October 2023. Following community timelines, Amazon RDS will end standard support of MySQL major version 5.7 on 29 February, 2024.

We recommend that you take action and upgrade your MySQL databases (DB) running major version 5.7 to major version 8.0 before RDS end of standard support in February, 2024. MySQL 8.0 offers new query functionality, enhancements for better performance, reliability, security and manageability. 

Supported MySQL minor versions on Amazon RDS

RDS for MySQL major versions are available under standard support at least until community end of life for the corresponding community version. You can continue running a major version past its RDS end of standard support date for a fee.   You can use the following dates to plan your testing and upgrade cycles.  
Major Version Release Date End of Life Date RDS Release Date RDS Standard Support End Date RDS Extended Support Year 1 Pricing Date RDS Extended Support Year 3 Pricing Date RDS Extended Support End Date
MySQL 8.0 19 April 2018 April 2026 23 October 2018 31 July 2026 1 August 2026 1 March 2024 31 July 2029
MySQL 5.7* 21 October 2015 October 2023 22 February 2016 29 February 2024 1 August 2028 1 March 2026 28 February 2027
New features in RDS upgradation

Window Functions and Common Table Expressions (WITH queries) to reduce query complexity. JSON: Functions for converting JSON to relational tables, merging JSON objects, and aggregation; utilities for sizing and printing JSON objects; support for range expressions and the operator; and higher performance for partial in-place updates and sorting.

Security :-    Roles, which are named collections of privileges, for granting and denying permissions to    groups    of users; support for password strength and password reuse policies; and use of   OpenSSL as the default TLS/SSL library.

Major :- The major version number is both the integer and the first fractional part of the version number, for example, 8.0. A major version upgrade increases the major part of the version number. For example, an upgrade from 5.7.44 to 8.0.33 is a major version upgrade, where 5.7 and 8.0 are the major version numbers.

Minor :- The minor version number is the third part of the version number, for example, the 33 in 8.0.33.

Patch :-The patch is the fourth part of the version number, for example, the R2 in 8.0.33.R2. An RDS patch version includes important bug fixes added to a minor version after its releases

Conclusion:

In conclusion, as Amazon RDS for MySQL 5.7 reaches the end of standard support on February 29, 2024, it is imperative for users to promptly plan and execute migration strategies. Upgrading to MySQL 8.0.31 offers enhanced query functionality, improved performance, security features, and compatibility with the latest advancements in database management technology. users can align with industry standards, leverage cutting-edge features, and ensure long-term resilience in the AWS cloud environment.