I have maxscale 2.1.3 and 3 percona56 servers with master/slave replica. When i connect to my maxscale and make a sql select request - i see strange behavior from my maxscale.
For example, if i make
maxscale ALWAYS return 13 - this is id of my percona slave server - that's ok, all correct.
BUT if i make any request with
i ALWAYS get 12 - this is my master ID.
In other words, SQL REGEXP in my any requests affecting routes between slaves and master. Why this happens? How to avoid this?