Synchronize Local and Web Database

1

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

I noticed that I had a problem with the database synchronization between the two servers ... I researched something about Replication, but nothing very enlightening ...

I would like to know how I can do this synchronization instantly - Anything recorded on the local server, also available on the web, and vice versa?

Do you give any tool on the server for this? I even need to know a function for when the guy clicks a button, automatically transfer the data from the local server to the web, and vice versa.

Could someone give me a HELP?

Thank you in advance!

    
asked by anonymous 07.03.2017 / 19:01

1 answer

2

Dear, 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 active replication, the only safe mode I see is through Mysql Cluster: link however this is not a free solution and I believe it is not cheap. However the performance of a cluster also depends on the quality of the network (and ultimately will have a single ip).

You could explore other alternatives (local or remote caching former CloudFront in AWS) or just upload the application on the local network and point to the remote bank.

Also take a look at this answer: #

I hope I have helped in some way.

abs,

    
08.03.2017 / 01:10