question

YoniYahav-2844 avatar image
0 Votes"
YoniYahav-2844 asked YoniYahav-2844 commented

migration from mysql 5.7 to Mysql 8 managed

We have mysql 5.7 on azure ubuntu 14.04.6 servers we want to migrate to azure mysql 8 managed instances. I didn't see in azure an option to migrate to 8 but only to 5.7. is there a way if we migrate to 5.7 managed then to upgrade to 8 or migrate to 8 from 5.7? I tried to upgrade our current mysql 5.7 to 8 but I need to upgrade ubuntu to 16.04 because mysql upgrade to 8 needs at least ubuntu 16.04 which succeeded (I’m not a Linux wiz) and then tried upgrading mysql from 5.7 to 8 but it fails. i tried upgrading to latest 5.7 and then to 8 but it also fails and if it succeeded the databases disappeared. i do think the ubuntu upgrade to 16.04 messed up things. Does anyone know of a simple way to do this?
We need to do this with as minimum down time as possible.
Thanks

azure-database-mysqlazure-database-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
1 Vote"
NavtejSaini-MSFT answered YoniYahav-2844 commented

@YoniYahav-2844

The major version upgrade using the DMS Data migration service is not supported. Please provide the feedback here for adding this feature.

You can use the dump and restore but still it is preferred that you upgrade your mysql before moving to azure database for Mysql. One of the scenario is explained here in detail.

Please get back to us for any questions.

Regards
Navtej S


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Will check
Thanks.

0 Votes 0 ·