Comments - How to use Maxscale for maximum reliability?

7 years, 7 months ago Markus Mäkelä

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.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.