windows 下部署apollo多环境服务

谁践踏了优雅 2022-12-27 08:29 266阅读 0赞

# #

## 一、单环境部署 ##

## 1.按照官方文档步骤操作 ##

## [https://github.com/nobodyiam/apollo-build-scripts][https_github.com_nobodyiam_apollo-build-scripts] ##

## 2.修改demo.sh ##

## 原： ##

Apollo服务端需要知道如何连接到你前面创建的数据库，所以需要编辑demo.sh，修改ApolloPortalDB和ApolloConfigDB相关的数据库连接串信息。
    
    注意：填入的用户需要具备对ApolloPortalDB和ApolloConfigDB数据的读写权限。
    
    #apollo config db info
    apollo_config_db_url=jdbc:mysql://localhost:3306/ApolloConfigDB?characterEncoding=utf8
    apollo_config_db_username=用户名
    apollo_config_db_password=密码（如果没有密码，留空即可）
    
    # apollo portal db info
    apollo_portal_db_url=jdbc:mysql://localhost:3306/ApolloPortalDB?characterEncoding=utf8
    apollo_portal_db_username=用户名
    apollo_portal_db_password=密码（如果没有密码，留空即可）
    注意：不要修改demo.sh的其它部分

## 修改后： ##

apollo\_config\_db\_url=jdbc:mysql://localhost:3306/apolloconfigdb?serverTimezone=UTC  
apollo\_config\_db\_username=root  
apollo\_config\_db\_password=root

\# apollo portal db info  
apollo\_portal\_db\_url=jdbc:mysql://localhost:3306/apolloportaldb?serverTimezone=UTC  
apollo\_portal\_db\_username=root  
apollo\_portal\_db\_password=root

### 2.1.注意：此处我将 characterEncoding=utf8 替换成serverTimezone=UTC 如果没替换会报错 ###

报错信息：

java.sql.SQLException: The server time zone value '?ț???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
    	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
    	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
    	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
    	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
    	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
    	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117)
    	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123)
    	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365)
    	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194)
    	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460)

### 2.2.如果 characterEncoding=utf-8&serverTimezone=UTC 同时存在也会异常  ###

***************************
    APPLICATION FAILED TO START
    ***************************
    
    Description:
    
    Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
    
    Reason: Failed to determine suitable jdbc url
    
    
    Action:
    
    Consider the following:
    	If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
    	If you have database settings to be loaded from a particular profile you may need to activate it (the profiles github are currently active).

## 3.修改之后启动 ##

## ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70][] ##

# #

## 4.启动成功 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 1][]

## 5.[http://localhost:8070/][http_localhost_8070] ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 2][]

# 二、多环境部署 #

## 注意： ##

apollo-portal 服务和 ApolloPortalDB 数据库只需要在生产环境部署一套

apollo-configservice、apollo-adminservice 服务和 ApolloConfigDB 需要在每个环境部署各一套

各个服务：

<table> 
 <thead> 
  <tr> 
   <th>环境</th> 
   <th>地址</th> 
   <th>服务名</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>–</td> 
   <td>localhost:8070</td> 
   <td>apollo-portal</td> 
  </tr> 
  <tr> 
   <td>DEV</td> 
   <td>localhost:8080<br> localhost:8090</td> 
   <td>apollo-configservice<br> apollo-adminservice</td> 
  </tr> 
  <tr> 
   <td>PRO</td> 
   <td>localhost:8081<br> localhost:8091</td> 
   <td>apollo-configservice<br> apollo-adminservice</td> 
  </tr> 
 </tbody> 
</table>

数据库:

<table> 
 <thead> 
  <tr> 
   <th>环境</th> 
   <th>地址</th> 
   <th>数据表名称</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>–</td> 
   <td>localhost:3306</td> 
   <td>ApolloPortalDB</td> 
  </tr> 
  <tr> 
   <td>DEV</td> 
   <td>localhost:3306</td> 
   <td>ApolloConfigDB</td> 
  </tr> 
  <tr> 
   <td>PRO</td> 
   <td>localhost:3306</td> 
   <td>ApolloConfigDB2</td> 
  </tr> 
 </tbody> 
</table>

## 1.按照需要做好准备工作 ##

[https://github.com/ctripcorp/apollo/wiki/%E5%88%86%E5%B8%83%E5%BC%8F%E9%83%A8%E7%BD%B2%E6%8C%87%E5%8D%97\#221-%E8%8E%B7%E5%8F%96%E5%AE%89%E8%A3%85%E5%8C%85][https_github.com_ctripcorp_apollo_wiki_E5_88_86_E5_B8_83_E5_BC_8F_E9_83_A8_E7_BD_B2_E6_8C_87_E5_8D_97_221-_E8_8E_B7_E5_8F_96_E5_AE_89_E8_A3_85_E5_8C_85]

## 2.获取安装包 ##

这边不需要点别的操作，直接从[GitHub Release][]页面下载预先打好的安装包（取最新的即可）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 3][]

## 3.解压 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 4][]

### 注意：在windows模拟多环境portal只需要一个就好，但是adminservice和configservice都需要两份 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 5][]

## 4.数据库准备 ##

![20201221150312586.png][]

apolloconfigdb每个环境都需要自己各自的库所以拷贝了一份apolloconfigdb2

### 5. 修改配置   apollo-configservice-1.7.1-github ###

打开config目录下application-github.properties，修改DB地址

spring.datasource.url = jdbc:mysql://localhost:3306/ApolloConfigDB?useSSL=false&characterEncoding=utf8&serverTimezone=UTC
    spring.datasource.username = root
    spring.datasource.password = root

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 6][]

## apollo-configservice-1.7.1-github2 ##

打开config目录下application-github.properties，修改DB地址

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 7][]

## apollo-adminservice-1.7.1-github ##

打开config目录下application-github.properties，修改DB地址

# DataSource
    spring.datasource.url = jdbc:mysql://localhost:3306/ApolloConfigDB?useSSL=false&characterEncoding=utf8&serverTimezone=UTC
    spring.datasource.username = root
    spring.datasource.password = root

## apollo-adminservice-1.7.1-github1  ##

打开config目录下application-github.properties，修改DB地址

# DataSource
    spring.datasource.url = jdbc:mysql://localhost:3306/ApolloConfigDB2?useSSL=false&characterEncoding=utf8&serverTimezone=UTC
    spring.datasource.username = root
    spring.datasource.password = root

## apollo-portal-1.7.1-github ##

# DataSource
    spring.datasource.url = jdbc:mysql://localhost:3306/ApolloPortalDB?useSSL=false&characterEncoding=utf8&serverTimezone=UTC
    spring.datasource.username = root
    spring.datasource.password = root

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 8][]

## ##

## 6.修改多环境配置 ##

### 6.1添加多环境配置： ###

dev.meta=http://localhost:8080
    pro.meta=http://localhost:8081

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 9][]

### 6.2 数据库中加入上面的dev,pro，多环境直接“,”隔开 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 10][]

## 6.3  修改 apolloconfigdb2  [http://localhost:8081/eureka/][http_localhost_8081_eureka] ##

启动configservice的时候会启动其自带的Eureka。adminservice需要注册到Eureka中，apollo-configservice-1.7.1-github1和apollo-adminservice-1.7.1-github2链接的是apolloconfigdb2

根据7.3启动的端口8081，eureka.service.url修改为[http://localhost:8081/eureka/][http_localhost_8081_eureka]，adminservice才能注册到正确的Eureka

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 11][]

## 7.启动五个jar包 ##

启动要按照configservice、adminservice、portal 的顺序启动。因为启动configservice的时候会启动其自带的Eureka。adminservice需要注册到Eureka中。portal需要发现各环境的adminservice。  
这里特别注意，多环境下，一定要先将所有环境的adminservice和configservice都启动后，最后再启动portal。

7.1  F:\\projectjar\\apollo\\apollo-configservice-1.7.1-github  ------  java -jar apollo-configservice-1.7.1.jar --server.port=8080  
       
   7.2  F:\\projectjar\\apollo\\apollo-adminservice-1.7.1-github  ------  java -jar apollo-adminservice-1.7.1.jar --server.port=8090  
       
    7.3 F:\\projectjar\\apollo\\apollo-configservice-1.7.1-github1  ------  java -jar apollo-configservice-1.7.1.jar --server.port=8081  
       
    7.4 F:\\projectjar\\apollo\\apollo-adminservice-1.7.1-github2  ------  java -jar apollo-adminservice-1.7.1.jar --server.port=8091  
           
    7.5 F:\\projectjar\\apollo\\apollo-portal-1.7.1-github                 ----- java -jar apollo-portal-1.7.1.jar --server.port=8070

## 8. 都启动成功后验证 ##

## 8.1 localhost:8080 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 12][]

## 8.2  localhost:8081  ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 13][]

## 8.3  localhost:8070 可以看到两个环境 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 14][]

# #

[https_github.com_nobodyiam_apollo-build-scripts]: https://github.com/nobodyiam/apollo-build-scripts
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70]: /images/20221120/0d940eb5971b49aabab65da0ea718f94.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 1]: /images/20221120/c1f3104cad6b4f7f85d39a8971ee7714.png
[http_localhost_8070]: http://localhost:8070/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 2]: /images/20221120/6200a8773723449891ba6841fb26bc1f.png
[https_github.com_ctripcorp_apollo_wiki_E5_88_86_E5_B8_83_E5_BC_8F_E9_83_A8_E7_BD_B2_E6_8C_87_E5_8D_97_221-_E8_8E_B7_E5_8F_96_E5_AE_89_E8_A3_85_E5_8C_85]: https://github.com/ctripcorp/apollo/wiki/%E5%88%86%E5%B8%83%E5%BC%8F%E9%83%A8%E7%BD%B2%E6%8C%87%E5%8D%97#221-%E8%8E%B7%E5%8F%96%E5%AE%89%E8%A3%85%E5%8C%85
[GitHub Release]: https://github.com/ctripcorp/apollo/releases
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 3]: /images/20221120/3971befd458d4d73afae512c965b1ece.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 4]: /images/20221120/caf2054c8e4c4dc7bd3494a3b83f4d39.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 5]: /images/20221120/828d2daba4d347d58a57ac4473c8923d.png
[20201221150312586.png]: /images/20221120/b960447163bc433299fe40e7c85bf59a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 6]: /images/20221120/0db7d0e31b2943c09f235acabe80b537.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 7]: /images/20221120/95c443f1415a4b02bba47a899bf0db34.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 8]: /images/20221120/9643edb270e849fe81389145364f0f40.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 9]: /images/20221120/38c41f5644814745bdde5861c8df24fc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 10]: /images/20221120/67b8b758f2684ca6afb1596c961b791a.png
[http_localhost_8081_eureka]: http://localhost:8081/eureka/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 11]: /images/20221120/df8747970cf44e6d8d11cf5400add4af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 12]: /images/20221120/5aa215b0f86e447a851f8af0140bbf4f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 13]: /images/20221120/87bb1d6000f944259642e0e376f8ca26.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 14]: /images/20221120/4ec65e24b1b14ddebb9bcf8140bfedbb.png