The image shows the schema-level routing in with ProxySQL.

This shows queries and DMLs from schema A, schema B, and schema C are automatically routed to instance 1, instance 2, and instance 3 respectively.