This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

can maxscal support router like this?

I have some server storage some records,like this server_id -> column value server1 -> s1 server2 -> s2 server3 -> s3 server4 -> s4

table table_name1 struce like column1,column2,sid a,1,s1 when I query select * from table_name1 where sid=s1, then route the query to server1 ... select * from table_name1 where sid=s2, then route the query to server2

Answer Answered by Markus Mäkelä in this comment.

MaxScale does not support column-based or key based sharding. I would recommend taking a look at Spider for a lower level sharding solution.

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.