shardingsphere-sharding-jdbc 3.0.0 分库分表

最新推荐文章于 2024-08-17 04:12:52 发布

beiwangnull

最新推荐文章于 2024-08-17 04:12:52 发布

阅读量2.9k

点赞数

分类专栏： spring 文章标签： sharding-jdbc 3.0.0 shardingsphere 分库分表

本文链接：https://blog.csdn.net/hncaoyuqi/article/details/83988170

版权

spring 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1、pom

<dependency>
    <groupId>io.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-namespace</artifactId>
    <version>3.0.0</version>
</dependency>

2、mybatis+hikariCP xml

<bean id="ds0" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
    <property name="poolName" value="tradeHikariCP"/>
    <property name="connectionTestQuery" value="SELECT 1"/>
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="jdbcUrl" value="jdbc:mysql://10.0.200.5:3306/ds0"/>
    <property name="username" value="root"/>
    <property name="password" value="root"/>
    <property name="dataSourceProperties">
        <props>
            <prop key="cachePrepStmts">true</prop>
            <prop key="prepStmtCacheSize">500</prop>
            <prop key="prepStmtCacheSqlLimit">2048</prop>
        </props>
    </property>
    <property name="idleTimeout" value="3000"/>
    <property name="maximumPoolSize" value="100"/>
    <property name="minimumIdle" value="20"/>
    <property name="maxLifetime" value="5000"/>
</bean>
<bean id="ds1" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
    <property name="poolName" value="tradeHikariCP"/>
    <property name="connectionTestQuery" value="SELECT 1"/>
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="jdbcUrl" value="jdbc:mysql://10.0.200.5:3306/ds1"/>
    <property name="username" value="root"/>
    <property name="password" value="root"/>
    <property name="dataSourceProperties">
        <props>
            <prop key="cachePrepStmts">true</prop>
            <prop key="prepStmtCacheSize">500</prop>
            <prop key="prepStmtCacheSqlLimit">2048</prop>
        </props>
    </property>
    <property name="idleTimeout" value="3000"/>
    <property name="maximumPoolSize" value="100"/>
    <property name="minimumIdle" value="20"/>
    <property name="maxLifetime" value="5000"/>
</bean>

<sharding:inline-strategy id="databaseStrategy" sharding-column="user_id" algorithm-expression="ds$->{user_id % 2}" />
<sharding:inline-strategy id="orderTableStrategy" sharding-column="order_id" algorithm-expression="t_order$->{order_id % 3}" />

<sharding:data-source id="shardingDataSource">
    <sharding:sharding-rule data-source-names="ds0,ds1">
        <sharding:table-rules>
            <sharding:table-rule logic-table="t_order" actual-data-nodes="ds$->{0..1}.t_order$->{0..2}" database-strategy-ref="databaseStrategy" table-strategy-ref="orderTableStrategy" />
        </sharding:table-rules>
    </sharding:sharding-rule>
</sharding:data-source>

<bean id="sqlSessionFactory" name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="shardingDataSource"/>
    <property name="typeAliasesPackage" value="com.haha.springmvc.data"/>
    <property name="mapperLocations" value="classpath:mappers/*.xml"/>
    <property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.haha.springmvc.repository"/>
    <property name="annotationClass" value="org.springframework.stereotype.Repository"/>
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>