Hi, I am trying to apply sharding on all tables on the same key column exists on all tables. The objective is evenly distribute the records on several database instances. For example, even no. records on one server. After trying around several hours, seems it's not possible to define database sharding strategy bases on table column without table name nor by using wildcard table name in yaml. I need it because the tables are dynamically generated which I don't know the table names in advance. Please give me some hints if someone knows hot to define global database sharding strategy on all tables by using a key column?
Besides, I tried that the engine will randomly route the query to the datasources if no sharding rule defined in yaml. Is it possible to broadcast the query to all datasources if no sharding rule find? I can't use broadcastTables for the same reason which tables are dynamically generated. Very appreciate for your help. Regards, Eric Poon
