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:shardingsphere="http://shardingsphere.apache.org/schema/shardingsphere/datasource"
  4.        xmlns:readwrite-splitting="http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting"
  5.        xmlns:encrypt="http://shardingsphere.apache.org/schema/shardingsphere/encrypt"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans 
  7.                            http://www.springframework.org/schema/beans/spring-beans.xsd 
  8.                            http://shardingsphere.apache.org/schema/shardingsphere/datasource
  9.                            http://shardingsphere.apache.org/schema/shardingsphere/datasource/datasource.xsd
  10.                            http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting
  11.                            http://shardingsphere.apache.org/schema/shardingsphere/readwrite-splitting/readwrite-splitting.xsd
  12.                            http://shardingsphere.apache.org/schema/shardingsphere/encrypt
  13.                            http://shardingsphere.apache.org/schema/shardingsphere/encrypt/encrypt.xsd
  14.                            ">
  15.     <bean id="write_ds0" class="  com.zaxxer.hikari.HikariDataSource" init-method="init" destroy-method="close">
  16.         <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  17.         <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/write_ds?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8" />
  18.         <property name="username" value="root" />
  19.         <property name="password" value="" />
  20.     </bean>
  22.     <bean id="read_ds0_0" class="  com.zaxxer.hikari.HikariDataSource" init-method="init" destroy-method="close">
  23.         <!-- ...Omit specific configuration. -->
  24.     </bean>
  26.     <bean id="read_ds0_1" class="  com.zaxxer.hikari.HikariDataSource" init-method="init" destroy-method="close">
  27.         <!-- ...Omit specific configuration. -->
  28.     </bean>
  30.     <bean id="write_ds1" class="  com.zaxxer.hikari.HikariDataSource" init-method="init" destroy-method="close">
  31.         <!-- ...Omit specific configuration. -->
  32.     </bean>
  34.     <bean id="read_ds1_0" class="  com.zaxxer.hikari.HikariDataSource" init-method="init" destroy-method="close">
  35.         <!-- ...Omit specific configuration. -->
  36.     </bean>
  38.     <bean id="read_ds1_1" class="  com.zaxxer.hikari.HikariDataSource" init-method="init" destroy-method="close">
  39.         <!-- ...Omit specific configuration. -->
  40.     </bean>
  42.     <!-- load balance algorithm configuration for readwrite-splitting -->
  43.     <readwrite-splitting:load-balance-algorithm id="randomStrategy" type="RANDOM" />
  45.     <!-- readwrite-splitting rule configuration -->
  46.     <readwrite-splitting:rule id="readWriteSplittingRule">
  47.         <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" />
  48.         <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" />
  49.     </readwrite-splitting:rule>
  51.     <!-- sharding strategy configuration -->
  52.     <sharding:standard-strategy id="databaseStrategy" sharding-column="user_id" algorithm-ref="inlineDatabaseStrategyAlgorithm" />
  53.     <sharding:standard-strategy id="orderTableStrategy" sharding-column="order_id" algorithm-ref="inlineOrderTableStrategyAlgorithm" />
  54.     <sharding:standard-strategy id="orderItemTableStrategy" sharding-column="order_item_id" algorithm-ref="inlineOrderItemTableStrategyAlgorithm" />
  56.     <sharding:sharding-algorithm id="inlineDatabaseStrategyAlgorithm" type="INLINE">
  57.         <props>
  58.             <!-- the expression enumeration is the logical data source name of the readwrite-splitting configuration -->
  59.             <prop key="algorithm-expression">ds_${user_id % 2}</prop>
  60.         </props>
  61.     </sharding:sharding-algorithm>
  62.     <sharding:sharding-algorithm id="inlineOrderTableStrategyAlgorithm" type="INLINE">
  63.         <props>
  64.             <prop key="algorithm-expression">t_order_${order_id % 2}</prop>
  65.         </props>
  66.     </sharding:sharding-algorithm>
  67.     <sharding:sharding-algorithm id="inlineOrderItemTableStrategyAlgorithm" type="INLINE">
  68.         <props>
  69.             <prop key="algorithm-expression">t_order_item_${order_item_id % 2}</prop>
  70.         </props>
  71.     </sharding:sharding-algorithm>
  73.     <!-- sharding rule configuration -->    
  74.     <sharding:rule id="shardingRule">
  75.         <sharding:table-rules>
  76.             <!-- the expression 'ds_${0..1}' enumeration is the logical data source name of the readwrite-splitting configuration  -->
  77.             <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"/>
  78.             <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"/>
  79.         </sharding:table-rules>
  80.         <sharding:binding-table-rules>
  81.             <sharding:binding-table-rule logic-tables="t_order, t_order_item"/>
  82.         </sharding:binding-table-rules>
  83.         <sharding:broadcast-table-rules>
  84.             <sharding:broadcast-table-rule table="t_address"/>
  85.         </sharding:broadcast-table-rules>
  86.     </sharding:rule>
  88.     <!-- data encrypt configuration -->
  89.     <encrypt:encrypt-algorithm id="name_encryptor" type="AES">
  90.         <props>
  91.             <prop key="aes-key-value">123456</prop>
  92.         </props>
  93.     </encrypt:encrypt-algorithm>
  94.     <encrypt:encrypt-algorithm id="pwd_encryptor" type="assistedTest" />
  96.     <encrypt:rule id="encryptRule">
  97.         <encrypt:table name="t_user">
  98.             <encrypt:column logic-column="user_name" cipher-column="user_name" plain-column="user_name_plain" encrypt-algorithm-ref="name_encryptor" />
  99.             <encrypt:column logic-column="pwd" cipher-column="pwd" assisted-query-column="assisted_query_pwd" encrypt-algorithm-ref="pwd_encryptor" />
  100.         </encrypt:table>
  101.     </encrypt:rule>
  103.     <!-- datasource configuration -->
  104.     <!-- the element data-source-names's value is all of the datasource name -->
  105.     <shardingsphere:data-source id="readQueryDataSource" data-source-names="write_ds0, read_ds0_0, read_ds0_1, write_ds1, read_ds1_0, read_ds1_1" 
  106.         rule-refs="readWriteSplittingRule, shardingRule, encryptRule" >
  107.         <props>
  108.             <prop key="sql-show">true</prop>
  109.         </props>
  110.     </shardingsphere:data-source>
  111. </beans>