By JohnJake
Hey everyone I would like to ask if this case is possible, I wanted to setup a replication of master to master from my localhost to my VPN (DigitalOcean) MySQL. As I’m using C# application for my localhost and PHP application to my Remote host, and I wanted both Server (Local and VPN) data to sync each other. So whatever transaction (Insert, Edit, Delete) are done in localhost, are also available in my VPN and vice versa.
if Possible my Question:
1.) What OS do i need to install in my Localhost? as Im using Xampp for MySQL and windows 10 for my OS, in my localhost and Centos 7.xx.x in my VPN and MariaDB.
2.) What database would I used for this case MariaDB (MySQL) or PostgreSQL?.
I really appreciate someone who could give me some guide or links for the tutorial.
Thanks A lot
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!
Once you have the networking piece out of the way and your local computer can connect to your droplet and your droplet can connect to your local server this is fairly straightforward to set up.
This guide will walk you through master-master replication setup on MySQL or MariaDB.
PostgreSQL also supports replication settings if it is a better fit for your uses.
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.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.