springboot2.0+sharding-jdbc配置读写分离

最新推荐文章于 2024-07-02 09:30:00 发布

weixin_44260686

最新推荐文章于 2024-07-02 09:30:00 发布

阅读量268

点赞数

分类专栏：学习历程文章标签： java spring

本文链接：https://blog.csdn.net/weixin_44260686/article/details/106257457

版权

学习历程专栏收录该内容

6 篇文章 0 订阅

订阅专栏

1.pom引入

<dependency>
    <groupId>io.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
    <version>3.1.0.M1</version>
</dependency>

2.application.yml

server:
  port: 8082
spring:

  jpa:
    database: MySQL
    show-sql: true
    properties:
      hibernate:
        format_sql: true
    hibernate:
      naming:
        implicit-strategy: org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy
        # 将下划线改为驼峰
        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl


# springboot 2.0读写分离
sharding:
  jdbc:
    dataSource:
      names: master,slave0
      master:
        type: com.alibaba.druid.pool.DruidDataSource
        # driverClassName: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://172.16.56.117:3306/表名?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&createDatabaseIfNotExist=true&serverTimezone=GMT%2B8&useSSL=false
        username: root
        password: 密码
      slave0:
        type: com.alibaba.druid.pool.DruidDataSource
        # driverClassName: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://172.16.56.118:3306/表名?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&createDatabaseIfNotExist=true&serverTimezone=GMT%2B8&useSSL=false
        username: root
        password: 密码
    config:
      masterslave:
        name: ms
        master-data-source-name: master
        slave-data-source-names: slave0
    props:
      sql:
        show: true