Your MySQL 5.7 and PostgreSQL 11 databases might be routinely enrolled into Amazon RDS Prolonged Assist

Voiced by Polly

Immediately, we’re saying that your MySQL 5.7 and PostgreSQL 11 database cases operating on Amazon Aurora and Amazon Relational Database Service (Amazon RDS) might be routinely enrolled into Amazon RDS Prolonged Assist beginning on February 29, 2024.

This may assist keep away from unplanned downtime and compatibility points that may come up with routinely upgrading to a brand new main model. This gives you with extra management over while you need to improve the most important model of your database.

This computerized enrollment might imply that you’ll expertise larger prices when RDS Prolonged Assist begins. You may keep away from these prices by upgrading your database to a more moderen DB model earlier than the beginning of RDS Prolonged Assist.

What’s Amazon RDS Prolonged Assist?
In September 2023, we introduced Amazon RDS Prolonged Assist, which lets you proceed operating your database on a significant engine model previous its RDS finish of ordinary help date on Amazon Aurora or Amazon RDS at a further value.

Till group finish of life (EoL), the MySQL and PostgreSQL open supply communities handle widespread vulnerabilities and exposures (CVE) identification, patch era, and bug fixes for the respective engines. The communities launch a brand new minor model each quarter containing these safety patches and bug fixes till the database main model reaches group finish of life. After the group finish of life date, CVE patches or bug fixes are not accessible and the group considers these engines unsupported. For instance, MySQL 5.7 and PostgreSQL 11 are not supported by the communities as of October and November 2023 respectively. We’re grateful to the communities for his or her continued help of those main variations and a clear course of and timeline for transitioning to the latest main model.

With RDS Prolonged Assist, Amazon Aurora and RDS takes on engineering the vital CVE patches and bug fixes for as much as three years past a significant model’s group EoL. For these 3 years, Amazon Aurora and RDS will work to establish CVEs and bugs within the engine, generate patches and launch them to you as rapidly as attainable. Below RDS Prolonged Assist, we are going to proceed to supply help, such that the open supply group’s finish of help for an engine’s main model doesn’t depart your functions uncovered to vital safety vulnerabilities or unresolved bugs.

You may marvel why we’re charging for RDS Prolonged Assist relatively than offering it as a part of the RDS service. It’s as a result of the engineering work for sustaining safety and performance of group EoL engines requires AWS to take a position developer sources for vital CVE patches and bug fixes. That is why RDS Prolonged Assist is simply charging clients who want the extra flexibility to remain on a model previous group EoL.

RDS Prolonged Assist could also be helpful that will help you meet your enterprise necessities to your functions when you have explicit dependencies on a particular MySQL or PostgreSQL main model, akin to compatibility with sure plugins or customized options. If you’re presently operating on-premises database servers or self-managed Amazon Elastic Compute Cloud (Amazon EC2) cases, you possibly can migrate to Amazon Aurora MySQL-Suitable Version, Amazon Aurora PostgreSQL-Suitable Version, Amazon RDS for MySQL, Amazon RDS for PostgreSQL past the group EoL date, and proceed to make use of these variations these variations with RDS Prolonged Assist whereas benefiting from a managed service. If it is advisable to migrate many databases, you too can make the most of RDS Prolonged Assist to separate your migration into phases, making certain a clean transition with out overwhelming IT sources.

In 2024, RDS Prolonged Assist might be accessible for RDS for MySQL main variations 5.7 and better, RDS for PostgreSQL main variations 11 and better, Aurora MySQL-compatible model 2 and better, and Aurora PostgreSQL-compatible model 11 and better. For an inventory of all future supported variations, see Supported MySQL main variations on Amazon RDS and Amazon Aurora main variations within the AWS documentation.

Neighborhood main model RDS/Aurora model Neighborhood finish of life date Finish of RDS commonplace help date Begin of RDS Prolonged Assist pricing Finish of RDS Prolonged Assist
MySQL 5.7 RDS for MySQL 5.7 October 2023 February 29, 2024 March 1, 2024 February 28, 2027
Aurora MySQL 2 October 31, 2024 December 1, 2024
PostgreSQL 11 RDS for PostgreSQL 11 November 2023 February 29, 2024 April 1, 2024 March 31, 2027
Aurora PostgreSQL 11

Word: RDS Prolonged Assist for PostgreSQL 11 begins on March 1, 2024, however won’t be charged till April 1, 2024. Between March 1 and March 31, all PostgreSQL 11 cases on Aurora and RDS are coated below RDS Prolonged Assist. RDS Prolonged Assist for Aurora MySQL 2 begins on November 1, 2024, however won’t be charged till December 1, 2024. Between November 1 and November 30, all Aurora MySQL 2 clusters are coated below RDS Prolonged Assist.

RDS Prolonged Assist is priced per vCPU per hour. Study extra about pricing particulars and timelines for RDS Prolonged Assist at Amazon Aurora pricing, RDS for MySQL pricing, and RDS for PostgreSQL pricing. For extra data, see the weblog posts about Amazon RDS Prolonged Assist for MySQL and PostgreSQL databases within the AWS Database Weblog.

Why are we routinely enrolling all databases to Amazon RDS Prolonged Assist?
We had initially knowledgeable you that RDS Prolonged Assist would supply the opt-in APIs and console options in December 2023. In that announcement, we mentioned that when you determined to not choose your database in to RDS Prolonged Assist, it will routinely improve to a more moderen engine model beginning on March 1, 2024. For instance, you’ll be upgraded from Aurora MySQL 2 or RDS for MySQL 5.7 to Aurora MySQL 3 or RDS for MySQL 8.0 and from Aurora PostgreSQL 11 or RDS for PostgreSQL 11 to Aurora PostgreSQL 15 and RDS for PostgreSQL 15, respectively.

Nevertheless, we heard a number of suggestions from clients that these computerized upgrades might trigger their functions to expertise breaking modifications and different unpredictable habits between main variations of group DB engines. For instance, an unplanned main model improve may introduce compatibility points or downtime if functions aren’t prepared for MySQL 8.0 or PostgreSQL 15.

Automated enrollment in RDS Prolonged Assist provides you further time and extra management to arrange, plan, and take a look at your database upgrades by yourself timeline, offering you flexibility on when to transition to new main variations whereas persevering with to obtain vital safety and bug fixes from AWS.

If you happen to’re anxious about elevated prices as a result of computerized enrollment in RDS Prolonged Assist, you possibly can keep away from RDS Prolonged Assist and related prices by upgrading earlier than the tip of RDS commonplace help.

Easy methods to improve your database to keep away from RDS Prolonged Assist prices
Though RDS Prolonged Assist helps you schedule your improve by yourself timeline, sticking with older variations indefinitely means lacking out on one of the best price-performance to your database workload and incurring further prices from RDS Prolonged Assist.

MySQL 8.0 on Aurora MySQL, also called Aurora MySQL 3, unlocks help for common Aurora options, akin to World Database, Amazon RDS Proxy, Efficiency Insights, Parallel Question, and Serverless v2 deployments. Upgrading to RDS for MySQL 8.0 gives options together with as much as thrice larger efficiency versus MySQL 5.7, akin to Multi-AZ cluster deployments, Optimized Reads, Optimized Writes, and help for AWS Graviton2 and Graviton3-based cases.

PostgreSQL 15 on Aurora PostgreSQL helps the Aurora I/O Optimized configuration, Aurora Serverless v2, Babelfish for Aurora PostgreSQL, pgvector extension, Trusted Language Extensions for PostgreSQL (TLE), and AWS Graviton3-based cases in addition to group enhancements. Upgrading to RDS for PostgreSQL 15 gives options akin to Multi-AZ DB cluster deployments, RDS Optimized Reads, HypoPG extension, pgvector extension, TLEs for PostgreSQL, and AWS Graviton3-based cases.

Main model upgrades might make database modifications that aren’t backward-compatible with current functions. You need to manually modify your database occasion to improve to the most important model. It’s strongly really useful that you simply completely take a look at any main model improve on non-production cases earlier than making use of it to manufacturing to make sure compatibility together with your functions. For extra details about an in-place improve from MySQL 5.7 to eight.0, see the incompatibilities between the 2 variations, Aurora MySQL in-place main model improve, and RDS for MySQL upgrades within the AWS documentation. For the in-place improve from PostgreSQL 11 to fifteen, you should use the pg_upgrade technique.

To reduce downtime throughout upgrades, we advocate utilizing Totally Managed Blue/Inexperienced Deployments in Amazon Aurora and Amazon RDS. With only a few steps, you should use Amazon RDS Blue/Inexperienced Deployments to create a separate, synchronized, absolutely managed staging surroundings that mirrors the manufacturing surroundings. This entails launching a parallel inexperienced surroundings with higher model replicas of your manufacturing databases decrease model. After validating the inexperienced surroundings, you possibly can shift site visitors over to it. Then, the blue surroundings could be decommissioned. To study extra, see Blue/Inexperienced Deployments for Aurora MySQL and Aurora PostgreSQL or Blue/Inexperienced Deployments for RDS for MySQL and RDS for PostgreSQL within the AWS documentation. Normally, Blue/Inexperienced Deployments are the most suitable choice to cut back downtime, aside from restricted instances in Amazon Aurora or Amazon RDS.

For extra data on performing a significant model improve in every DB engine, see the next guides within the AWS documentation.

Now accessible
Amazon RDS Prolonged Assist is now accessible for all clients operating Amazon Aurora and Amazon RDS cases utilizing MySQL 5.7, PostgreSQL 11, and better main variations in AWS Areas, together with the AWS GovCloud (US) Areas past the tip of the usual help date in 2024. You don’t must choose in to RDS Prolonged Assist, and also you get the pliability to improve your databases and continued help for as much as 3 years.

Study extra about RDS Prolonged Assist within the Amazon Aurora Consumer Information and the Amazon RDS Consumer Information. For pricing particulars and timelines for RDS Prolonged Assist, see Amazon Aurora pricing, RDS for MySQL pricing, and RDS for PostgreSQL pricing.

Please ship suggestions to AWS re:Publish for Amazon RDS and Amazon Aurora or via your common AWS Assist contacts.


Replace December 22, 2022 – This publish has been up to date for readability to offer the knowledge of charged interval about RDS Prolonged Assist for our readers.

Related Articles


Please enter your comment!
Please enter your name here

Latest Articles