前置知识
在学习本教程前,请确保您已经:
- 掌握 Sharding-JDBC 的基本使用
- 了解 Java 并发编程
- 熟悉 SQL 优化基础
性能优化
1. 分片策略优化
1.1 分片键选择
// 推荐:使用单一分片键
TableRuleConfiguration orderTableRuleConfig = new TableRuleConfiguration("t_order", "ds${0..1}.t_order${0..1}");
orderTableRuleConfig.setTableShardingStrategyConfig(
new StandardShardingStrategyConfiguration("order_id", new OrderShardingAlgorithm())
);
// 不推荐:使用多分片键,可能影响性能
TableRuleConfiguration orderTableRuleConfig = new TableRuleConfiguration("t_order", "ds${0..1}.t_order${0..1}");
orderTableRuleConfig.setTableShardingStrategyConfig(
new ComplexShardingStrategyConfiguration("order_id,user_id", new ComplexOrderShardingAlgorithm())
);
2025/9/17大约 4 分钟