shardingjdbc读写分离,分表不分库。
设置1个主表。一个从表。
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driver}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </bean> <bean id="read_dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.read.driver}"/> <property name="url" value="${jdbc.read.url}"/> <property name="username" value="${jdbc.read.username}"/> <property name="password" value="${jdbc.read.password}"/>
</bean>
<!-- 定义读写分离数据源, 读写分离数据源实现了DataSource接口, 可直接当做数据源处理 --> <masterslave:data-source id="dataSource_0" master-data-source-name="dataSource" slave-data-source-names="read_dataSource" strategy-type="ROUND_ROBIN"/> <!--分表策略,sharding-column这里根据order_id(这列属性不能是String,只能是整型)分表,OrderSingleKeyTableShardingAlgorithm是分表算法--> <sharding:standard-strategy id="tableShardingStrategy" sharding-column="order_id" precise-algorithm-class="com.os.buqu.algorithm.OrderSingleKeyTableShardingAlgorithm"/> <sharding:data-source id="shardingDataSource"> <!--因为我只有一张表。所以就只需要配置一个dataSource--> <sharding:sharding-rule data-source-names="dataSource_0" default-data-source-name="dataSource_0"> <sharding:table-rules> <!--logic-tables逻辑表名--> <!--actual-data-nodes真实表名--> <sharding:table-rule logic-table="demo_order" actual-data-nodes="dataSource_0.demo_order_0,dataSource_0.demo_order_1" table-strategy-ref="tableShardingStrategy"/> </sharding:table-rules> <sharding:binding-table-rules> <!--logic-tables逻辑表名--> <sharding:binding-table-rule logic-tables="demo_order"/> </sharding:binding-table-rules> </sharding:sharding-rule> </sharding:data-source>