Sharding-jdbc现在是Apache基金会顶级项目ShardingSphere下的一个产品，是以jdbc的形式支持读写分离、分库分表等类似数据库中间件功能，优点是入侵性小、配置方便，而且背后有个好爹。
Sharding-jdbc支持读写分离和分库分表两个核心功能，并且可以在读写分离基础上叠加分库分表。
Maven坐标
Maven中央仓库中，有两个artifactId为sharding-jdbc的包，一个groupId是io.shardingjdbc，一个是org.apache.shardingsphere，注意不要选错了，apache的发布版本都是4.0.0之后的，之前的是老版本应该也不会继续更新了。
1
2
3
4
5
6
|
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.0.0-RC1</version>
</dependency>
|
读写分离
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
spring.shardingsphere.datasource.names=master,slave0
spring.shardingsphere.datasource.master.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.master.driver-class-name=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
spring.shardingsphere.datasource.master.url=jdbc:log4jdbc:mysql://ip:port/db?useUnicode=true&characterEncoding=utf-8
spring.shardingsphere.datasource.master.username=root
spring.shardingsphere.datasource.master.password=123
spring.shardingsphere.datasource.master.max-active=10
spring.shardingsphere.datasource.master.druid.filters=stat,wall,config
spring.shardingsphere.datasource.slave0.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.slave0.driver-class-name=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
spring.shardingsphere.datasource.slave0.url=jdbc:log4jdbc:mysql://ip:port/db?useUnicode=true&characterEncoding=utf-8
spring.shardingsphere.datasource.slave0.username=root
spring.shardingsphere.datasource.slave0.password=123
spring.shardingsphere.datasource.slave0.max-active=10
spring.shardingsphere.datasource.slave0.druid.filters=stat,wall,config
spring.shardingsphere.masterslave.load-balance-algorithm-type=round_robin
spring.shardingsphere.masterslave.name=ms
spring.shardingsphere.masterslave.master-data-source-name=master
spring.shardingsphere.masterslave.slave-data-source-names=slave0
spring.shardingsphere.props.sql.show=true
|
忽略druid的配置，使用读写分离的这版，druid的sql监控功能一直打不开。
