默默a20 2018-07-21 08:41 采纳率: 66.7%
浏览 3386
已结题

Springboot Druid +mybatis 多数据源监控,只能监控到主库SQL,从库不行

配置如下
spring:
circle-datasource: #从库
#123.207.23.166:3306
name: db
url: jdbc:mysql://119.29.208.67:3307/ws?useSSL=false&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: root
password: *****
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
minIdle: 5
maxActive: 100
initialSize: 10
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: select 'x'
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 50
removeAbandoned: true

spring:
datasource: #主库
#123.207.23.166:3306
name: db
url: jdbc:mysql://119.29.208.67:3306/ws?useSSL=false&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: momo
password: *****
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
minIdle: 5
maxActive: 100
initialSize: 10
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: select 'x'
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 50
removeAbandoned: true
filters: stat
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
useGlobalDataSourceStat: true # 合并多个DruidDataSource的监控数据
druidLoginName: momo # 登录druid的账号
druidPassword: momo # 登录druid的密码

----------------------------------------------
   @Bean(name="circleDataSource",destroyMethod = "close", initMethod="init")
public DataSource dataSource(){
    DruidDataSource datasource =  new DruidDataSource();
    try {  
        datasource.setUrl(this.url);
       datasource.setDbType(type);
        datasource.setUsername(username);  
        datasource.setPassword(password);  
        datasource.setDriverClassName(driverClassName);  
        datasource.setInitialSize(initialSize);
        datasource.setMinIdle(minIdle);  
        datasource.setMaxActive(maxActive);  
        datasource.setMaxWait(maxWait);  
        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);  
        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);  
        datasource.setValidationQuery(validationQuery);  
        datasource.setTestWhileIdle(testWhileIdle);  
        datasource.setTestOnBorrow(testOnBorrow);  
        datasource.setTestOnReturn(testOnReturn);  
        datasource.setPoolPreparedStatements(poolPreparedStatements);  
        datasource.setFilters(filters);
        datasource.setUseGlobalDataSourceStat(true);
    } catch (Exception e) {
        logger.error("druid configuration initialization filter", e);  
    }  
    return datasource;  
}

    ---------------------主库-------
      @Bean(name="dataSource",destroyMethod = "close", initMethod="init")
@Primary //不要漏了这
public DataSource dataSource(){
    DruidDataSource datasource = new DruidDataSource();
    try {  
        datasource.setUrl(this.dbUrl);  
        datasource.setDbType(dbType);
        datasource.setUsername(username);  
        datasource.setPassword(password);  
        datasource.setDriverClassName(driverClassName);  
        datasource.setInitialSize(initialSize);  
        datasource.setMinIdle(minIdle);  
        datasource.setMaxActive(maxActive);  
        datasource.setMaxWait(maxWait);  
        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);  
        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);  
        datasource.setValidationQuery(validationQuery);  
        datasource.setTestWhileIdle(testWhileIdle);  
        datasource.setTestOnBorrow(testOnBorrow);  
        datasource.setTestOnReturn(testOnReturn);  
        datasource.setPoolPreparedStatements(poolPreparedStatements);  
        datasource.setFilters(filters);
        datasource.setUseGlobalDataSourceStat(true);
    } catch (SQLException e) {  
        logger.error("druid configuration initialization filter", e);  
    }  
    return datasource;  
}
/////////  下面是druid 监控访问的设置  /////////////////  
@Bean  
public ServletRegistrationBean druidServlet() {  
    ServletRegistrationBean reg = new ServletRegistrationBean();  
    reg.setServlet(new StatViewServlet());  
    reg.addUrlMappings("/druid/*");  //url 匹配  
  //  reg.addInitParameter("allow", "192.168.16.110,127.0.0.1"); // IP白名单 (没有配置或者为空,则允许所有访问)  
  //  reg.addInitParameter("deny", "192.168.16.111"); //IP黑名单 (存在共同时,deny优先于allow)  
    reg.addInitParameter("loginUsername", this.druidLoginName);//登录名  
    reg.addInitParameter("loginPassword", this.druidPassword);//登录密码  
    reg.addInitParameter("resetEnable", "false"); // 禁用HTML页面上的“Reset All”功能  
    return reg;  
}  

@Bean(name="druidWebStatFilter")  
public FilterRegistrationBean filterRegistrationBean() {  
    FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();  
    filterRegistrationBean.setFilter(new WebStatFilter());  
    filterRegistrationBean.addUrlPatterns("/*");  
    filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); //忽略资源  
    filterRegistrationBean.addInitParameter("profileEnable", "true");  
    filterRegistrationBean.addInitParameter("principalCookieName", "USER_COOKIE");  
    filterRegistrationBean.addInitParameter("principalSessionName", "USER_SESSION");  
    return filterRegistrationBean;  
}

    ----------------------------------------------------
    ![图片说明](https://img-ask.csdn.net/upload/201807/21/1532162386_693657.png)
    从库在数据源是监控了,但是sql没有
    ![图片说明](https://img-ask.csdn.net/upload/201807/21/1532162432_671619.png)
  • 写回答

4条回答 默认 最新

  • 默默a20 2018-07-21 08:41
    关注

    图片说明

    评论

报告相同问题?

悬赏问题

  • ¥50 汇编语言除法溢出问题
  • ¥65 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗