How to Upgrade MySql Azure from 5.7 to 8.0 in the Azure Portal

Question

I have a very small restore Azure Database for MySql on which I am trying to perform a major Upgrade from v5.7 to v8.0 using the Azure portal. The "Upgrade" button is not showing in the Overview. The database is in the Burstable pricing tier (though I don't need that level of service during development, and "higher" tiers don't seem necessary either). While perhaps not related, the MySql Shell util.checkForServerUpgrade is showing 3 errors connected to an "unexpected token 'REPLICATION'" (which I also don't know how to fix). I have traced all of the links I've found related to this, but am now at a loss.

I am trying to do all of this in response to an email I got from MS suggesting the upgrade as a result of Oracle dropping further upgrades to 5.7.

Answer 1

Hi Steve Rehling •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

We are sorry to inform that we have below limitation and workaround for Burstable SKU:

Burstable SKU is not able to support major version upgrade due to the performance limitation of this SKU.Microsoft is still working on a way to make this SKU available for major version upgrade.

If you need to perform a major version upgrade on your Azure MySQL Flexible Server and are currently using Burstable SKU, one temporary solution would be to upgrade to General Purpose or Business Critical SKU, perform the upgrade, and then switch back to Burstable SKU.

Please note that upgrading to a higher SKU may involve a change in pricing and may result in increased costs for your deployment. However, since the upgrade process is not expected to take a long time, the additional costs should not be significant.

Also, before you can upgrade your primary server, you first need to have upgraded any associated read replica servers. Until this is completed, Upgrade will be disabled.

Reference: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade

Hope this helps. Do let us know if you have further queries.

Thanks