I am completing an accounting system that will work in a LAN environment.
To it, I want to add possibilities where key information (key tables) are synchronized in real-time with the remote database.
I will then have mobile dashboard application querying key information from the remote database, to ensure information mobility.
I am using MySQL as DBMS.
Any idea on how this can be achieved is welcome, or any software that can ensure this real-time synchronization will help too.