Upgrade your databases - AWS ending support for MySQL 5.7 in January/February 2024.
AWS RDS is ending support for MySQL versions 5.7.x starting in January/February 2024.
Please note: AWS has updated the end of support for MySQL 5.7 databases to January/February 2024. A previous version of this post said that support for MySQL 5.7 was ending December 2023.
What this means for you
As a cloud.gov customer, if you are running a MySQL 5.7 database, then you will need to upgrade that database to at least MySQL version 8.0 by January/February 2024. Affected customers will receive direct outreach from the cloud.gov team.
To upgrade your database from MySQL 5.7 to 8.0, see the guidance below.
If you do not upgrade your database by January/February 2024, then AWS will automatically upgrade your database to the next supported major version (currently 8.0) during the next maintenance window for your database.
Important dates
When | What |
---|---|
June 5, 2023 | MySQL 5.7 databases can no longer be created on cloud.gov |
June 5 2023 - January/February 2024 | Window for customers to self-upgrade their MySQL databases to 8.0 |
January/February 2024 | MySQL 5.7 databases are fully deprecated by AWS. Any remaining databases are auto-upgraded to the next supported major version. |
Updates to brokered database plans
As of today, June 5, 2023, it is no longer possible to create an RDS database using MySQL version 5.7 for any of the mysql
plans in the marketplace. By default, version “8.0” will be used for new MySQL databases.
You can find more information about creating/updating RDS databases on our database services documentation.
How to upgrade
To upgrade your existing MySQL 5.7 database to MySQL 8.0:
-
Target your organization and space:
cf target -o <ORG> -s <SPACE>
-
Create a new database service using the same database plan as your MySQL 5.7 database:
cf create-service aws-rds <plan-name> <mysql-80-database-name>
-
Use the
cg-manage-rds
plugin to export a backup of your MySQL 5.7 database:cg-manage-rds export -f backup.sql <mysql57-database-name>
-
Import the backup into your MySQL 8.0 database:
cg-manage-rds import -f backup.sql <mysql80-database-name>
-
Optionally, use the
cf-service-connect
plugin to connect to your MySQL 8.0 database and verify that it contains the expected data:cf connect-to-service <app-name> <mysql80-database-name>
-
Bind your MySQL 8.0 database to your application:
cf bind-service <app-name> <mysql80-database-name>
-
Unbind your MySQL 5.7 database from your application:
cf unbind-service <app-name> <mysql57-database-name>
-
Restage your application (the
--strategy rolling
flag is optional but ensures no downtime):cf restage <app-name> --strategy rolling
-
Verify that your application is still working and operating with the expected data.
If you have any issues with this process, please contact support@cloud.gov.