Question

Strategies for migrating a large database into Digital Ocean Managed Databases

Considering you cannot set the server as a slave, I don’t see a way forward to be able to import a fairly large database with no downtime to Digital Ocean Managed Databases.

Is this service only designed for new projects, or projects that can have downtime? Or is there some alternative way to migrate without having to set a remote master to get it in sync with my db?

Subscribe
Share

I’d also like to know if there is a possibility to set up a server as a slave to an external master.

For example with RDS you can use call mysql.rds_set_external_master


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.

Also interested in this answer - importing a fairly small DB (20gb) and it’s taking far too long to do without replication.