使用Druid作为SpringBoot项目数据源（添加监控）

2023-02-06 08:26:37

Druid是一个关系型数据库连接池，它是阿里巴巴的一个开源项目。Druid支持所有JDBC兼容数据库，包括了Oracle、MySQL、PostgreSQL、SQL Server、H2等。
Druid在监控、可扩展性、稳定性和性能方面具有明显的优势。通过Druid提供的监控功能，可以实时观察数据库连接池和SQL查询的工作情况。使用Druid连接池在一定程度上可以提高数据访问效率。

链接：https://www.jianshu.com/p/e84e2709f383

application.yml

spring:

  datasource:

    url: jdbc:mysql://localhost:3306/mstest?useUnicode=true&characterEncoding=utf-8

    driverClassName: com.mysql.jdbc.Driver

    username: root

    password: 123qwe

    #最大活跃数

    maxActive: 20

    #初始化数量

    initialSize: 1

    #最大连接等待超时时间

    maxWait: 60000

    #打开PSCache，并且指定每个连接PSCache的大小

    poolPreparedStatements: true

    maxPoolPreparedStatementPerConnectionSize: 20

    #通过connectionProperties属性来打开mergeSql功能；慢SQL记录

    #connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

    minIdle: 1

    timeBetweenEvictionRunsMillis: 60000

    minEvictableIdleTimeMillis: 300000

    validationQuery: select 1 from dual

    testWhileIdle: true

    testOnBorrow: false

    testOnReturn: false

    #配置监控统计拦截的filters，去掉后监控界面sql将无法统计,'wall'用于防火墙

    filters: stat, wall, log4j

  jpa:

      database: MySQL

      show-sql: true

      hibernate:

        naming_strategy: org.hibernate.cfg.ImprovedNamingStrategy

2.DruidConfiguration.java

实现Druid的访问Servlet以及Filter

package com.example.demo;

import com.alibaba.druid.pool.DruidDataSource;

import com.alibaba.druid.support.http.StatViewServlet;

import com.alibaba.druid.support.http.WebStatFilter;

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

import org.springframework.boot.web.servlet.FilterRegistrationBean;

import org.springframework.boot.web.servlet.ServletRegistrationBean;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**

 * Created by 20160216 on 2018/2/8.

 */

@Configuration

public class DruidConfiguration {

    @Bean

    public ServletRegistrationBean statViewServlet(){

        //创建servlet注册实体

        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");

        //设置ip白名单

        servletRegistrationBean.addInitParameter("allow","127.0.0.1");

        //设置ip黑名单，如果allow与deny共同存在时,deny优先于allow

        servletRegistrationBean.addInitParameter("deny","192.168.0.19");

        //设置控制台管理用户

        servletRegistrationBean.addInitParameter("loginUsername","druid");

        servletRegistrationBean.addInitParameter("loginPassword","123456");

        //是否可以重置数据

        servletRegistrationBean.addInitParameter("resetEnable","false");

        return servletRegistrationBean;

    }

    @Bean

    public FilterRegistrationBean statFilter(){

        //创建过滤器

        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());

        //设置过滤器过滤路径

        filterRegistrationBean.addUrlPatterns("/*");

        //忽略过滤的形式

        filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        return filterRegistrationBean;

    }

    @Bean

    @ConfigurationProperties(prefix = "spring.datasource")

    public DataSource druidDataSource(){

        return new DruidDataSource();

    }

}

3.pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>com.example</groupId>

    <artifactId>less03</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <packaging>war</packaging>

    <name>less03</name>

    <description>Demo project for Spring Boot</description>

    <parent>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-parent</artifactId>

        <version>1.5.10.RELEASE</version>

        <relativePath/> <!-- lookup parent from repository -->

    </parent>

    <properties>

        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

        <java.version>1.8</java.version>

    </properties>

    <dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-data-jpa</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

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

            <scope>runtime</scope>

        </dependency>

            <dependency>

                <groupId>org.springframework.boot</groupId>

                <artifactId>spring-boot-starter-tomcat</artifactId>

                 <!--<scope>provided</scope>-->

        </dependency>

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid</artifactId>

            <version>1.0.29</version>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-test</artifactId>

            <scope>test</scope>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.springframework.boot</groupId>

                <artifactId>spring-boot-maven-plugin</artifactId>

            </plugin>

        </plugins>

    </build>

</project>

4.登录

127.0.0.1:8080/druid/login.html

5.监控

码农公寓

相关文章