MyBatis-Plus实现多数据源的示例代码

<dependency>

   <groupid>com.baomidou</groupid>

   <artifactid>dynamic-datasource-spring-boot-starter</artifactid>

   <version> 2.5 . 4 </version>

</dependency>

spring:

  datasource:

   dynamic:

    primary: db1 #设置默认的数据源,默认值为master

    datasource:

     db1: #数据源db1

      driver- class -name: com.mysql.jdbc.driver

      url: jdbc:mysql: //127.0.0.1:3306/wordpress_master?useunicode=true&characterencoding=utf-8&servertimezone=asia/shanghai

      username: root

      password: 123456

     db2: #数据源db2

      driver- class -name: com.mysql.jdbc.driver

      url: jdbc:mysql: //127.0.0.1:3306/wordpress_slave?useunicode=true&characterencoding=utf-8&servertimezone=asia/shanghai

      username: root

      password: 123456

    type: com.alibaba.druid.pool.druiddatasource

    druid:

     initial-size: 10

     max-active: 100

     min-idle: 10

     max-wait: 60000

     pool-prepared-statements: true

     max-pool-prepared-statement-per-connection-size: 20

     time-between-eviction-runs-millis: 60000

     min-evictable-idle-time-millis: 300000

     #oracle需要打开注释

     #validation-query: select 1 from dual

     test- while -idle: true

     test-on-borrow: false

     test-on- return : false

     stat-view-servlet:

      enabled: true

      url-pattern: /druid/*

      #login-username: admin

      #login-password: admin

     filter:

      stat:

       log-slow-sql: true

       slow-sql-millis: 1000

       merge-sql: false

      wall:

       config:

        multi-statement-allow: true

@springbootapplication (exclude = druiddatasourceautoconfigure. class )