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

Lightsail MySQL Database: upgrade to 8.0.33 (mysqldump single transaction bug)

0

Hello, the new version of MySQL 8.0.33 solves a big problem related to single-transaction backup: https://bugs.mysql.com/bug.php?id=109685

My lightsail DB instance is still at version 8.0.31 Is there any way to force the update or should I just wait for AWS to do it? And when will this update be expected?

Thanks

Topics
ComputeMigration & ModernizationAnalyticsDatabase
Tags
Amazon LightsailAmazon Relational Database ServiceDatabaseMySQL
Language
English
rePost-User-7457536
asked 2 years ago508 views
2 Answers
0
Accepted Answer

Does your database use RDS?
In that case, you can update up to 8.0.32 as it is supported.
However, the following documentation shows that 8.0.33 is not yet supported and cannot be used with RDS.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.VersionMgmt.html

profile picture
EXPERT
Riku_Kobayashi
answered 2 years ago
0

My database is a "Lightsail managed database", as I know it's built on RDS. I think at the moment the only way is to create a new database with a new version and restore a backup from the old database. But at the moment only v8.0.32 is available as you said so I just have to wait for AWS to be able to upgrade. Thank you

rePost-User-7457536
answered 2 years 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