How to use Maxscale for maximum reliability?
This is the main Knowledge Base category for MariaDB.
Follow any of the links below to find information on the topics you are interested in. If you would like to know more about anything that isn't documented, ask a question at the place where the answers should be and we will do our best to provide an answer for it!
Answer
You can try to do the SELECT statements inside a transaction if you need to have consistent reads. Another option is to tag the SELECT statements with routing hints that send them to the master server.
There's also the slavelagfilter, which routes SELECTS after data modification to the master. It isn't currently included in the package but you can build it yourself by adding -DBUILD_SLAVELAG=Y
when configuring the build.