Mixed Rules

Configuration Item Explanation

  1. <beans xmlns="http://www.springframework.org/schema/beans"
  2.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.        xmlns:context="http://www.springframework.org/schema/context"
  4.        xmlns:tx="http://www.springframework.org/schema/tx"
  5.        xmlns:shardingsphere="http://shardingsphere.apache.org/schema/shardingsphere/datasource"
  6.        xmlns:readwrite-splitting="http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting"
  7.        xmlns:encrypt="http://shardingsphere.apache.org/schema/shardingsphere/encrypt"
  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.apache.org/schema/shardingsphere/datasource
  15.                            http://shardingsphere.apache.org/schema/shardingsphere/datasource/datasource.xsd
  16.                            http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting
  17.                            http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting/readwrite-splitting.xsd
  18.                            http://shardingsphere.apache.org/schema/shardingsphere/encrypt
  19.                            http://shardingsphere.apache.org/schema/shardingsphere/encrypt/encrypt.xsd
  20.                            ">
  21.     <bean id="write_ds0" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
  22.         <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  23.         <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/write_ds?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8" />
  24.         <property name="username" value="root" />
  25.         <property name="password" value="" />
  26.     </bean>
  28.     <bean id="read_ds0_0" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
  29.         <!-- ...Omit specific configuration. -->
  30.     </bean>
  32.     <bean id="read_ds0_1" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
  33.         <!-- ...Omit specific configuration. -->
  34.     </bean>
  36.     <bean id="write_ds1" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
  37.         <!-- ...Omit specific configuration. -->
  38.     </bean>
  40.     <bean id="read_ds1_0" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
  41.         <!-- ...Omit specific configuration. -->
  42.     </bean>
  44.     <bean id="read_ds1_1" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
  45.         <!-- ...Omit specific configuration. -->
  46.     </bean>
  48.     <!-- load balance algorithm configuration for readwrite-splitting -->
  49.     <readwrite-splitting:load-balance-algorithm id="randomStrategy" type="RANDOM" />
  51.     <!-- readwrite-splitting rule configuration -->
  52.     <readwrite-splitting:rule id="readWriteSplittingRule">
  53.         <readwrite-splitting:data-source-rule id="ds_0" write-data-source-name="write_ds0" read-data-source-names="read_ds0_0, read_ds0_1" load-balance-algorithm-ref="randomStrategy" />
  54.         <readwrite-splitting:data-source-rule id="ds_1" write-data-source-name="write_ds1" read-data-source-names="read_ds1_0, read_ds1_1" load-balance-algorithm-ref="randomStrategy" />
  55.     </readwrite-splitting:rule>
  57.     <!-- sharding strategy configuration -->
  58.     <sharding:standard-strategy id="databaseStrategy" sharding-column="user_id" algorithm-ref="inlineDatabaseStrategyAlgorithm" />
  59.     <sharding:standard-strategy id="orderTableStrategy" sharding-column="order_id" algorithm-ref="inlineOrderTableStrategyAlgorithm" />
  60.     <sharding:standard-strategy id="orderItemTableStrategy" sharding-column="order_item_id" algorithm-ref="inlineOrderItemTableStrategyAlgorithm" />
  62.     <sharding:sharding-algorithm id="inlineDatabaseStrategyAlgorithm" type="INLINE">
  63.         <props>
  64.             <!-- the expression enumeration is the logical data source name of the readwrite-splitting configuration -->
  65.             <prop key="algorithm-expression">ds_${user_id % 2}</prop>
  66.         </props>
  67.     </sharding:sharding-algorithm>
  68.     <sharding:sharding-algorithm id="inlineOrderTableStrategyAlgorithm" type="INLINE">
  69.         <props>
  70.             <prop key="algorithm-expression">t_order_${order_id % 2}</prop>
  71.         </props>
  72.     </sharding:sharding-algorithm>
  73.     <sharding:sharding-algorithm id="inlineOrderItemTableStrategyAlgorithm" type="INLINE">
  74.         <props>
  75.             <prop key="algorithm-expression">t_order_item_${order_item_id % 2}</prop>
  76.         </props>
  77.     </sharding:sharding-algorithm>
  79.     <!-- sharding rule configuration -->    
  80.     <sharding:rule id="shardingRule">
  81.         <sharding:table-rules>
  82.             <!-- the expression 'ds_${0..1}' enumeration is the logical data source name of the readwrite-splitting configuration  -->
  83.             <sharding:table-rule logic-table="t_order" actual-data-nodes="ds_${0..1}.t_order_${0..1}" database-strategy-ref="databaseStrategy" table-strategy-ref="orderTableStrategy" key-generate-strategy-ref="orderKeyGenerator"/>
  84.             <sharding:table-rule logic-table="t_order_item" actual-data-nodes="ds_${0..1}.t_order_item_${0..1}" database-strategy-ref="databaseStrategy" table-strategy-ref="orderItemTableStrategy" key-generate-strategy-ref="itemKeyGenerator"/>
  85.         </sharding:table-rules>
  86.         <sharding:binding-table-rules>
  87.             <sharding:binding-table-rule logic-tables="t_order, t_order_item"/>
  88.         </sharding:binding-table-rules>
  89.         <sharding:broadcast-table-rules>
  90.             <sharding:broadcast-table-rule table="t_address"/>
  91.         </sharding:broadcast-table-rules>
  92.     </sharding:rule>
  94.     <!-- data encrypt configuration -->
  95.     <encrypt:encrypt-algorithm id="name_encryptor" type="AES">
  96.         <props>
  97.             <prop key="aes-key-value">123456</prop>
  98.         </props>
  99.     </encrypt:encrypt-algorithm>
  100.     <encrypt:encrypt-algorithm id="pwd_encryptor" type="assistedTest" />
  102.     <encrypt:rule id="encryptRule">
  103.         <encrypt:table name="t_user">
  104.             <encrypt:column logic-column="user_name" cipher-column="user_name" plain-column="user_name_plain" encrypt-algorithm-ref="name_encryptor" />
  105.             <encrypt:column logic-column="pwd" cipher-column="pwd" assisted-query-column="assisted_query_pwd" encrypt-algorithm-ref="pwd_encryptor" />
  106.         </encrypt:table>
  107.     </encrypt:rule>
  109.     <!-- datasource configuration -->
  110.     <!-- the element data-source-names's value is all of the datasource name -->
  111.     <shardingsphere:data-source id="readQueryDataSource" data-source-names="write_ds0, read_ds0_0, read_ds0_1, write_ds1, read_ds1_0, read_ds1_1" 
  112.         rule-refs="readWriteSplittingRule, shardingRule, encryptRule" >
  113.         <props>
  114.             <prop key="sql-show">true</prop>
  115.         </props>
  116.     </shardingsphere:data-source>
  117. </beans>