I am struggling with the following issue: I have two MySQL servers, configured with as Master-Slave, but they are not on the same internal network, so sometimes there is a noticeable delay, and reading from the slave after a write, can lead to inconsistency issues.
I was wondering if there is a way to make mysql read from the slave, and somehow fallback to the slave if there are no results on the slave or some other solution.
Not sure if that can be even done, neither if should be on the application layer or at mysql level.
The current setup is php5 with mysqlnd extension and by following the documentation (adding slave on the yaml http://symfony.com/doc/current/reference/configuration/doctrine.html) I managed to get the app to read from the slave and write on the master.