I know that having the MySQL 3306 port is unsafe even if you restrict the user access based on IP. But what if you really need remote access to your database ? Maybe two applications reading and updating data at the same time.
If we have two applications one on the same host as the database and another one remote what would be a viable and secure way of sharing the same data ? Should we host the database some other place ? Should we have two local databases for each application and keep them up-to-date ? What would you suggest ?