Can MaxScale filter based on database name?
You are viewing an old version of this question. View
the current version here.
Dear MariaDB team,
let's say we have 3 different mysql clusters and some databases are on cluster 1, others are on cluster 2 and so on. Example
cluster1: db_a, db_b cluster2: db_c, db_d, db_e cluster3: db_f
Can MaxScale filter and route based on database name? For example if connection is being established to db_c the MaxScale would connect it to cluster2. Another connection to db_f would connet it to cluster3 and so on...
Is it possible to do that?
Answer
Take a look at the schemarouter module, it should allow you to automatically work with a sharded set of databases: https://mariadb.com/kb/en/mariadb-maxscale-24-schemarouter/
Comments
Comments loading...
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.
