Comments - MaxScale Hint Syntax
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.
We tried instead to use readconnroute instead of readwritesplit service. But here hint seems to not work at all? Even hint select statement to different slaves is not working?
The readconnroute will only use one server for the duration of the client session. It ignores hints in queries as it can only route to a single server.
Thanks for the feedback. I will suggest that you change the first example in this document since it use the readconnroute service.