Question

Error when setting up MySQL migration from a droplet to a new Managed DB.

I configured the existing mysql db on the current droplet with a user with full permissions and allowed external connections to the db. Then went through the “set up migration” steps on the Managed DB page (entered host name, db name, un/pass) and clicked “Test Connection”. The connection worked just fine and prompted me to start the migration.

As soon as I clicked Start Migration, an “Unknown error occurred” messaged showed up with no other indication of the problem. In google DevTools the start migration api call returned {"id": "Internal Server Error", "message": "Server Error" }. After closing the popup and/or refreshing the page, the Managed DB screen doesn’t show that there is any ongoing migration happening.

There definitely is though because when connecting to the DB itself via a separate tool, the tables are being created and populated. However; it appears to be a one-off transfer and not an ongoing logical replication as the migration tool suggests it will be. I need the ongoing replication so there isn’t downtime when transitioning the app from using the original db to the new managed db.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hey @scottfriebel,

Did you also enable GTID as described here:

https://docs.digitalocean.com/products/databases/mysql/how-to/migrate/#enable-gtid

If you have done this and you are still getting the error, this sounds like an internal issue. What I could suggest is to reach out to our amazing support team who will be more than happy to assist you with this issue! :)

https://www.digitalocean.com/support/

Hope that helps!

- Bobby.