ShardingSphere??????????????
??sharding
jdbc????????????????????????????????????????????????????????????????????????????????????
??????????
??sharding
jdbc??????????????????4.0.0-RC2??????4.0.1????????????4.0.1??????HintManage.setDatabaseShardingValue(xxx)??????????????????????????????xxx??????????????????????????????????HintShardingAlgorithm????????????????????(4.0.0-RC2)??????
4.0.1????????????
??????????????????????4.0.1????????????????(StandardRoutingEngine)??
1.????sql????????????logicTable(????????????????????????????????????)
2.????logicTable????????????????????????????????????
3. ????????????Hint????????????logTable??????HintManager.getDatabaseShardingValue(logicTable)????????????????????
4. ????????????
databaseShardingValue????????HintShardingAlgorithm????????????????????
??????????????????????????????????????????????????????????????????????????????
1.??datasource??????????????????????????????????????
TableRuleConfiguration tableRule2 = new TableRuleConfiguration("t_order");
tableRule1.setDatabaseShardingStrategyConfig(hintStrategy);
2.??????????????HintManage.addDatabaseShardingValue(logicTalbe,databaseShardingValue)??????????????????????HintManage.setDatabaseShardingValue(xxx)
4.0.0-RC2??????
??4.0.0-RC2??????????????????????????????????DatabaseHintRoutingEngine????????????????????????????????????????????logicTable??????????HintManage.setDatabaseShardingValue(xxx)????????
@Override public RoutingResult route() { //??????????????????logicTable????
Collection<Comparable<?>> shardingValues =
HintManager.getDatabaseShardingValues(); ... return result; }
4.0.1??????
1. ??????4.0.1????????DatabaseHintRoutingEngine??????HintManage.setDatabaseShardingValue(xxx)??????????
2. ??????????????????(??????????????????????????????????????)??????????????sql????????????????????????????????????????????????????4.0.0-RC2??????
3. ????4.x????????????????????????????????HintManage.setDatabaseShardingValue(xxx)????????????????????????????example??????????????????????????ds_1????????????????