[Announcement] (DEPRECATED) Amazon Relational Database Service (RDS) for MySQL 5.6 End-of-Life date is August 3, 2021


This is an outdated announcement. Please refer to the latest RDS for MySQL 5.6 end-of-life timeline here: https://forums.aws.amazon.com/ann.jspa?annID=8790

NOTE: This notice does not apply to Amazon Aurora clusters.

Amazon RDS is starting the end of life (EOL) process for MySQL major version 5.6. We are doing this because the MySQL community is planning to discontinue support for MySQL 5.6 on February 5, 2021 [1].

Amazon RDS for MySQL 5.6 will reach end of life on August 3, 2021 00:00:01 AM UTC. While you will be able to run your RDS for MySQL 5.6 databases between community MySQL 5.6 EOL (February 5, 2021) and RDS for MySQL 5.6 EOL (August 3, 2021), these databases will not receive any security patches during this extended availability period. We therefore strongly recommend that you proactively upgrade your databases to major version 5.7 or greater before community EOL on February 5, 2021. MySQL 5.7 contains major innovations including native support for JSON data type, GIS with native InnoDB spatial indexes and Performance Schema for new and improved performance metrics with the new SYS Schema [2]. MySQL 8.0 contains Window Functions, Common Table Expressions and also offers 2x higher performance compared to MySQL 5.7 [3]. Both versions contain numerous fixes to various software bugs in earlier versions of the database.

If you do not upgrade your databases before August 3, 2021, RDS will upgrade your MySQL 5.6 databases to 5.7 during a scheduled maintenance window between August 3, 2021 00:00:01 UTC and September 1, 2021 00:00:01 UTC. On September 1, 2021 00:00:01 AM UTC, any Amazon RDS for MySQL 5.6 databases that remain will be upgraded to version 5.7 regardless of whether the instances are in a maintenance window or not.

You can initiate an upgrade of your database instance — either immediately or during your next maintenance window — to a newer major version of MySQL using the AWS Management Console or the AWS Command Line Interface. The upgrade process will shut down the database instance, perform the upgrade, and restart the database instance. The database instance may be restarted multiple times during the upgrade process. While major version upgrades typically complete within the standard maintenance window, the duration of the upgrade depends on the number of objects within the database. To avoid any unplanned unavailability outside your maintenance window, we recommend that you first take a snapshot of your database and test the upgrade to get an estimate of the upgrade duration. If you are operating an Amazon RDS for MySQL 5.6 database on one of the retired instance types (t1, m1, m2), you will need to migrate to a newer instance type before upgrading the engine major version. To learn more about upgrading MySQL major versions in RDS, review the Upgrading Database Versions page [4].

We want to make you aware of the following additional milestones associated with upgrading databases that are reaching EOL.
• Now through August 3, 2021 00:00:01 AM UTC - You can initiate upgrades of Amazon RDS for MySQL 5.6 instances to MySQL 5.7 or 8.0 at any time.
• April 1, 2021 00:00:01 AM UTC – After this date and time, you cannot create new Amazon RDS instances with MySQL major version 5.6 from either the AWS Console or the CLI. You can continue to restore your MySQL 5.6 snapshots as well as create read replicas with version 5.6 until the August 3, 2021 end of support date.
• August 3, 2021 00:00:01 AM UTC - Amazon RDS will automatically upgrade MySQL 5.6 instances to version 5.7 within the earliest scheduled maintenance window that follows. After this date and time, any restoration of Amazon RDS for MySQL 5.6 database snapshots will result in an automatic upgrade of the restored database to a still supported version at the time.
• September 1, 2021 00:00:01 AM UTC - Amazon RDS will automatically upgrade any remaining MySQL 5.6 instances to version 5.7 whether or not they are in a maintenance window.

If you have any questions or concerns, the AWS Support Team is available on the community forums and via Premium Support [5].

[1] https://www.mysql.com/support/
[2] https://aws.amazon.com/about-aws/whats-new/2016/02/amazon-rds-now-supports-mysql-5-7/
[3] https://aws.amazon.com/about-aws/whats-new/2018/10/amazon-rds-now-supports-mysql-8/
[4] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html#USER_UpgradeDBInstance.Upgrading.Manual
[5] http://aws.amazon.com/support

  • This is an announcement migrated from AWS Forums that does not require an answer

asked 3 years ago1192 views
1 Answer

[Announcement] Does not require an answer.

profile pictureAWS
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions