springboot关闭druid监控
时间: 2023-08-24 14:10:04 浏览: 95
要关闭 Spring Boot 中的 Druid 监控,需要在 application.properties 或 application.yml 中进行配置。
1. 在 application.properties 中添加以下配置:
```
# 关闭Druid监控
spring.datasource.druid.stat-view-servlet.enabled=false
spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*
spring.datasource.druid.web-stat-filter.enabled=false
```
2. 在 application.yml 中添加以下配置:
```
# 关闭Druid监控
spring:
datasource:
druid:
stat-view-servlet:
enabled: false
url-pattern: /druid/*
web-stat-filter:
enabled: false
```
配置完成后,Druid 监控就会被关闭。
相关问题
springboot 关闭druid重连的配置
在 Spring Boot 中,可以通过配置文件或者编程方式来关闭 Druid 数据源的重连功能。具体实现如下:
1. 在配置文件中添加以下配置,禁用 Druid 数据源的重连功能:
```
spring:
datasource:
druid:
test-on-borrow: true
test-while-idle: true
time-between-eviction-runs-millis: 3600000
validation-query: SELECT 1 FROM DUAL
validation-query-timeout: 3000
break-after-acquire-failure: true
connection-error-retry-attempts: 0
```
2. 在代码中编程方式禁用 Druid 数据源的重连功能:
```
@Configuration
public class DruidConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource.druid")
public DataSource druidDataSource() {
DruidDataSource dataSource = new DruidDataSource();
// 禁用重连功能
dataSource.setTestOnBorrow(true);
dataSource.setTestWhileIdle(true);
dataSource.setTimeBetweenEvictionRunsMillis(3600000);
dataSource.setValidationQuery("SELECT 1 FROM DUAL");
dataSource.setValidationQueryTimeout(3000);
dataSource.setBreakAfterAcquireFailure(true);
dataSource.setConnectionErrorRetryAttempts(0);
return dataSource;
}
}
```
以上两种方式都可以禁用 Druid 数据源的重连功能,根据实际情况进行选择。
springboot 使用Druid
在Spring Boot中使用Druid连接池,你需要进行以下步骤:
1. 引入Druid的依赖:在你的项目的pom.xml文件中,添加以下依赖:
```xml
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.6</version>
</dependency>
```
2. 配置Druid连接池:在application.properties或application.yml文件中,添加以下配置:
```yaml
spring.datasource.url=jdbc:mysql://localhost:3306/db_example
spring.datasource.username=dbuser
spring.datasource.password=dbpass
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
# 配置Druid连接池
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.initial-size=5
spring.datasource.druid.min-idle=5
spring.datasource.druid.max-active=20
spring.datasource.druid.max-wait=60000
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.min-evictable-idle-time-millis=300000
spring.datasource.druid.validation-query=SELECT 1
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.filters=stat,wall,log4j
spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
```
3. 配置Druid监控页面:在你的项目的配置类中,添加以下配置:
```java
@Configuration
public class DruidConfig {
@Bean
public ServletRegistrationBean druidServlet() {
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
// 配置Druid监控页面的登录用户名和密码
servletRegistrationBean.addInitParameter("loginUsername", "admin");
servletRegistrationBean.addInitParameter("loginPassword", "admin");
return servletRegistrationBean;
}
@Bean
public FilterRegistrationBean druidStatFilter() {
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
// 配置Druid监控页面的过滤规则
filterRegistrationBean.addUrlPatterns("/*");
filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
return filterRegistrationBean;
}
}
```
以上就是在Spring Boot中使用Druid连接池的步骤。通过以上配置,你可以使用Druid提供的强大的监控和扩展功能来管理你的数据库连接池。