|hi there, I would like to ask for help or suggestion on the scenario below:|
I have 2 pc that connected to one server,the pcs are running the same program to transfer the data to the server, if the connection of one of the pc is down then it'll automatically switch to offline mode so when the connection is up again then the 'lost' data will automatically restore back to the server. suppose the 2 pcs data need to be same in the server but now they are crashed. so i'm thinking about whether a master-slave type is more suitable solution? But what if the master server is down then the both pc also can't work with the database. so is there any other solution? thanks.