[MXS-1849] Table Family Sharding Router Created: 2018-05-03  Updated: 2018-07-09  Resolved: 2018-07-09

Status: Closed
Project: MariaDB MaxScale
Component/s: schemarouter
Affects Version/s: None
Fix Version/s: 2.3.0

Type: New Feature Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: Marko Rajala (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-60, MXS-SPRINT-61

 Description   

Feature request:
MaxScale should be able to route a query coming from an application to appropriate server based on table name of in the query.



 Comments   
Comment by markus makela [ 2018-05-16 ]

This can be done by expanding the functionality of the schemarouter. By performing a query similar to the following, all databases and tables on a server can be mapped.

SELECT table_schema, table_name FROM information_schema.tables WHERE table_schema NOT IN ('information_schema', 'performance_schema', 'mysql');

Generated at Thu Feb 08 04:09:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.