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