Nacos persistent switch configuration

Nacos Persistent configuration

​ Nacos Embedded database is provided by default derby, So we create one at a time Nacos The instance will have one derby, When there is more than one Nacos Node time , There will be consistency issues , therefore Nacos It supports the unified data management of external database MySql.

Nacos Default derby Switch MySql

For specific configuration methods, please refer to the official website ：https://nacos.io/zh-cn/docs/deployment.html

1. We need to find Nacos Install under directory conf In the directory Sql Script , Then execute in the database

   Be careful ： We need to create the database and use ：

   CREATE DATABASE nacos_config;
   USE nacos_config;
   

2. modify conf/application.properties file , Increase support mysql Data source configuration （ Currently only supported mysql）, add to mysql Data sources url、 User name and password .

spring.datasource.platform=mysql

db.num=1
db.url.0=jdbc:mysql://127.0.0.1:3306/nacos_config?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&serverTimezone=UTC
db.user=root
db.password=root

​ Here means change Nacos The database is native MySql database

Be careful ： Here are a few points to note , One is url The address needs to be changed , In addition, the user and password of the database also need to be changed , At the same time, there is another one on the official website db.url.0=jdbc:mysql One attribute missing from this attribute is serverTimezone=UTC We need to manually add

test

restart Nacos service , Previously created Namespace+Group+DataID It will all disappear , Because these data are saved before Nacos embedded derby In the database , Now it's local MySql database , At this point, we can add configuration tests , Looking at the database nacos_config Medium config_info surface , At this time, there will be newly added configuration content
Database nacos_config Medium config_info surface , At this time, there will be newly added configuration content