Upgrade your databases - AWS ending support for MySQL 5.7 in 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 December 2023. 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 December 2023, then AWS will automatically upgrade your database to the next supported major version (currently 8.0) during the next maintenance window for your database.
|June 5, 2023||MySQL 5.7 databases can no longer be created on cloud.gov|
|June 5 2023 - December 2023||Window for customers to self-upgrade their MySQL databases to 8.0|
|December 2023||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>
cg-manage-rdsplugin 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-connectplugin 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
--rollingflag is optional but ensures no downtime):
cf restage <app-name> --rolling
Verify that your application is still working and operating with the expected data.
If you have any issues with this process, please contact firstname.lastname@example.org.