We have a MySQL database that serves two sites. One local and one remote via VPN.
I would like to have a MySQL server on both sites:
1-MySQL clients would connect to the local site MySQL Server.
2-Both servers need to sync database changes between them in almost real time.
What would be the best solution?
Thanks for your help,