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?
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.
×
For example with RDS you can use
call mysql.rds_set_external_master
I’d also like to know if there is a possibility to set up a server as a slave to an external master.