migration from mysql 5.7 to Mysql 8 managed

Yoni Yahav 21 Reputation points
2021-04-05T09:04:40.897+00:00

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 Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
824 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee
    2021-04-06T01:47:13.473+00:00

    @Yoni Yahav

    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 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.