the company i work for asked me to find a way to make their web application accessible even if there is no internet connection in the office, since this application is for customers all over the country, they can generate their own invoices automatically. via the web application, and on the other side; employees should automatically generate the necessary documents in the admin part of the web application for each client.
My question is how can I synchronize the database of my remote server (at digitalocean) with an existing local database in the office computer, so that the staff do not have to stop working in case disconnection from the Internet, and that the local office database is up to date with the remote database when the Internet returns, the goal is therefore to always synchronize the 2 databases automatically without any error.knowing that all the computers in my office are set up with Windows and not ubuntu.
During my research I found the “MySQL Master-Master Replication” method which offers the possibility of having 2 synchronous databases in both directions, it seemed to me that this was the solution I was looking for, but my problem is that each tutorial shows how to configure between 2 ubuntu environments, and in my case I have ubuntu 20.04 that for Digital ocean server, and the other database I want to store it in my desktop which is using Windows, so should i install ubuntu on my computer using a virtual machine or am i supposed to buy a special server for my office? or a simple development environment like laragon would do? (I am already used to laragon having developed my laravel application with) knoing that my web application is going to deal with a lot of data