Synchronize Local and Web Databases

Question

I have a system running on a web server, and also want to put it to run on the company’s local server (intranet), for performance reasons...

I realized I’d have a problem with the database synchronization between the two servers... I did some research on Replication, but nothing very enlightening...

I would like to know how I can do this sync instantly - Everything that is recorded on the local server, also be available on the web, and vice versa?

Can you get a tool from your own server for that? I don’t even need to know a function so when the guy clicks on a button, he automatically transfers the data from the local server to the web, and vice versa.

Could someone give me a little help?

Thanks in advance!

Answer 1

Expensive, in fact the safest way to do this is through Replication. However this feature is for asynchronous active-passive replication, it is most commonly used for data backup and/or redundancy purposes.

If you need an active-active replication, the only safe mode I see is via Mysql Cluster: https://www.mysql.com/products/cluster/ but this is not a free solution and I believe it is not cheap. Anyway the performance of a cluster also depends on the quality of the network (and at the end of the accounts will have a single ip).

You could explore other alternatives (local or remote cache ex Cloudfront in AWS) or just upload the application to the local network and point to the remote database.

Also take a look at this answer: How to backup the database to cloud and how to have data synchronized across multiple devices?

I hope I’ve helped in some way.

abs,