databases.
Server(1) is main centralized large server with many clients, while server(2) is a small server located in a factory with clients on that factory only.
I want to send data changes (insert, update, delete,...) of database(2) to database(1) so that when user is not in the factory (and therefore switches to server(1)) he/she can see theirs data on server(2) from server(1) too.
I need this configuration, because its possible that server(2) losses the internet connection sometimes. So server(2) must be able to work locally with its clients in the factory also and send its data changes to main server(1) after having internet connection.
Which is the best solution for this scenario to sync data between two server databases?
Replication???
I would expose secured rest API on server_1 that allows data of server_2 to be pushed to it. I wouldn't use replication for that
Обсуждают сегодня