springboot druid 数据源监控

清疚 2022-04-10 07:19 334阅读 0赞

首现要在配置数据源的地方开启要监控

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

package com.lenovo.esim.cloud.order.config.datasourcemonitor;
    
    import com.alibaba.druid.support.http.StatViewServlet;
    import com.alibaba.druid.support.http.WebStatFilter;
    import lombok.extern.slf4j.Slf4j;
    import org.springframework.beans.factory.annotation.Value;
    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 java.util.HashMap;
    import java.util.Map;
    
    /**
     * datasource 数据源监控中心
     */
    @Slf4j
    @Configuration
    public class DruidMonitorConfig {
    
        @Value("${security.user.name}")
        private String userName;
        @Value("${security.user.password}")
        private String password;
    
        @Bean
        public ServletRegistrationBean druidServlet() {
            log.info("init Druid Servlet Configuration ");
            ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean();
            servletRegistrationBean.setServlet(new StatViewServlet());
            servletRegistrationBean.addUrlMappings("/druid/*");
            Map<String, String> initParameters = new HashMap<String, String>();
            initParameters.put("loginUsername",userName);// 用户名
            initParameters.put("loginPassword", password);// 密码
            initParameters.put("resetEnable", "false");// 禁用HTML页面上的“Reset All”功能
            initParameters.put("allow", ""); // IP白名单 (没有配置或者为空，则允许所有访问)
            // initParameters.put("deny", "192.168.20.38");// IP黑名单
            // (存在共同时，deny优先于allow)
            servletRegistrationBean.setInitParameters(initParameters);
            return servletRegistrationBean;
        }
    
        @Bean
        public FilterRegistrationBean filterRegistrationBean() {
            FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
            filterRegistrationBean.setFilter(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();  
    \}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcWlfcQ_size_16_color_FFFFFF_t_70][]

![20181228161429172.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcWlfcQ_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcWlfcQ_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcWlfcQ_size_16_color_FFFFFF_t_70]: /images/20220402/ed6719ffaf59432b87cf5b52e6d72277.png
[20181228161429172.png]: /images/20220402/60fd1fbaa3af4461adec64f7ecbb7269.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcWlfcQ_size_16_color_FFFFFF_t_70 1]: /images/20220402/73c3ca68130b4723963baeb985378623.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcWlfcQ_size_16_color_FFFFFF_t_70 2]: /images/20220402/15959a67adc14ef2b0b93f23fb96bafc.png