一.部署dubbo-admin后臺(便于觀察)
1.安裝/啟動zookeeper(略)舀武，注意規(guī)避8080端口(一些版本的zookeeper啟動后會占用8080，網(wǎng)上有解決辦法)
2.下載dubbo-admin(地址https://github.com/apache/incubator-dubbo-ops)
3.進入dubbo-admin下運行maven指令打包:mvn package -Dmaven.skip.test=true

dubbo-admin-war.PNG

image.png

image.png

二. 項目創(chuàng)建和環(huán)境搭建
1.http://www.reibang.com/p/6361a670ebf7
2.http://www.reibang.com/p/0837b48d1691

三.整合druid數(shù)據(jù)源(->mysql)
參考：https://www.cnblogs.com/hlhdidi/p/6350306.html
https://blog.csdn.net/qq_34531925/article/details/78904897 (Druid數(shù)據(jù)庫配置詳細介紹)
https://www.cnblogs.com/softidea/p/6071630.html
1.在boot-dubbo-provider模塊下的pom.xml中添加依賴

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>

2.Druid數(shù)據(jù)源配置

server:
  port: 8071
  context-path: /
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=UTF-8
    username: root
    password:
    driver-class-name: com.mysql.jdbc.Driver
    platform: mysql
    initialSize: 5
    minIdle: 5
    maxActive: 20
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    maxPoolPreparedStatementPerConnectionSize: 20
    filters: stat,wall,log4j
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
    useGlobalDataSourceStat: true
mybatis:
  mapper-locations: ['mapper/*.xml']

3.建立DruidConfiguration配置類,配置過濾信息(配置完，數(shù)據(jù)庫連接池便實現(xiàn))

@Configuration
@ConditionalOnClass(value = {MapperScannerConfigurer.class,     
DataSourceTransactionManager.class})
@EnableTransactionManagement(proxyTargetClass = true)
public class MysqlDBConfig {
  @Autowired
  @Qualifier("mysqlDB")
  private DataSource ds;
  @Bean(name = "mysqlDB")
  @ConfigurationProperties(prefix = "spring.datasource")
  public DataSource dataSource() {
      return       
 DataSourceBuilder.create().type(com.alibaba.druid.pool.DruidDataSource.class).build();
   }
 }

4.配置數(shù)據(jù)庫監(jiān)控
4.1 依賴

     <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>javax.servlet-api</artifactId>
        <version>4.0.1</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <version>2.0.1.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.apache.tomcat.embed</groupId>
        <artifactId>tomcat-embed-jasper</artifactId>
        <version>9.0.6</version>
    </dependency>

4.2 在MysqlDBConfig中新增方法

import javax.sql.DataSource;

import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.condition.ConditionalOnClass;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
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 org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

/**
 * 
* @ClassName: OracleDBConfig  
* @Description: oracle數(shù)據(jù)源配置  
* @author liyang  
* @date 2018年5月4日  
*
 */
@Configuration
@ConditionalOnClass(value = {MapperScannerConfigurer.class, DataSourceTransactionManager.class})
@EnableTransactionManagement(proxyTargetClass = true)
public class MysqlDBConfig {

    @Autowired
    @Qualifier("mysqlDB")
    private DataSource ds;

    @Bean(name = "mysqlDB")
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource dataSource() {
        return DataSourceBuilder.create().type(com.alibaba.druid.pool.DruidDataSource.class).build();
    }

    /**
     * druid 監(jiān)控
     * @return
     */
    @Bean
    public ServletRegistrationBean statViewServle(){
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
        //白名單：
//        servletRegistrationBean.addInitParameter("allow","192.168.1.218,127.0.0.1");
        //IP黑名單 (存在共同時判耕，deny優(yōu)先于allow) : 如果滿足deny的即提示:Sorry, you are not permitted to view this page.
//        servletRegistrationBean.addInitParameter("deny","192.168.1.100");
        //登錄查看信息的賬號密碼.
        servletRegistrationBean.addInitParameter("loginUsername","druid");
        servletRegistrationBean.addInitParameter("loginPassword","12345678");
        //是否能夠重置數(shù)據(jù).
        servletRegistrationBean.addInitParameter("resetEnable","false");
        return servletRegistrationBean;
    }

    /**
     * druid 監(jiān)控
     * @return
     */
    @Bean
    public FilterRegistrationBean statFilter(){
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        //添加過濾規(guī)則.
        filterRegistrationBean.addUrlPatterns("/*");
        //添加不需要忽略的格式信息.
        filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
        return filterRegistrationBean;
    }

}

4.3 啟動后訪問:

• http://127.0.0.1:8071/druid/index.html
• 賬號/密碼,為4.2中配置: druid/12345678

碼云地址: https://gitee.com/googelchrome/boot-dubbo