By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Minimize the downtime of Aurora mysql engine Upgrade.

0

Hi,

I want to upgrade our mysql engine 5.6 to latest available. I have 4TB of data in Aurora Mysql. So how i can perform this task in our production servers without downtime or Is there any way we can minimize the downtime.

Topics
DatabaseMigration & ModernizationAnalytics
Tags
PostgreSQLAmazon Relational Database ServiceDatabaseAmazon AuroraAurora MySQL
Language
English
profile picture
Himanshu Sharma
asked 2 years ago2694 views
1 Answer
2
Accepted Answer

To minimize the downtime during major version upgrade, blue-green upgrade technique could be the option. Please note, using blue-green upgrade, source cluster should be binary log enabled. To do this, need to engine restart to enable binary log and may cause some performance impact due to additional resource consumption by writing and shipping binaly log.

Another option should be in-place upgrade. You can estimate upgrade time by create cloned cluster and upgrade it for measuring upgrade time.

AWS
YUTAKA_H
answered 2 years ago
profile picture
EXPERT
Oleksii Bebych
reviewed 3 months ago
profile picture
EXPERT
Giovanni Lauria
reviewed 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content