Hello,
I was notified on the AWS Health Dashboard about the deprecation of RDS MySQL 5.7 and that it will be automatically migrated to MySQL 8.0 unless I opt in to Extended Support. I started migrating our application and encounterd problems, so we will need the Extended Support.
I have the following questions:
- How can I opt in to RDS Extended Support so that the MySQL databases are not force migrated from version 5.7 to 8.0?
- How fast is Extended Support activated? I was notified that starting January 16th the auto migrations are executed. What is the deadline to activate Extended Support so that does not happen?
- What is the maximal duration of Extended Support?
- What is the minimal duration of Extended Support? E.g. if we manage to perform our migration from MySQL 5.7 to 8.0 within two months, are we only billed for that duration or is there a minimal duration that we pay?
- What is the cost for Extended Support?
The information from different notifications is confusing and sometimes contradicting.
In one notification is stated that the 5.7 version is auto migrated to 8.0 if I don't do anything (Event start time: January 16, 2024 at 8:00:00 AM UTC+1):
"We recommend you to upgrade your databases before January 16, 2024. RDS will upgrade your MySQL databases running minor versions 5.7.37, 5.7.38, 5.7.39, 5.7.40, 5.7.41 and 5.7.42 as well as any instances restored from the snapshots of these versions to MySQL major version 8.0 during a scheduled maintenance window [...]"
It also says that I can opt in to RDS Extended Support, then the force migration will not happen:
"If you have opted in to RDS Extended Support on your RDS for MySQL 5.7 DB instance, RDS will NOT auto-upgrade that DB instance to MySQL 8.0, but your instance will be upgraded to MySQL 5.7.44"
In a different Health Dashboard notification (Start time: February 29, 2024 at 8:00:00 AM UTC+1) i have found different dates. Here the migration is not applied after January 16th, but starting March 1:
"If you have not opted in to RDS Extended Support on your RDS for MySQL 5.7 instance, the timeline for your DB instance will be as follows: RDS will upgrade your MySQL 5.7 database to MySQL 8.0 during a scheduled maintenance window between March 1, 2024 00:00:01 UTC and March 31, 2024 00:00:01 UTC. On March 31, 2024 00:00:01 AM UTC, any MySQL 5.7 databases that remain will be automatically upgraded to version 8.0 regardless of instances’ scheduled maintenance window."
Thanks in advance for your help.
Best regards, Marc
AWS OFFICIALUpdated 9 months ago
Hi Didier,
Thank you for your fast reply!
I already had a look at some of these documents and there is still some information unclear to me, that's why I opened this question. In your linked page is stated: "Starting in December, 2023, you will be able to opt-in to Amazon RDS Extended Support through the AWS Console" But it does not state how I can opt in, I was not able to find an option in the AWS Console. I also followed the links to the RDS MySQL pages (I skipped the ones for Aurora and PostgreSQL), but could not find out how to opt in to extended support.
Other users have asked similar questions here (e.g. https://repost.aws/questions/QU1UZ3V1kwRrOqw6rAzJpYwA/rds-extended-support-for-mysql-5-7-database-is-missing), and here it is stated that the enrollement into RDS Extended Support happens automatically and I don't have to do anything. But this is a contradiction to what I see in the AWS Health Dashboard and also to the information provided in your link.
So what is now correct? This is a bit confusing.
Thanks, Marc