<!--lombok-->

        <dependency>

            <groupId>org.projectlombok</groupId>

            <artifactId>lombok</artifactId>

            <version>1.18.16</version>

            <!--scope=provided，说明它是在编译阶段生效，不需要打入包中，Lombok在编译期将带Lombok注解的Java文件正确编译为完整的Class文件-->

            <scope>provided</scope>

        </dependency>

        <!--mysql-->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

        </dependency>

        <!--mybatis plus和spring boot整合-->

        <dependency>

            <groupId>com.baomidou</groupId>

            <artifactId>mybatis-plus-boot-starter</artifactId>

            <version>3.4.0</version>

        </dependency>

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid</artifactId>

            <version>1.1.10</version>

        </dependency>

server.port=9999

spring.datasource.master.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.master.url=jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=utf-8&useSSL=false

spring.datasource.master.username=root

spring.datasource.master.password=root

spring.datasource.slave.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.slave.jdbc-url=jdbc:mysql://127.0.0.1/test2?useUnicode=true&characterEncoding=utf-8&useSSL=false

spring.datasource.slave.username=root

spring.datasource.slave.password=root

import com.alibaba.druid.pool.DruidDataSource;

import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.Primary;

import org.springframework.core.env.Environment;

import javax.sql.DataSource;

/**

 * @Author：chenyanbin

 */

@Configuration

@MapperScan(basePackages = "com.example.demo.mapper", sqlSessionFactoryRef = "masterSqlSessionFactory")

public class MasterDataSourceConfig {

    @Autowired

    private Environment env;

    @Primary

    @Bean(name = "masterDataSource")

//    @ConfigurationProperties("spring.datasource.master")

    public DataSource masterDataSource() {

//        return DataSourceBuilder.create().build();

        DruidDataSource dataSource = new DruidDataSource();

        dataSource.setUrl(env.getProperty("spring.datasource.master.url"));

        dataSource.setUsername(env.getProperty("spring.datasource.master.username"));

        dataSource.setPassword(env.getProperty("spring.datasource.master.password"));

        dataSource.setDriverClassName(env.getProperty("spring.datasource.master.driver-class-name"));

        //配置初始化大小、最小、最大

        dataSource.setMinIdle(10);

        //配置初始化大小、最小、最大

        dataSource.setMaxActive(200);

        //配置初始化大小、最小、最大

        dataSource.setInitialSize(10);

        //配置获取连接等待超时的时间

        dataSource.setMaxWait(60000);

        //配置一个连接在池中最小生存的时间,单位是毫秒

        dataSource.setMinEvictableIdleTimeMillis(300000);

        //配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒

        dataSource.setTimeBetweenEvictionRunsMillis(60000);

        //默认的testWhileIdle=true,testOnBorrow=false,testOnReturn=false

        dataSource.setValidationQuery("SELECT 1");

        //申请连接时执行validationQuery检测连接是否有效

        dataSource.setTestOnBorrow(false);

        //建议配置为true，不影响性能，并且保证安全性。

        dataSource.setTestWhileIdle(true);

        //是否缓存preparedStatement，也就是PSCache

        dataSource.setPoolPreparedStatements(false);

        return dataSource;

    }

    @Bean(name = "masterSqlSessionFactory")

    public SqlSessionFactory sqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception {

        MybatisSqlSessionFactoryBean sessionFactoryBean = new MybatisSqlSessionFactoryBean();

        sessionFactoryBean.setDataSource(dataSource);

        return sessionFactoryBean.getObject();

    }

}

import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.boot.jdbc.DataSourceBuilder;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**

 * @Author：chenyanbin

 */

@Configuration

@MapperScan(basePackages = "com.example.demo.mapper2",sqlSessionFactoryRef = "slaveSqlSessionFactory")

public class SlaveDataSourceConfig {

    @Bean(name = "slaveDataSource")

    @ConfigurationProperties("spring.datasource.slave")

    public DataSource slaveDataSource(){

        return DataSourceBuilder.create().build();

    }

    @Bean(name = "slaveSqlSessionFactory")

    public SqlSessionFactory sqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception {

        MybatisSqlSessionFactoryBean sessionFactoryBean = new MybatisSqlSessionFactoryBean();

        sessionFactoryBean.setDataSource(dataSource);

        return sessionFactoryBean.getObject();

    }

}

@SpringBootApplication(

        exclude = {DataSourceAutoConfiguration.class, MybatisPlusAutoConfiguration.class}

)