1. Introduction

Druid connection pool is an open source database connection pool project of Alibaba. Druid connection pool is born for monitoring. It has built-in powerful monitoring function. The monitoring feature does not affect the performance. Powerful, can prevent SQL injection, and built-in login can diagnose Hack application behavior

2. Download

git address: https://github.com/alibaba/druid
http://repo1.maven.org/maven2/com/alibaba/druid/
maven dependency:

<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>1.2.5</version>
</dependency>

3. Configuration details

4. Configure StatFilter for monitoring

https://github.com/alibaba/druid/wiki/%E9%85%8D%E7%BD%AE_StatFilter

5.spring boot integration druid

maven configuration

<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.spring.druid</groupId>
	<artifactId>spring-boot-druid</artifactId>
	<version>0.0.1-SNAPSHOT</version>

	<properties>
		<spring-boot.version>2.5.2</spring-boot.version>
		<druid.version>1.2.5</druid.version>
	</properties>

	<dependencies>
		<!-- druid Connection pool -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>${druid.version}</version>
		</dependency>
		<!--database -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!--web modular -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
	</dependencies>

	<dependencyManagement>
		<dependencies>
			<!--spring boot Public version definition -->
			<dependency>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-dependencies</artifactId>
				<version>${spring-boot.version}</version>
				<type>pom</type>
				<scope>import</scope>
			</dependency>
		</dependencies>
	</dependencyManagement>
</project>

application.yml configuration:

server:
  port: 8888
spring:
  application:
    name: spring-boot-druid
  # data source
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: 123456
      url: jdbc:mysql://xxxx/test?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&allowMultiQueries=true&allowPublicKeyRetrieval=true
      initialSize: 5
      maxActive: 20
      #Maximum wait time to get a connection, in milliseconds
      maxWait: 6000
      #Minimum number of connection pools
      minIdle: 1
      #Configure how often to detect idle connections that need to be closed. The unit is milliseconds
      timeBetweenEvictionRunsMillis: 2000
      #The minimum time, in milliseconds, that a connection remains idle without being evicted
      minEvictableIdleTimeMillis: 600000
      maxEvictableIdleTimeMillis: 900000
      #sql used to check whether the connection is valid
      validationQuery: select 1
      #Check when applying for a connection. If the idle time is greater than timebetween evictionrunsmillis, run validationQuery to check whether the connection is valid
      testWhileIdle: true
      #When applying for a connection, execute validationQuery to check whether the connection is valid. This configuration will reduce performance
      testOnBorrow: false
      #When returning the connection, execute validationQuery to check whether the connection is valid. This configuration will reduce the performance
      testOnReturn: false
      #asyncInit is a newly added configuration in 1.1.4. If there are a large number of initialSize, opening it will speed up the application startup time
      asyncInit: true
      #Enable web monitoring visualization
      stat-view-servlet:
        enabled: true
        allow: ""
        url-pattern: /druid/*
        #login-username: admin
        #login-password: admin
      #Turn on monitoring
      filter:
        stat:
          enabled: true
          log-slow-sql: true
          slow-sql-millis: 2000
          merge-sql: true
        #Anti SQL injection
        wall:
          config:
            multi-statement-allow: true