nacos数据持久化到mysql

ゝ一纸荒年。 2022-12-05 12:08 207阅读 0赞

我们正式环境线上的naocs配置项都是要持久化到自己的数据库的，方便查找问题。

本地测试准备：

1.下载naocs，[nacos-1.3.2][]

2.下载mysql，我的版本5.7+

下载完naocs后解压，我们进入naocs/conf 可以看到nacos提供了nacos-mysql的脚本

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70][]

我们打开看下，nacos让我们新建数据库并且名称必须为nacos-config

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 1][]

我们新建本地数据库，然后执行nacos-mysql.sql脚本

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 2][]

表解析

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td>config_info</td> 
   <td>配置中心表，配置内容存到这里</td> 
  </tr> 
  <tr> 
   <td>config_info_aggr</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>config_info_beta</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>config_info_tag</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>config_tags_relation</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>group_capacity</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>his_config_info</td> 
   <td>集群、各Group容量信息表，分组和服务对应关系表</td> 
  </tr> 
  <tr> 
   <td>roles</td> 
   <td>角色表</td> 
  </tr> 
  <tr> 
   <td>tenant_capacity</td> 
   <td>租户容量信息表</td> 
  </tr> 
  <tr> 
   <td>tenant_info</td> 
   <td>命名空间表，自定义的命名空间</td> 
  </tr> 
  <tr> 
   <td>users</td> 
   <td>登录用户表，默认nacos/nacos</td> 
  </tr> 
 </tbody> 
</table>

启动nacos，windows本地启动进入nacos文件夹/bin目录，双击 startup.cmd 即可启动，启动后我们启动自己的服务，创建dev命名空间

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 3][]

查看数据库

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 5][]

![20200910105640301.png][]

![20200910105656317.png][]

[nacos-1.3.2]: https://github.com/alibaba/nacos/releases/tag/1.3.2
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70]: /images/20221123/564ed0d4e4a04578a3572a566cb64e12.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 1]: /images/20221123/990eb570353b4becaa8b4f740f57f837.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 2]: /images/20221123/0fad3350e7484926b780095d8c443069.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 3]: /images/20221123/0366a64dc72e4cb0abd41b19c9f84d9d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 4]: /images/20221123/ded394156eac4744899fff2adf14450d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p4bDY0NjgwMTkyNA_size_16_color_FFFFFF_t_70 5]: /images/20221123/0e01ac06a21648b0a83939d356b5e651.png
[20200910105640301.png]: /images/20221123/39811eefcc4146e79aaac2d320621a76.png
[20200910105656317.png]: /images/20221123/e6e24902f4d44c979ce9a8351ed47e85.png