Nacos安装部署及配置教程

由于nacos原生只支持内存数据库与mysql，对于一些国产化数据库来说并没有做好适配，那么笔者想专门说一说对于一些国产化数据库该如何去进行nacos的配置，笔者将会从nacos的部署到人大金仓（kingbase）的配置，讲解这整个流程中的操作方式，下面直接进入正题。

第一步：获取Nacos镜像#

使用pull拉取最新nacos镜像

1
docker pull nacos/nacos-server

第二步：获取数据库驱动jar包#

官网也给出了下载地址人大金仓下载中心，同样选择对应的数据库版本，然后在”接口驱动”中进行下载，可以在下载解压后的压缩包里找到对应版本的驱动包

那么这里笔者将会使用kingbase8-8.6.0.jar这个驱动，按照实际情况选择对应的包即可

第三步：创建持久化目录（conf、logs、data、libs）#

笔者在根目录data文件中创建，你也可以选择其它位置作为你的之后挂载节点

1
cd /data
2
mkdir nacos
3
cd /data/nacos
4
mkdir conf
5
mkdir logs
6
mkdir libs

文件目录结构如下

第四步：上传数据库驱动包至libs文件夹#

这一步没啥好说的，有手就行

第五步：编写application.properties配置文件#

1
# 这里这个mysql不用管，不影响最终连接kingbase
2
spring.datasource.platform=mysql
3
db.num=1
4
# 【需要修改】这里替换成你的数据库连接ip和端口，其它参数不要动
5
db.url.0=jdbc:kingbase8://127.0.0.1:54321/nacos_config?allowEncodingChanges=true&clientEncoding=UTF8
6
# 【需要修改】数据库认证用户
7
db.user.0=admin
8
# 【需要修改】数据库认证密码
9
db.password.0=admin123
10
# 开启集群鉴权
11
nacos.core.auth.enabled=true
12
nacos.core.auth.enable.userAgentAuthWhite=false
13
nacos.core.auth.plugin.nacos.token.secret.key=${NACOS_AUTH_TOKEN:iW0hB1iM1gX3uG5bF1kB4wB4gY9oP0pR9yI4fK0zE4kJ3gR9vU8uV9uH3xP8cJ7hX3uX5xO0}
14
nacos.core.auth.server.identity.key=${NACOS_AUTH_IDENTITY_KEY:admin}
15
nacos.core.auth.server.identity.value=${NACOS_AUTH_IDENTITY_VALUE:admin}

然后将这个配置文件上传至config文件夹内

第六步：配置Nacos数据库#

这里直接提供SQL脚本了，直接丢数据库运行一下一键生成所需要的库和表单

1
CREATE DATABASE nacos_config ENCODING = 'UTF8';
2
\ C nacos_config;
3
CREATE TABLE "config_info" (
4
  "id" BIGSERIAL NOT NULL,
5
  "data_id" VARCHAR ( 255 ) NOT NULL,
6
  "group_id" VARCHAR ( 128 ),
7
  "content" TEXT NOT NULL,
8
  "md5" VARCHAR ( 32 ),
9
  "gmt_create" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
10
  "gmt_modified" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
11
  "src_user" TEXT,
12
  "src_ip" VARCHAR ( 50 ),
13
  "app_name" VARCHAR ( 128 ),
14
  "tenant_id" VARCHAR ( 128 ) DEFAULT '',
15
  "c_desc" VARCHAR ( 256 ),
16
  "c_use" VARCHAR ( 64 ),
17
  "effect" VARCHAR ( 64 ),
18
  "type" VARCHAR ( 64 ),
19
  "c_schema" TEXT,
20
  "encrypted_data_key" VARCHAR ( 1024 ) NOT NULL DEFAULT '',
21
  PRIMARY KEY ( "id" ),
22
  UNIQUE ( "data_id", "group_id", "tenant_id" )
23
);
24
COMMENT ON TABLE "config_info" IS 'config_info';
25
COMMENT ON COLUMN "config_info"."id" IS 'id';
26
CREATE TABLE "config_info_gray" (
27
  "id" BIGSERIAL NOT NULL,
28
  "data_id" VARCHAR ( 255 ) NOT NULL,
29
  "group_id" VARCHAR ( 128 ) NOT NULL,
30
  "content" TEXT NOT NULL,
31
  "md5" VARCHAR ( 32 ),
32
  "src_user" TEXT,
33
  "src_ip" VARCHAR ( 100 ),
34
  "gmt_create" TIMESTAMP ( 3 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ( 3 ),
35
  "gmt_modified" TIMESTAMP ( 3 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ( 3 ),
36
  "app_name" VARCHAR ( 128 ),
37
  "tenant_id" VARCHAR ( 128 ) DEFAULT '',
38
  "gray_name" VARCHAR ( 128 ) NOT NULL,
39
  "gray_rule" TEXT NOT NULL,
40
  "encrypted_data_key" VARCHAR ( 256 ) NOT NULL DEFAULT '',
41
  PRIMARY KEY ( "id" ),
42
  UNIQUE ( "data_id", "group_id", "tenant_id", "gray_name" )
43
);
44
CREATE INDEX "idx_dataid_gmt_modified" ON "config_info_gray" ( "data_id", "gmt_modified" );
45
CREATE INDEX "idx_gmt_modified" ON "config_info_gray" ( "gmt_modified" );
46
COMMENT ON TABLE "config_info_gray" IS 'config_info_gray';
47
CREATE TABLE "config_tags_relation" (
48
  "id" BIGINT NOT NULL,
49
  "tag_name" VARCHAR ( 128 ) NOT NULL,
50
  "tag_type" VARCHAR ( 64 ),
51
  "data_id" VARCHAR ( 255 ) NOT NULL,
52
  "group_id" VARCHAR ( 128 ) NOT NULL,
53
  "tenant_id" VARCHAR ( 128 ) DEFAULT '',
54
  "nid" BIGSERIAL NOT NULL,
55
  PRIMARY KEY ( "nid" ),
56
  UNIQUE ( "id", "tag_name", "tag_type" )
57
);
58
CREATE INDEX "idx_tenant_id" ON "config_tags_relation" ( "tenant_id" );
59
COMMENT ON TABLE "config_tags_relation" IS 'config_tag_relation';
60
CREATE TABLE "group_capacity" (
61
  "id" BIGSERIAL NOT NULL,
62
  "group_id" VARCHAR ( 128 ) NOT NULL DEFAULT '',
63
  "quota" INTEGER NOT NULL DEFAULT 0,
64
  "usage" INTEGER NOT NULL DEFAULT 0,
65
  "max_size" INTEGER NOT NULL DEFAULT 0,
66
  "max_aggr_count" INTEGER NOT NULL DEFAULT 0,
67
  "max_aggr_size" INTEGER NOT NULL DEFAULT 0,
68
  "max_history_count" INTEGER NOT NULL DEFAULT 0,
69
  "gmt_create" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
70
  "gmt_modified" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
71
  PRIMARY KEY ( "id" ),
72
  UNIQUE ( "group_id" )
73
);
74
COMMENT ON TABLE "group_capacity" IS '集群、各Group容量信息表';
75
CREATE TABLE "users" ( "username" VARCHAR ( 50 ) NOT NULL PRIMARY KEY, "password" VARCHAR ( 500 ) NOT NULL, "enabled" BOOLEAN NOT NULL );
76
CREATE TABLE "roles" ( "username" VARCHAR ( 50 ) NOT NULL, "role" VARCHAR ( 50 ) NOT NULL, UNIQUE ( "username", "role" ) );
77
CREATE TABLE "permissions" (
78
  "role" VARCHAR ( 50 ) NOT NULL,
79
  "resource" VARCHAR ( 128 ) NOT NULL,
80
  "action" VARCHAR ( 8 ) NOT NULL,
81
  UNIQUE ( "role", "resource", "action" )
82
);
83
CREATE TABLE config_info_beta (
84
  ID INTEGER AUTO_INCREMENT NOT NULL,
85
  data_id VARCHAR ( 255 ) NOT NULL,
86
  group_id VARCHAR ( 128 ) NOT NULL,
87
  app_name VARCHAR ( 128 ) DEFAULT NULL,
88
  CONTENT TEXT NOT NULL,
89
  beta_ips TEXT DEFAULT NULL,
90
  md5 VARCHAR ( 32 ) DEFAULT NULL,
91
  gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
92
  gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
93
  src_user TEXT,
94
  src_ip VARCHAR ( 20 ) DEFAULT NULL,
95
  tenant_id VARCHAR ( 128 ) DEFAULT '',
96
  encrypted_data_key TEXT
97
);
98
COMMENT ON TABLE config_info_beta IS 'config_info_beta';
99
COMMENT ON COLUMN config_info_beta.gmt_create IS '创建时间';
100
COMMENT ON COLUMN config_info_beta.gmt_modified IS '修改时间';
101
COMMENT ON COLUMN config_info_beta.src_user IS 'source user';
102
COMMENT ON COLUMN config_info_beta.tenant_id IS '租户字段';
103
COMMENT ON COLUMN config_info_beta.encrypted_data_key IS '秘钥';
104
ALTER TABLE config_info_beta ADD CONSTRAINT pk_config_info_beta PRIMARY KEY ( ID ) ENABLE VALIDATE;
105
ALTER TABLE config_info_beta ADD CONSTRAINT uk_configinfobeta_datagrouptenant UNIQUE ( data_id, group_id, tenant_id ) ENABLE VALIDATE;
106
CREATE TABLE config_info_tag (
107
  ID INTEGER AUTO_INCREMENT NOT NULL,
108
  data_id VARCHAR ( 255 ) NOT NULL,
109
  group_id VARCHAR ( 128 ) NOT NULL,
110
  tenant_id VARCHAR ( 128 ) DEFAULT '',
111
  tag_id VARCHAR ( 128 ) NOT NULL,
112
  app_name VARCHAR ( 128 ) DEFAULT NULL,
113
  CONTENT TEXT NOT NULL,
114
  md5 VARCHAR ( 32 ) DEFAULT NULL,
115
  gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
116
  gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
117
  src_user TEXT,
118
  src_ip VARCHAR ( 20 ) DEFAULT NULL
119
);
120
COMMENT ON TABLE config_info_tag IS 'config_info_tag';
121
COMMENT ON COLUMN config_info_tag.gmt_create IS '创建时间';
122
COMMENT ON COLUMN config_info_tag.gmt_modified IS '修改时间';
123
COMMENT ON COLUMN config_info_tag.src_user IS 'source user';
124
COMMENT ON COLUMN config_info_tag.src_ip IS 'source ip';
125
ALTER TABLE config_info_tag ADD CONSTRAINT pk_config_info_tag PRIMARY KEY ( ID ) ENABLE VALIDATE;
126
ALTER TABLE config_info_tag ADD CONSTRAINT uk_configinfotag_datagrouptenanttag UNIQUE ( data_id, group_id, tenant_id, tag_id ) ENABLE VALIDATE;
127
CREATE TABLE his_config_info (
128
  ID BIGINT NOT NULL,
129
  nid BIGINT NOT NULL AUTO_INCREMENT,
130
  data_id VARCHAR ( 255 ) NOT NULL,
131
  group_id VARCHAR ( 128 ) NOT NULL,
132
  app_name VARCHAR ( 128 ) DEFAULT NULL,
133
  CONTENT TEXT NOT NULL,
134
  md5 VARCHAR ( 32 ) DEFAULT NULL,
135
  gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
136
  gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
137
  src_user TEXT,
138
  src_ip VARCHAR ( 20 ) DEFAULT NULL,
139
  op_type CHAR ( 10 ) DEFAULT NULL,
140
  tenant_id VARCHAR ( 128 ) DEFAULT '',
141
  encrypted_data_key TEXT
142
);
143
COMMENT ON TABLE his_config_info IS '多租户改造';
144
COMMENT ON COLUMN his_config_info.tenant_id IS '租户字段';
145
COMMENT ON COLUMN his_config_info.encrypted_data_key IS '秘钥';
146
ALTER TABLE his_config_info ADD CONSTRAINT pk_his_config_info PRIMARY KEY ( nid ) ENABLE VALIDATE;
147
CREATE INDEX idx_gmt_create ON his_config_info USING BTREE ( gmt_create ) TABLESPACE sys_default;
148
CREATE INDEX idx_gmt_modified ON his_config_info USING BTREE ( gmt_modified ) TABLESPACE sys_default;
149
CREATE INDEX idx_did ON his_config_info USING BTREE ( data_id ) TABLESPACE sys_default;
150
CREATE TABLE tenant_capacity (
151
  ID BIGINT NOT NULL AUTO_INCREMENT,
152
  tenant_id VARCHAR ( 128 ) NOT NULL DEFAULT '',
153
  quota INTEGER NOT NULL DEFAULT '0',
154
  USAGE INTEGER NOT NULL DEFAULT '0',
155
  max_size INTEGER NOT NULL DEFAULT '0',
156
  max_aggr_count INTEGER NOT NULL DEFAULT '0',
157
  max_aggr_size INTEGER NOT NULL DEFAULT '0',
158
  max_history_count INTEGER NOT NULL DEFAULT '0',
159
  gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
160
  gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
161
);
162
COMMENT ON TABLE tenant_capacity IS '租户容量信息表';
163
COMMENT ON COLUMN tenant_capacity.ID IS '主键ID';
164
COMMENT ON COLUMN tenant_capacity.tenant_id IS 'Tenant ID';
165
COMMENT ON COLUMN tenant_capacity.quota IS '配额，0表示使用默认值';
166
COMMENT ON COLUMN tenant_capacity.USAGE IS '使用量';
167
COMMENT ON COLUMN tenant_capacity.max_size IS '单个配置大小上限，单位为字节，0表示使用默认值';
168
COMMENT ON COLUMN tenant_capacity.max_aggr_count IS '聚合子配置最大个数';
169
COMMENT ON COLUMN tenant_capacity.max_aggr_size IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';
170
COMMENT ON COLUMN tenant_capacity.max_history_count IS '最大变更历史数量';
171
COMMENT ON COLUMN tenant_capacity.gmt_create IS '创建时间';
172
COMMENT ON COLUMN tenant_capacity.gmt_modified IS '修改时间';
173
ALTER TABLE tenant_capacity ADD CONSTRAINT pk_tenant_capacity PRIMARY KEY ( ID ) ENABLE VALIDATE;
174
ALTER TABLE tenant_capacity ADD CONSTRAINT uk_tenant_id UNIQUE ( tenant_id ) ENABLE VALIDATE;
175
CREATE TABLE tenant_info (
176
  ID BIGINT NOT NULL AUTO_INCREMENT,
177
  kp VARCHAR ( 128 ) NOT NULL,
178
  tenant_id VARCHAR ( 128 ) DEFAULT '',
179
  tenant_name VARCHAR ( 128 ) DEFAULT '',
180
  tenant_desc VARCHAR ( 256 ) DEFAULT NULL,
181
  create_source VARCHAR ( 32 ) DEFAULT NULL,
182
  gmt_create BIGINT NOT NULL,
183
  gmt_modified BIGINT NOT NULL
184
);
185
COMMENT ON TABLE tenant_info IS 'tenant_info';
186
COMMENT ON COLUMN tenant_info.gmt_create IS '创建时间';
187
COMMENT ON COLUMN tenant_info.gmt_modified IS '修改时间';
188
ALTER TABLE tenant_info ADD CONSTRAINT pk_tenant_info PRIMARY KEY ( ID ) ENABLE VALIDATE;
189
ALTER TABLE tenant_info ADD CONSTRAINT uk_tenant_info_kptenantid UNIQUE ( kp, tenant_id ) ENABLE VALIDATE;
190
CREATE INDEX idx_tenant_id_2 ON tenant_info USING BTREE ( tenant_id ) TABLESPACE sys_default;
191
INSERT INTO tenant_info ( ID, kp, tenant_id, tenant_name, tenant_desc, create_source, gmt_create, gmt_modified )
192
VALUES
193
  ( 1, '1', 'dev', 'dev', '开发环境', NULL, 1641741270448, 1641741287236 ),
194
  ( 2, '1', 'prod', 'prod', '生产环境', NULL, 1641741270448, 1641741287236 ),
195
  ( 3, '1', 'test', 'test', '测试环境', NULL, 1641741270448, 1641741287236 );

正常情况会生成如下库和表单

第七步：编写docker-compose.yml文件#

这个配置文件放哪儿都可以，笔者放在/home/nacos下，配置内容如下

1
services:
2
  nacos:
3
    image: nacos/nacos-server:latest
4
    container_name: nacos
5
    environment:
6
      MODE: standalone
7
      JVM_XMS: 512m
8
      JVM_XMX: 512m
9
      JVM_XMN: 256m
10
      DB_POOL_CONFIG_DRIVERCLASSNAME: com.kingbase8.Driver
11
    volumes:
12
      - /data/nacos/libs/kingbase8-8.6.0.jar:/home/nacos/plugins/kingbase8-8.6.0.jar
13
      - /data/nacos/conf/application.properties:/home/nacos/conf/application.properties
14
      - /data/nacos/logs/:/home/nacos/logs
15
    privileged: true
16
    restart: always
17
    network_mode: "host"

第八步：启动Nacos容器并访问#

1
# 【需要修改】进入刚才编写好的docker-compose.yml所在目录
2
cd /home/nacos
3
# 启动！
4
docker-compose -f up docker-compose.yml up -d

接着直接访问服务器ip的8848端口即可打开nacos管理页，首次登录会要求设置密码

完成以上步骤便大功告成

音乐

音乐