SpringBoot 配置数据库主从 shardingsphere

港控/mmm° 2022-09-09 09:29 29阅读 0赞

spring:
      shardingsphere:
        props.sql.show: true
        datasource:
          names: master,slave1
          master:
            type: com.zaxxer.hikari.HikariDataSource
            driver-class-name: com.mysql.jdbc.Driver
            jdbc-url: jdbc:mysql://192.168.1.101:3306/user?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowMultiQueries=true
            username: admin
            password: 123456
            minimum-idle: 10
            maximum-pool-size: 20
            idle-timeout: 300000
            max-lifetime: 900000
            connection-timeout: 30000
            connection-test-query: SELECT 1
          slave1:
            type: com.zaxxer.hikari.HikariDataSource
            driver-class-name: com.mysql.jdbc.Driver
            jdbc-url: jdbc:mysql://192.168.1.102:3306/user?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowMultiQueries=true
            username: admin
            password: 123456
            minimum-idle: 10
            maximum-pool-size: 20
            idle-timeout: 300000
            max-lifetime: 900000
            connection-timeout: 30000
            connection-test-query: SELECT 1
        masterslave:
          name: us
          load-balance-algorithm-type: ROUND_ROBIN
          master-data-source-name: master
          slave-data-source-names:
            - slave1
            - master
      jackson:
        serialization:
          indent_output: true
      main:
        allow-bean-definition-overriding: true

### 1、SQL是否打印显示 ###

props.sql.show: true

### 2、数据源名称 ###

names: master,slave1

### 3、负载均衡算法 ###

load-balance-algorithm-type: ROUND_ROBIN
    
    ROUND_ROBIN：轮询
    RANDOM：随机

### 4、主数据源名称 ###

master-data-source-name: master

### 5、从数据源名称 ###

slave-data-source-names:
        - slave1
        - master