Upgrade to Amazon Aurora MySQL Version 3 with RDS Blue/Green Deployments | Amazon Web Services

This video is part two of our Amazon Aurora upgrade series. With the Amazon Aurora MySQL-Compatible Edition version 3 (with MySQL 8.0 compatibility), you can use the latest MySQL-compatible features, performance enhancements, bug fixes and other innovations like Amazon Aurora I/O-Optimized.

In this video we discuss the upgrade methods you can use to test the major version upgrade and apply it in production using the new Amazon RDS Blue/Green Deployments feature that provides reduced risk and downtime. Lastly, we also go over a quick demo and best practices while performing a major engine version upgrade.

Subscribe:

Do you have technical AWS questions?

ABOUT AWS
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers — including the fastest-growing startups, largest enterprises, and leading government agencies — are using AWS to lower costs, become more agile, and innovate faster.

#AWS #AmazonWebServices #CloudComputing

[synnnx]

1- decides to use blue/green to have no downtime
2- change a parameter in your parameter group for the blue/green
3- needs reboot to apply the change
4- have downtime

[RafaelSanzioMP]

Thank you for this video. This helps me upgrading MySQL version for the newest one and it worked. Thanks.

[zen___]

Could not find the link for in-place upgrade that you guys mentioned in the video

[BULLSHXTYT]

Amazingly I have a AuroraDB v2 cluster using default parameter group which cannot upgrade to v3 at all using all 3 methods. And yes I have posted my question in re:Post which as usual, I have ZERO helpful response at all. What a great user experience.

[JayronSoares-lc]

The following tables show signs that either the datadir directory or the frm file was removed or corrupted. If MySQL encounters this issue, it will write messages to the error logs, which you can check to understand the issue. These tables are considered orphan tables because the respective table data is present in the InnoDB data dictionary but is missing from the MySQL data dictionary.

[loandaika]

I have a question here, this version upgrade option result in downtime?

[call_of_duty]

these aws relational databases are more costlier than Oracle's

[zimiselemadani]

how did you set up your parameter group??

[ibuxdev]

A great feature but it's pity that AWS is treating CloudFormation as a second class citizen of the eco-system. It's been more than a year and Blue/Green deployment is not supported.

[flyworld-sqyh]

i have upgrade my database from 5.7 to 8.0 but which does it still show RDS Extended Support Enabled?

[fkhan]

can we rollback to another aurora2.0 cluster from Aurora 3.0 backup that was upgraded after BGD is completed? or in short, can we we restore aurora3.0 backup to aurora 2.0 instance?

[rayama]

what if our new green instance is not good enough..we want to roll back to our blue instance..then can we delete green instance????how to come stop blue green deploymemt process????