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

Question

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

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

Answer

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

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

Contenuto pertinente