I've made a very simple testing filter on the MXS-193-test branch on GitHub. It reads rules from a file and adds a routing hint to the query if its canonized form is found in the rule file. The destination of the query can be controlled via the rule file and the rules follow this simple syntax: <canonical query>|<server name>

This module needs the readwritesplit router to work.

Here is a small example of a rule file:

update tst set fname="?" where fname like '?'|server1

select @@version_comment limit ?|server2

select  md5("?") =?|server4

select * from tst where lname like '?' order by fname|server3

insert into tst values ("?",'?')|server1

delete from tst where fname like '?'|server2

Current testing implementation does not break replication which means that data modifying statements will always be routed to the master. This can be changed by adding a configuration parameter to readwritesplit.

The real implementation could be configurable via maxadmin.

Namedserverfilter and hintrouter will in 2.2 provide roughly this functionality.