shardingsphere-sharding-jdbc 3.0.0 MYSQL主从配置

最新推荐文章于 2025-09-08 20:57:28 发布

原创最新推荐文章于 2025-09-08 20:57:28 发布 · 1.7k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mysql 主从配置 #sharding-jdbc 3.0.0

java 同时被 2 个专栏收录

27 篇文章

订阅专栏

mysql

11 篇文章

订阅专栏

本文详细介绍了如何在Spring环境中配置Sharding-JDBC进行数据库读写分离，并结合MyBatis实现数据访问层的整合。通过示例展示了pom依赖引入、HikariCP数据源配置、Master-Slave数据源定义以及MyBatis的整合过程。

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="ds_master" 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/localtest"/>
    <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="ds_slave0" 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/localtest"/>
    <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>

<master-slave:data-source id="shardingDataSource" master-data-source-name="ds_master" slave-data-source-names="ds_slave0" >
    <master-slave:props>
        <prop key="sql.show">true</prop>
        <prop key="executor.size">10</prop>
        <prop key="foo">bar</prop>
    </master-slave:props>
</master-slave: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>