There are tow different sharding strategies for databases and tables which you can config. FIY: https://github.com/apache/incubator-shardingsphere-example/blob/dev/sharding-jdbc-example/sharding-example/sharding-raw-jdbc-example/src/main/resources/META-INF/sharding-databases-tables-range.yaml for Sharding-JDBC, but Sharding-Proxy is similar.
We will add using sharding with databases and tables together's document later. ------------------ Liang Zhang (John) Apache ShardingSphere & Dubbo Eric <[email protected]> 于2019年5月25日周六 上午5:58写道： > Hi, > > I read the documents that the sharding-proxy example uses user_id in the > defaultDatabaseStrategy to decide which database the query routed to. If I > want to separate the data horizontally for all tables which each table may > have their own keys, how to configure the yaml file? > > For example I have database 0 and database 1 with all the tables identical. > I want the data separated in half bases on the tables' primary keys like > the one below. How to write the sharding rules in the yaml file? > > database0.employee > Primary Key: emp_id > Sharding Rule: emp_id % 2 = 0 > > database0.computers > Primary Key: serial_no > Sharding Rule: serial_no % 2 = 0 > > database1.employee > Primary Key: emp_id > Sharding Rule: emp_id % 2 = 1 > > database1.computers > Primary key: serial_no > Sharding Rule: serial_no % 2 =1 > > Regards, > Eric >
