Related

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

Question

Best method to sync Managed MySQL to MySQL on a Droplet

Posted February 3, 2020 581 views
DigitalOcean Managed MySQL Database

Hi,
I was hoping to use log shipping to sync a DB hosted on Managed MySQL to a DB on MySQL installed on a Droplet. Can I do this and is there any documentation, as I can’t seem to see any.
If I can’t sync using log shipping what do you recommend to sync at least once a day?
Thanks,
David

Add a comment
smartlist
By:
smartlist
Add a comment

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.

×
1 answer
Zehubert February 3, 2020

Unfortunately, the managed DBs won’t have any such access or options. If we could change basic settings such as key buffers etc, we’d be happy already.

In your case, it seems like it would be easier to schedule a CRON that dumps your Droplet’s DB to an .sql file, then import it into the manage dDB instance.

You should have control over all of that.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help