By scottfriebel
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.
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!
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! :)
Hope that helps!
- Bobby.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
