FinOps Update – Upgrade AWS RDS MySQL 5.7 to MySQL 8.0

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.