Synchronize two MySQL banks

0

I'm developing a web application and would like to get the system up and running both online and offline. The idea is to maintain a local database that responds when the user is offline , but I do not know how to synchronize the data between the local and remote database when the connection is restored. >

I know how to see if the computer is internet or not, I just do not know how to update the data after it is with the internet.

    
asked by anonymous 29.09.2017 / 20:22

1 answer

0

You should work with MySql Replication, which consists of 1 master database where inclusions and multiple slave banks are read. This mechanism is interesting for load balance, data integrity and performance.

Tool overview.

link

Here are the directions for making the settings:

link

Do not forget to carefully read the links I've been through, paying attention to the version of your MySql

    
29.09.2017 / 21:01