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.


Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.