Does maxscale allow to route to a service based on the database user connnecting?
Many of our applications have a specific database user assigned to it. Is there a way to filter out by user and send them to different routers. Like the schema router that diverts all queries to a schema we would like to divert all queries from db user login.
We would like to have one main listener on 3306 where all db traffic is coming in. Based on the database login we would then send them to various other services defined that may limit them to certain servers or read/write splitting or schema routing.
Answer Answered by Markus Mäkelä in this comment.
This is not currently easily doable but this could be a feature that we add for the upcoming 2.5 release of MaxScale. Please open a feature request on the MariaDB Jira and describe the functionality that you'd like to see in MaxScale.
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.
