变更历史

5.0.0-alpha

读写分离

配置项说明

命名空间：http://shardingsphere.apache.org/schema/shardingsphere/replica-query/replica-query-5.0.0.xsd

<replica-query:rule />

名称类型说明
id属性Spring Bean Id
data-source-rule (+)标签读写分离数据源规则配置

<replica-query:data-source-rule />

名称类型说明
id属性读写分离数据源规则名称
primary-data-source-name属性主数据源名称
replica-data-source-names属性从数据源名称，多个从数据源用逗号分隔
load-balance-algorithm-ref属性负载均衡算法名称

<replica-query:load-balance-algorithm />

名称类型说明
id属性负载均衡算法名称
type属性负载均衡算法类型
props (?)标签负载均衡算法属性配置

算法类型的详情，请参见内置负载均衡算法列表。

4.x

读写分离

配置项说明

命名空间：http://shardingsphere.apache.org/schema/shardingsphere/masterslave/master-slave.xsd

<master-slave:data-source />

名称类型说明
id属性Spring Bean Id
master-data-source-name属性主库数据源Bean Id
slave-data-source-names属性从库数据源Bean Id列表，多个Bean以逗号分隔
strategy-ref (?)属性从库负载均衡算法引用。该类需实现MasterSlaveLoadBalanceAlgorithm接口
strategy-type (?)属性从库负载均衡算法类型，可选值：ROUND_ROBIN，RANDOM。若strategy-ref存在则忽略该配置
props (?)标签属性配置

<master-slave:props />

名称类型说明
sql.show (?)属性是否开启SQL显示，默认值: false
executor.size (?)属性工作线程数量，默认值: CPU核数
max.connections.size.per.query (?)属性每个物理数据库为每次查询分配的最大连接数量。默认值: 1
check.table.metadata.enabled (?)属性是否在启动时检查分表元数据一致性，默认值: false

<master-slave:load-balance-algorithm />

4.0.0-RC2 版本 添加

名称类型说明
id属性Spring Bean Id
type属性负载均衡算法类型，‘RANDOM’或’ROUND_ROBIN’，支持自定义拓展
props-ref (?)属性负载均衡算法配置参数

3.x

读写分离

配置项说明

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:p="http://www.springframework.org/schema/p"
  6.        xmlns:tx="http://www.springframework.org/schema/tx"
  7.        xmlns:master-slave="http://shardingsphere.io/schema/shardingsphere/masterslave"
  8.        xsi:schemaLocation="http://www.springframework.org/schema/beans 
  9.                         http://www.springframework.org/schema/beans/spring-beans.xsd 
  10.                         http://www.springframework.org/schema/context 
  11.                         http://www.springframework.org/schema/context/spring-context.xsd
  12.                         http://www.springframework.org/schema/tx 
  13.                         http://www.springframework.org/schema/tx/spring-tx.xsd
  14.                         http://shardingsphere.io/schema/shardingsphere/masterslave  
  15.                         http://shardingsphere.io/schema/shardingsphere/masterslave/master-slave.xsd">
  16.     <context:annotation-config />
  17.     <context:component-scan base-package="io.shardingsphere.example.spring.namespace.jpa" />
  19.     <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
  20.         <property name="dataSource" ref="masterSlaveDataSource" />
  21.         <property name="jpaVendorAdapter">
  22.             <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" p:database="MYSQL" />
  23.         </property>
  24.         <property name="packagesToScan" value="io.shardingsphere.example.spring.namespace.jpa.entity" />
  25.         <property name="jpaProperties">
  26.             <props>
  27.                 <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
  28.                 <prop key="hibernate.hbm2ddl.auto">create</prop>
  29.                 <prop key="hibernate.show_sql">true</prop>
  30.             </props>
  31.         </property>
  32.     </bean>
  33.     <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager" p:entityManagerFactory-ref="entityManagerFactory" />
  34.     <tx:annotation-driven />
  36.     <bean id="ds_master" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  37.         <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  38.         <property name="url" value="jdbc:mysql://localhost:3306/ds_master" />
  39.         <property name="username" value="root" />
  40.         <property name="password" value="" />
  41.     </bean>
  43.     <bean id="ds_slave0" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  44.         <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  45.         <property name="url" value="jdbc:mysql://localhost:3306/ds_slave0" />
  46.         <property name="username" value="root" />
  47.         <property name="password" value="" />
  48.     </bean>
  50.     <bean id="ds_slave1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  51.         <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  52.         <property name="url" value="jdbc:mysql://localhost:3306/ds_slave1" />
  53.         <property name="username" value="root" />
  54.         <property name="password" value="" />
  55.     </bean>
  57.     <bean id="randomStrategy" class="io.shardingsphere.api.algorithm.masterslave.RandomMasterSlaveLoadBalanceAlgorithm" />
  58.     <master-slave:data-source id="masterSlaveDataSource" master-data-source-name="ds_master" slave-data-source-names="ds_slave0, ds_slave1" strategy-ref="randomStrategy">
  59.             <master-slave:props>
  60.                 <prop key="sql.show">${sql_show}</prop>
  61.                 <prop key="executor.size">10</prop>
  62.                 <prop key="foo">bar</prop>
  63.             </master-slave:props>
  64.     </master-slave:data-source>
  65. </beans>

2.x

读写分离

Spring命名空间配置示例

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  4.     xmlns:context="http://www.springframework.org/schema/context"
  5.     xmlns:sharding="http://shardingsphere.io/schema/shardingjdbc/sharding"
  6.     xmlns:masterslave="http://shardingsphere.io/schema/shardingjdbc/masterslave"
  7.     xsi:schemaLocation="http://www.springframework.org/schema/beans 
  8.                         http://www.springframework.org/schema/beans/spring-beans.xsd
  9.                         http://www.springframework.org/schema/context 
  10.                         http://www.springframework.org/schema/context/spring-context.xsd 
  11.                         http://shardingsphere.io/schema/shardingjdbc/sharding
  12.                         http://shardingsphere.io/schema/shardingjdbc/sharding/sharding.xsd
  13.                         http://shardingsphere.io/schema/shardingjdbc/masterslave
  14.                         http://shardingsphere.io/schema/shardingjdbc/masterslave/master-slave.xsd
  15.                         ">
  16.     <!-- 配置真实数据源 -->
  17.     <bean id="dbtbl_0_master" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  18.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  19.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_0_master"/>
  20.         <property name="username" value="root"/>
  21.         <property name="password" value=""/>
  22.     </bean>
  24.     <bean id="dbtbl_0_slave_0" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  25.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  26.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_0_slave_0"/>
  27.         <property name="username" value="root"/>
  28.         <property name="password" value=""/>
  29.     </bean>
  31.     <bean id="dbtbl_0_slave_1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  32.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  33.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_0_slave_1"/>
  34.         <property name="username" value="root"/>
  35.         <property name="password" value=""/>
  36.     </bean>
  38.     <bean id="dbtbl_1_master" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  39.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  40.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_1_master"/>
  41.         <property name="username" value="root"/>
  42.         <property name="password" value=""/>
  43.     </bean>
  45.     <bean id="dbtbl_1_slave_0" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  46.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  47.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_1_slave_0"/>
  48.         <property name="username" value="root"/>
  49.         <property name="password" value=""/>
  50.     </bean>
  52.     <bean id="dbtbl_1_slave_1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  53.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  54.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_1_slave_1"/>
  55.         <property name="username" value="root"/>
  56.         <property name="password" value=""/>
  57.     </bean>
  59.     <!-- 定义读写分离数据源, 读写分离数据源实现了DataSource接口, 可直接当做数据源处理 -->
  60.     <master-slave:data-source id="dbtbl_0" master-data-source-name="dbtbl_0_master" slave-data-source-names="dbtbl_0_slave_0, dbtbl_0_slave_1" strategy-type="ROUND_ROBIN" />
  61.     <master-slave:data-source id="dbtbl_1" master-data-source-name="dbtbl_1_master" slave-data-source-names="dbtbl_1_slave_0, dbtbl_1_slave_1" strategy-type="ROUND_ROBIN" />
  63.     <sharding:inline-strategy id="databaseStrategy" sharding-column="user_id" algorithm-expression="dbtbl_${user_id % 2}" />
  64.     <sharding:inline-strategy id="orderTableStrategy" sharding-column="order_id" algorithm-expression="t_order_${order_id % 4}" />
  66.     <sharding:data-source id="shardingDataSource">
  67.         <sharding:sharding-rule data-source-names="dbtbl_0, dbtbl_1">
  68.             <sharding:table-rules>
  69.                 <sharding:table-rule logic-table="t_order" actual-data-nodes="dbtbl_${0..1}.t_order_${0..3}" database-strategy-ref="databaseStrategy" table-strategy-ref="orderTableStrategy"/>
  70.             </sharding:table-rules>
  71.         </sharding:sharding-rule>
  72.     </sharding:data-source>
  73. </beans>

1.x

读写分离

Spring命名空间配置示例

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  4.     xmlns:context="http://www.springframework.org/schema/context"
  5.     xmlns:rdb="http://www.dangdang.com/schema/ddframe/rdb" 
  6.     xsi:schemaLocation="http://www.springframework.org/schema/beans 
  7.                         http://www.springframework.org/schema/beans/spring-beans.xsd
  8.                         http://www.springframework.org/schema/context 
  9.                         http://www.springframework.org/schema/context/spring-context.xsd 
  10.                         http://www.dangdang.com/schema/ddframe/rdb 
  11.                         http://www.dangdang.com/schema/ddframe/rdb/rdb.xsd 
  12.                         ">
  13.     <!-- 配置真实数据源 -->
  14.     <bean id="dbtbl_0_master" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  15.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  16.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_0_master"/>
  17.         <property name="username" value="root"/>
  18.         <property name="password" value=""/>
  19.     </bean>
  21.     <bean id="dbtbl_0_slave_0" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  22.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  23.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_0_slave_0"/>
  24.         <property name="username" value="root"/>
  25.         <property name="password" value=""/>
  26.     </bean>
  28.     <bean id="dbtbl_0_slave_1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  29.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  30.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_0_slave_1"/>
  31.         <property name="username" value="root"/>
  32.         <property name="password" value=""/>
  33.     </bean>
  35.     <bean id="dbtbl_1_master" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  36.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  37.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_1_master"/>
  38.         <property name="username" value="root"/>
  39.         <property name="password" value=""/>
  40.     </bean>
  42.     <bean id="dbtbl_1_slave_0" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  43.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  44.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_1_slave_0"/>
  45.         <property name="username" value="root"/>
  46.         <property name="password" value=""/>
  47.     </bean>
  49.     <bean id="dbtbl_1_slave_1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  50.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  51.         <property name="url" value="jdbc:mysql://localhost:3306/dbtbl_1_slave_1"/>
  52.         <property name="username" value="root"/>
  53.         <property name="password" value=""/>
  54.     </bean>
  56.     <!-- 定义读写分离数据源, 读写分离数据源实现了DataSource接口, 可直接当做数据源处理 -->
  57.     <rdb:master-slave-data-source id="dbtbl_0" master-data-source-ref="dbtbl_0_master" slave-data-sources-ref="dbtbl_0_slave_0, dbtbl_0_slave_1" strategy-type="ROUND_ROBIN" />
  58.     <rdb:master-slave-data-source id="dbtbl_1" master-data-source-ref="dbtbl_1_master" slave-data-sources-ref="dbtbl_1_slave_0, dbtbl_1_slave_1" strategy-type="ROUND_ROBIN" />
  60.     <!-- 通过rdb:strategy和rdb:data-source继续构建分片数据源 -->
  61.     <rdb:strategy id="databaseStrategy" sharding-columns="user_id" algorithm-expression="dbtbl_${user_id.longValue() % 2}"/>
  62.     <rdb:strategy id="orderTableStrategy" sharding-columns="order_id" algorithm-expression="t_order_${order_id.longValue() % 4}"/>
  64.     <rdb:data-source id="shardingDataSource">
  65.         <rdb:sharding-rule data-sources="dbtbl_0, dbtbl_1">
  66.             <rdb:table-rules>
  67.                 <rdb:table-rule logic-table="t_order" actual-tables="t_order_${0..3}" database-strategy="databaseStrategy" table-strategy="orderTableStrategy"/>
  68.             </rdb:table-rules>
  69.         </rdb:sharding-rule>
  70.     </rdb:data-source>
  71. </beans>