Nacos适配达梦数据库(不修改源码)，基于Docker-compose

已于 2023-09-27 22:05:01 修改
阅读量1.7k 收藏 11
点赞数 4
分类专栏： nacos 文章标签： 数据库 docker 容器
于 2023-08-11 11:45:44 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_38155822/article/details/132227553
版权

1. 编写docker-compose.yml文件

        vim docker-compose.yml

version: "3.0"
services:
  nacos:
    image: nacos/nacos-server:v2.2.0
    container_name: nacos
    environment:
      MODE: standalone
      JVM_XMS: 512m
      JVM_XMX: 512m
      JVM_XMN: 256m
      DB_POOL_CONFIG_DRIVERCLASSNAME: dm.jdbc.driver.DmDriver
      JAVA_OPT: "-Dloader.path=/home/nacos/libs"
    volumes:
      - /home/nacos/libs/DmJdbcDriver18-8.1.2.79.jar:/home/nacos/libs/DmJdbcDriver18-8.1.2.79.jar
      - /home/nacos/conf/application.properties:/home/nacos/conf/application.properties
      - /home/nacos/logs/:/home/nacos/logs
    privileged: true
    restart: always
    network_mode: "host"

2. 下载驱动文件 

DmJdbcDriver18-8.1.2.79.jar

        文件下载地址icon-default.png?t=N7T8https://developer.aliyun.com/mvn/search

 将文件放到服务器上，路径要与docker-compose.yml中映射的一致

3.  编写配置文件，放入/home/nacos/conf/application.properties

 vim application.properties

#
# Copyright 1999-2021 Alibaba Group Holding Ltd.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

#*************** Spring Boot Related Configurations ***************#
### Default web context path:
server.servlet.contextPath=/nacos
### Include message field
server.error.include-message=ALWAYS
### Default web server port:
server.port=8848

#*************** Network Related Configurations ***************#
### If prefer hostname over ip for Nacos server addresses in cluster.conf:
# nacos.inetutils.prefer-hostname-over-ip=false

### Specify local server's IP:
# nacos.inetutils.ip-address=


#*************** Config Module Related Configurations ***************#
### If use MySQL as datasource:
spring.datasource.platform=mysql

### Count of DB:
db.num=1

# Connect URL of DB:
db.jdbcDriverName=dm.jdbc.driver.DmDriver
db.url.0=jdbc:dm://192.168.31.167:5236?schema=NACOS&characterEncoding=UTF-8&useUnicode=true&serverTimezone=Asia/Shanghai
db.user=SYSDBA
db.password=SYSDBA001

### Connection pool configuration: hikariCP
db.pool.config.connectionTimeout=30000
db.pool.config.validationTimeout=10000
db.pool.config.maximumPoolSize=20
db.pool.config.minimumIdle=2

#*************** Naming Module Related Configurations ***************#

### If enable data warmup. If set to false, the server would accept request without local data preparation:
# nacos.naming.data.warmup=true

### If enable the instance auto expiration, kind like of health check of instance:
# nacos.naming.expireInstance=true

### Add in 2.0.0
### The interval to clean empty service, unit: milliseconds.
# nacos.naming.clean.empty-service.interval=60000

### The expired time to clean empty service, unit: milliseconds.
# nacos.naming.clean.empty-service.expired-time=60000

### The interval to clean expired metadata, unit: milliseconds.
# nacos.naming.clean.expired-metadata.interval=5000

### The expired time to clean metadata, unit: milliseconds.
# nacos.naming.clean.expired-metadata.expired-time=60000

### The delay time before push task to execute from service changed, unit: milliseconds.
# nacos.naming.push.pushTaskDelay=500

### The timeout for push task execute, unit: milliseconds.
# nacos.naming.push.pushTaskTimeout=5000

### The delay time for retrying failed push task, unit: milliseconds.
# nacos.naming.push.pushTaskRetryDelay=1000

### Since 2.0.3
### The expired time for inactive client, unit: milliseconds.
# nacos.naming.client.expired.time=180000

#*************** CMDB Module Related Configurations ***************#
### The interval to dump external CMDB in seconds:
# nacos.cmdb.dumpTaskInterval=3600

### The interval of polling data change event in seconds:
# nacos.cmdb.eventTaskInterval=10

### The interval of loading labels in seconds:
# nacos.cmdb.labelTaskInterval=300

### If turn on data loading task:
# nacos.cmdb.loadDataAtStart=false


#*************** Metrics Related Configurations ***************#
### Metrics for prometheus
#management.endpoints.web.exposure.include=*

### Metrics for elastic search
management.metrics.export.elastic.enabled=false
#management.metrics.export.elastic.host=http://localhost:9200

### Metrics for influx
management.metrics.export.influx.enabled=false
#management.metrics.export.influx.db=springboot
#management.metrics.export.influx.uri=http://localhost:8086
#management.metrics.export.influx.auto-create-db=true
#management.metrics.export.influx.consistency=one
#management.metrics.export.influx.compressed=true

#*************** Access Log Related Configurations ***************#
### If turn on the access log:
server.tomcat.accesslog.enabled=true

### The access log pattern:
server.tomcat.accesslog.pattern=%h %l %u %t "%r" %s %b %D %{User-Agent}i %{Request-Source}i

### The directory of access log:
server.tomcat.basedir=file:.

#*************** Access Control Related Configurations ***************#
### If enable spring security, this option is deprecated in 1.2.0:
#spring.security.enabled=false

### The ignore urls of auth
nacos.security.ignore.urls=/,/error,/**/*.css,/**/*.js,/**/*.html,/**/*.map,/**/*.svg,/**/*.png,/**/*.ico,/console-ui/public/**,/v1/auth/**,/v1/console/health/**,/actuator/**,/v1/console/server/**

### The auth system to use, currently only 'nacos' and 'ldap' is supported:
nacos.core.auth.system.type=nacos

### If turn on auth system:
nacos.core.auth.enabled=false

### Turn on/off caching of auth information. By turning on this switch, the update of auth information would have a 15 seconds delay.
nacos.core.auth.caching.enabled=true

### Since 1.4.1, Turn on/off white auth for user-agent: nacos-server, only for upgrade from old version.
nacos.core.auth.enable.userAgentAuthWhite=false

### Since 1.4.1, worked when nacos.core.auth.enabled=true and nacos.core.auth.enable.userAgentAuthWhite=false.
### The two properties is the white list for auth and used by identity the request from other server.
nacos.core.auth.server.identity.key=serverIdentity
nacos.core.auth.server.identity.value=security

### worked when nacos.core.auth.system.type=nacos
### The token expiration in seconds:
nacos.core.auth.plugin.nacos.token.expire.seconds=18000
### The default token (Base64 String):
nacos.core.auth.plugin.nacos.token.secret.key=SecretKey012345678901234567890123456789012345678901234567890123456789

### worked when nacos.core.auth.system.type=ldap，{0} is Placeholder,replace login username
#nacos.core.auth.ldap.url=ldap://localhost:389
#nacos.core.auth.ldap.basedc=dc=example,dc=org
#nacos.core.auth.ldap.userDn=cn=admin,${nacos.core.auth.ldap.basedc}
#nacos.core.auth.ldap.password=admin
#nacos.core.auth.ldap.userdn=cn={0},dc=example,dc=org
#nacos.core.auth.ldap.filter.prefix=uid
#nacos.core.auth.ldap.case.sensitive=true


#*************** Istio Related Configurations ***************#
### If turn on the MCP server:
nacos.istio.mcp.server.enabled=false

#*************** Core Related Configurations ***************#

### set the WorkerID manually
# nacos.core.snowflake.worker-id=

### Member-MetaData
# nacos.core.member.meta.site=
# nacos.core.member.meta.adweight=
# nacos.core.member.meta.weight=

### MemberLookup
### Addressing pattern category, If set, the priority is highest
# nacos.core.member.lookup.type=[file,address-server]
## Set the cluster list with a configuration file or command-line argument
# nacos.member.list=192.168.16.101:8847?raft_port=8807,192.168.16.101?raft_port=8808,192.168.16.101:8849?raft_port=8809
## for AddressServerMemberLookup
# Maximum number of retries to query the address server upon initialization
# nacos.core.address-server.retry=5
## Server domain name address of [address-server] mode
# address.server.domain=jmenv.tbsite.net
## Server port of [address-server] mode
# address.server.port=8080
## Request address of [address-server] mode
# address.server.url=/nacos/serverlist

#*************** JRaft Related Configurations ***************#

### Sets the Raft cluster election timeout, default value is 5 second
# nacos.core.protocol.raft.data.election_timeout_ms=5000
### Sets the amount of time the Raft snapshot will execute periodically, default is 30 minute
# nacos.core.protocol.raft.data.snapshot_interval_secs=30
### raft internal worker threads
# nacos.core.protocol.raft.data.core_thread_num=8
### Number of threads required for raft business request processing
# nacos.core.protocol.raft.data.cli_service_thread_num=4
### raft linear read strategy. Safe linear reads are used by default, that is, the Leader tenure is confirmed by heartbeat
# nacos.core.protocol.raft.data.read_index_type=ReadOnlySafe
### rpc request timeout, default 5 seconds
# nacos.core.protocol.raft.data.rpc_request_timeout_ms=5000

#*************** Distro Related Configurations ***************#

### Distro data sync delay time, when sync task delayed, task will be merged for same data key. Default 1 second.
# nacos.core.protocol.distro.data.sync.delayMs=1000

### Distro data sync timeout for one sync data, default 3 seconds.
# nacos.core.protocol.distro.data.sync.timeoutMs=3000

### Distro data sync retry delay time when sync data failed or timeout, same behavior with delayMs, default 3 seconds.
# nacos.core.protocol.distro.data.sync.retryDelayMs=3000

### Distro data verify interval time, verify synced data whether expired for a interval. Default 5 seconds.
# nacos.core.protocol.distro.data.verify.intervalMs=5000

### Distro data verify timeout for one verify, default 3 seconds.
# nacos.core.protocol.distro.data.verify.timeoutMs=3000

### Distro data load retry delay when load snapshot data failed, default 30 seconds.
# nacos.core.protocol.distro.data.load.retryDelayMs=30000

### enable to support prometheus service discovery
#nacos.prometheus.metrics.enabled=true

重点是如下数据库配置信息

 nacos数据库表信息：

CREATE TABLE "NACOS"."USERS"
(
 "USERNAME" VARCHAR(50) NOT NULL,
 "PASSWORD" VARCHAR(500) NOT NULL,
 "ENABLED" TINYINT NOT NULL
);

CREATE TABLE "NACOS"."TENANT_INFO"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "KP" VARCHAR(128) NOT NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL,
 "TENANT_NAME" VARCHAR(128) DEFAULT ''
 NULL,
 "TENANT_DESC" VARCHAR(256) NULL,
 "CREATE_SOURCE" VARCHAR(32) NULL,
 "GMT_CREATE" BIGINT NOT NULL,
 "GMT_MODIFIED" BIGINT NOT NULL
);

CREATE TABLE "NACOS"."TENANT_CAPACITY"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NOT NULL,
 "QUOTA" BIGINT DEFAULT 0
 NOT NULL,
 "USAGE" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_SIZE" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_AGGR_COUNT" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_AGGR_SIZE" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_HISTORY_COUNT" BIGINT DEFAULT 0
 NOT NULL,
 "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL
);

CREATE TABLE "NACOS"."ROLES"
(
 "USERNAME" VARCHAR(50) NOT NULL,
 "ROLE" VARCHAR(50) NOT NULL
);

CREATE TABLE "NACOS"."PERMISSIONS"
(
 "ROLE" VARCHAR(50) NOT NULL,
 "RESOURCE" VARCHAR(255) NOT NULL,
 "ACTION" VARCHAR(8) NOT NULL
);

CREATE TABLE "NACOS"."HIS_CONFIG_INFO"
(
 "ID" DECIMAL(20,0) NOT NULL,
 "NID" BIGINT IDENTITY(1,1) NOT NULL,
 "DATA_ID" VARCHAR(255) NOT NULL,
 "GROUP_ID" VARCHAR(128) NOT NULL,
 "APP_NAME" VARCHAR(128) NULL,
 "CONTENT" CLOB NOT NULL,
 "MD5" VARCHAR(32) NULL,
 "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "SRC_USER" TEXT NULL,
 "SRC_IP" VARCHAR(50) NULL,
 "OP_TYPE" CHAR(10) NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL,
 "ENCRYPTED_DATA_KEY" TEXT NOT NULL
);

CREATE TABLE "NACOS"."GROUP_CAPACITY"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "GROUP_ID" VARCHAR(128) DEFAULT ''
 NOT NULL,
 "QUOTA" BIGINT DEFAULT 0
 NOT NULL,
 "USAGE" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_SIZE" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_AGGR_COUNT" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_AGGR_SIZE" BIGINT DEFAULT 0
 NOT NULL,
 "MAX_HISTORY_COUNT" BIGINT DEFAULT 0
 NOT NULL,
 "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL
);

CREATE TABLE "NACOS"."CONFIG_TAGS_RELATION"
(
 "ID" BIGINT NOT NULL,
 "TAG_NAME" VARCHAR(128) NOT NULL,
 "TAG_TYPE" VARCHAR(64) NULL,
 "DATA_ID" VARCHAR(255) NOT NULL,
 "GROUP_ID" VARCHAR(128) NOT NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL,
 "NID" BIGINT IDENTITY(1,1) NOT NULL
);

CREATE TABLE "NACOS"."CONFIG_INFO_TAG"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "DATA_ID" VARCHAR(255) NOT NULL,
 "GROUP_ID" VARCHAR(128) NOT NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL,
 "TAG_ID" VARCHAR(128) NOT NULL,
 "APP_NAME" VARCHAR(128) NULL,
 "CONTENT" CLOB NOT NULL,
 "MD5" VARCHAR(32) NULL,
 "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "SRC_USER" TEXT NULL,
 "SRC_IP" VARCHAR(50) NULL
);

CREATE TABLE "NACOS"."CONFIG_INFO_BETA"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "DATA_ID" VARCHAR(255) NOT NULL,
 "GROUP_ID" VARCHAR(128) NOT NULL,
 "APP_NAME" VARCHAR(128) NULL,
 "CONTENT" CLOB NOT NULL,
 "BETA_IPS" VARCHAR(1024) NULL,
 "MD5" VARCHAR(32) NULL,
 "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "SRC_USER" TEXT NULL,
 "SRC_IP" VARCHAR(50) NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL,
 "ENCRYPTED_DATA_KEY" TEXT NOT NULL
);

CREATE TABLE "NACOS"."CONFIG_INFO_AGGR"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "DATA_ID" VARCHAR(255) NOT NULL,
 "GROUP_ID" VARCHAR(128) NOT NULL,
 "DATUM_ID" VARCHAR(255) NOT NULL,
 "CONTENT" CLOB NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) NOT NULL,
 "APP_NAME" VARCHAR(128) NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL
);

CREATE TABLE "NACOS"."CONFIG_INFO"
(
 "ID" BIGINT IDENTITY(1,1) NOT NULL,
 "DATA_ID" VARCHAR(255) NOT NULL,
 "GROUP_ID" VARCHAR(128) NULL,
 "CONTENT" CLOB NOT NULL,
 "MD5" VARCHAR(32) NULL,
 "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()
 NOT NULL,
 "SRC_USER" TEXT NULL,
 "SRC_IP" VARCHAR(50) NULL,
 "APP_NAME" VARCHAR(128) NULL,
 "TENANT_ID" VARCHAR(128) DEFAULT ''
 NULL,
 "C_DESC" VARCHAR(256) NULL,
 "C_USE" VARCHAR(64) NULL,
 "EFFECT" VARCHAR(64) NULL,
 "TYPE" VARCHAR(64) NULL,
 "C_SCHEMA" TEXT NULL,
 "ENCRYPTED_DATA_KEY" TEXT NOT NULL
);

SET IDENTITY_INSERT "NACOS"."CONFIG_INFO" ON;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO" OFF;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO_AGGR" ON;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO_AGGR" OFF;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO_BETA" ON;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO_BETA" OFF;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO_TAG" ON;
SET IDENTITY_INSERT "NACOS"."CONFIG_INFO_TAG" OFF;
SET IDENTITY_INSERT "NACOS"."CONFIG_TAGS_RELATION" ON;
SET IDENTITY_INSERT "NACOS"."CONFIG_TAGS_RELATION" OFF;
SET IDENTITY_INSERT "NACOS"."GROUP_CAPACITY" ON;
SET IDENTITY_INSERT "NACOS"."GROUP_CAPACITY" OFF;
SET IDENTITY_INSERT "NACOS"."HIS_CONFIG_INFO" ON;
SET IDENTITY_INSERT "NACOS"."HIS_CONFIG_INFO" OFF;
INSERT INTO "NACOS"."ROLES"("USERNAME","ROLE") VALUES('nacos','ROLE_ADMIN');

SET IDENTITY_INSERT "NACOS"."TENANT_CAPACITY" ON;
SET IDENTITY_INSERT "NACOS"."TENANT_CAPACITY" OFF;
SET IDENTITY_INSERT "NACOS"."TENANT_INFO" ON;
SET IDENTITY_INSERT "NACOS"."TENANT_INFO" OFF;
INSERT INTO "NACOS"."USERS"("USERNAME","PASSWORD","ENABLED") VALUES('nacos','$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu',1);

ALTER TABLE "NACOS"."USERS" ADD CONSTRAINT  PRIMARY KEY("USERNAME") ;

ALTER TABLE "NACOS"."TENANT_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."TENANT_INFO" ADD CONSTRAINT "UK_TENANT_INFO_KPTENANTID" UNIQUE("KP","TENANT_ID") ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CONSTRAINT "UK_TENANT_ID" UNIQUE("TENANT_ID") ;

ALTER TABLE "NACOS"."ROLES" ADD CONSTRAINT "IDX_USER_ROLE" UNIQUE("USERNAME","ROLE") ;

ALTER TABLE "NACOS"."PERMISSIONS" ADD CONSTRAINT "UK_ROLE_PERMISSION" UNIQUE("ROLE","RESOURCE","ACTION") ;

ALTER TABLE "NACOS"."HIS_CONFIG_INFO" ADD CONSTRAINT  PRIMARY KEY("NID") ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CONSTRAINT "UK_GROUP_ID" UNIQUE("GROUP_ID") ;

ALTER TABLE "NACOS"."CONFIG_TAGS_RELATION" ADD CONSTRAINT  PRIMARY KEY("NID") ;

ALTER TABLE "NACOS"."CONFIG_TAGS_RELATION" ADD CONSTRAINT "UK_CONFIGTAGRELATION_CONFIGIDTAG" UNIQUE("ID","TAG_NAME","TAG_TYPE") ;

ALTER TABLE "NACOS"."CONFIG_INFO_TAG" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO_TAG" ADD CONSTRAINT "UK_CONFIGINFOTAG_DATAGROUPTENANTTAG" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID","TAG_ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO_BETA" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO_BETA" ADD CONSTRAINT "UK_CONFIGINFOBETA_DATAGROUPTENANT" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO_AGGR" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO_AGGR" ADD CONSTRAINT "UK_CONFIGINFOAGGR_DATAGROUPTENANTDATUM" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID","DATUM_ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "NACOS"."CONFIG_INFO" ADD CONSTRAINT "UK_CONFIGINFO_DATAGROUPTENANT" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID") ;

CREATE UNIQUE INDEX "PRIMARY"
ON "NACOS"."USERS"("USERNAME");

CREATE INDEX "IDX_TENANT_ID"
ON "NACOS"."TENANT_INFO"("TENANT_ID");

CREATE UNIQUE INDEX "INDEX9923971612000"
ON "NACOS"."TENANT_INFO"("ID");

COMMENT ON TABLE "NACOS"."TENANT_INFO" IS 'tenant_info';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."ID" IS 'id';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."KP" IS 'kp';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."TENANT_ID" IS 'tenant_id';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."TENANT_NAME" IS 'tenant_name';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."TENANT_DESC" IS 'tenant_desc';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."CREATE_SOURCE" IS 'create_source';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."GMT_CREATE" IS '创建时间';

COMMENT ON COLUMN "NACOS"."TENANT_INFO"."GMT_MODIFIED" IS '修改时间';

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CHECK ("QUOTA" >= 0) ENABLE ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CHECK ("USAGE" >= 0) ENABLE ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CHECK ("MAX_SIZE" >= 0) ENABLE ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CHECK ("MAX_AGGR_COUNT" >= 0) ENABLE ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CHECK ("MAX_AGGR_SIZE" >= 0) ENABLE ;

ALTER TABLE "NACOS"."TENANT_CAPACITY" ADD CHECK ("MAX_HISTORY_COUNT" >= 0) ENABLE ;

CREATE UNIQUE INDEX "INDEX9924026137300"
ON "NACOS"."TENANT_CAPACITY"("ID");

COMMENT ON TABLE "NACOS"."TENANT_CAPACITY" IS '租户容量信息表';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."ID" IS '主键ID';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."TENANT_ID" IS 'Tenant ID';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."USAGE" IS '使用量';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."GMT_CREATE" IS '创建时间';

COMMENT ON COLUMN "NACOS"."TENANT_CAPACITY"."GMT_MODIFIED" IS '修改时间';

ALTER TABLE "NACOS"."HIS_CONFIG_INFO" ADD CHECK ("ID" >= 0) ENABLE ;

CREATE INDEX "IDX_DID"
ON "NACOS"."HIS_CONFIG_INFO"("DATA_ID");

CREATE INDEX "IDX_GMT_CREATE"
ON "NACOS"."HIS_CONFIG_INFO"("GMT_CREATE");

CREATE INDEX "IDX_GMT_MODIFIED"
ON "NACOS"."HIS_CONFIG_INFO"("GMT_MODIFIED");

CREATE UNIQUE INDEX "INDEX9924082513700"
ON "NACOS"."HIS_CONFIG_INFO"("NID");

COMMENT ON TABLE "NACOS"."HIS_CONFIG_INFO" IS '多租户改造';

COMMENT ON COLUMN "NACOS"."HIS_CONFIG_INFO"."APP_NAME" IS 'app_name';

COMMENT ON COLUMN "NACOS"."HIS_CONFIG_INFO"."TENANT_ID" IS '租户字段';

COMMENT ON COLUMN "NACOS"."HIS_CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '秘钥';

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CHECK ("QUOTA" >= 0) ENABLE ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CHECK ("USAGE" >= 0) ENABLE ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CHECK ("MAX_SIZE" >= 0) ENABLE ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CHECK ("MAX_AGGR_COUNT" >= 0) ENABLE ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CHECK ("MAX_AGGR_SIZE" >= 0) ENABLE ;

ALTER TABLE "NACOS"."GROUP_CAPACITY" ADD CHECK ("MAX_HISTORY_COUNT" >= 0) ENABLE ;

CREATE UNIQUE INDEX "INDEX9924103518700"
ON "NACOS"."GROUP_CAPACITY"("ID");

COMMENT ON TABLE "NACOS"."GROUP_CAPACITY" IS '集群、各Group容量信息表';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."ID" IS '主键ID';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."GROUP_ID" IS 'Group ID，空字符表示整个集群';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."USAGE" IS '使用量';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数，，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."GMT_CREATE" IS '创建时间';

COMMENT ON COLUMN "NACOS"."GROUP_CAPACITY"."GMT_MODIFIED" IS '修改时间';

CREATE INDEX "INDEX9924120794600"
ON "NACOS"."CONFIG_TAGS_RELATION"("TENANT_ID");

CREATE UNIQUE INDEX "INDEX9924125027600"
ON "NACOS"."CONFIG_TAGS_RELATION"("NID");

COMMENT ON TABLE "NACOS"."CONFIG_TAGS_RELATION" IS 'config_tag_relation';

COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."ID" IS 'id';

COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."TAG_NAME" IS 'tag_name';

COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."TAG_TYPE" IS 'tag_type';

COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."DATA_ID" IS 'data_id';

COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."GROUP_ID" IS 'group_id';

COMMENT ON COLUMN "NACOS"."CONFIG_TAGS_RELATION"."TENANT_ID" IS 'tenant_id';

CREATE UNIQUE INDEX "INDEX9924136691600"
ON "NACOS"."CONFIG_INFO_TAG"("ID");

COMMENT ON TABLE "NACOS"."CONFIG_INFO_TAG" IS 'config_info_tag';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."ID" IS 'id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."DATA_ID" IS 'data_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."GROUP_ID" IS 'group_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."TENANT_ID" IS 'tenant_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."TAG_ID" IS 'tag_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."APP_NAME" IS 'app_name';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."CONTENT" IS 'content';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."MD5" IS 'md5';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."GMT_CREATE" IS '创建时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."GMT_MODIFIED" IS '修改时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."SRC_USER" IS 'source user';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_TAG"."SRC_IP" IS 'source ip';

CREATE UNIQUE INDEX "INDEX9924155372600"
ON "NACOS"."CONFIG_INFO_BETA"("ID");

COMMENT ON TABLE "NACOS"."CONFIG_INFO_BETA" IS 'config_info_beta';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."ID" IS 'id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."DATA_ID" IS 'data_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."GROUP_ID" IS 'group_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."APP_NAME" IS 'app_name';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."CONTENT" IS 'content';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."BETA_IPS" IS 'betaIps';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."MD5" IS 'md5';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."GMT_CREATE" IS '创建时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."GMT_MODIFIED" IS '修改时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."SRC_USER" IS 'source user';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."SRC_IP" IS 'source ip';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."TENANT_ID" IS '租户字段';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_BETA"."ENCRYPTED_DATA_KEY" IS '秘钥';

CREATE UNIQUE INDEX "INDEX9924171786100"
ON "NACOS"."CONFIG_INFO_AGGR"("ID");

COMMENT ON TABLE "NACOS"."CONFIG_INFO_AGGR" IS '增加租户字段';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."ID" IS 'id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."DATA_ID" IS 'data_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."GROUP_ID" IS 'group_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."DATUM_ID" IS 'datum_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."CONTENT" IS '内容';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."GMT_MODIFIED" IS '修改时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO_AGGR"."TENANT_ID" IS '租户字段';

CREATE UNIQUE INDEX "INDEX9924183274900"
ON "NACOS"."CONFIG_INFO"("ID");

COMMENT ON TABLE "NACOS"."CONFIG_INFO" IS 'config_info';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."ID" IS 'id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."DATA_ID" IS 'data_id';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."CONTENT" IS 'content';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."MD5" IS 'md5';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."GMT_CREATE" IS '创建时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."GMT_MODIFIED" IS '修改时间';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."SRC_USER" IS 'source user';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."SRC_IP" IS 'source ip';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."TENANT_ID" IS '租户字段';

COMMENT ON COLUMN "NACOS"."CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '秘钥';

4. 启动服务

docker-compose up -d

docker logs -f nacos

其他：

达梦数据库的安装：DM8 docker

Docker 安装 | 达梦技术文档

注意： 1. 镜像版本 v2.2.0 

            2. jar包版本  DmJdbcDriver18-8.1.2.79.jar

版本不对，可能导致服务起不起来，或者 添加配置不成功，尽量就用这个配置吧。

weixin_38155822
关注
  • 4
    点赞
  • 踩
  • 11
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
专栏目录
Nacos适配达梦数据库
04-14
这是编译出来的nacos达梦版https://blog.csdn.net/pky86676022/article/details/137726884
nacos-server-2.1.1 适配达梦数据库
09-29
该版本根据nacos源码调整后适配达梦数据库 ，支持windows linux 支持多数据源配置，默认连接mysql。如果需要连接oracle、dm8 等，需要更改配置文件 打开\nacos\conf\application.properties,修改如下： spring....
Nacos适配达梦数据库8
这里是火火火的世界
04-13 1547
从2.2.0版本开始，nacos可通过SPI机制注入多数据源实现插件,并在引入对应数据源实现后,便可在Nacos启动时通过读取application.properties配置文件中spring.datasource.platform配置项选择加载对应多数据源插件。
docker安装nacos
热门推荐
qq_27615455的博客
06-07 5万+
SpringCloudAlibaba实战教程系列阿里巴巴Nacos官方文档docker命令大全docker：官网 中文官网docker：镜像官网：镜像官网可以所有应用，选择安装环境：会给出安装命令，例如：docker pull redis 默认拉取最新的版本(指定版本：docker pull redis:5.0.8) --------------------------目录------------------------------------一、docker简单安装nacos、使用默认的Derby数
docker部署nacos保姆级教程
最新发布
a1468660798的博客
04-29 1138
Nacos是阿里巴巴开源的一款服务发现、配置管理和服务管理平台。它支持多种注册中心和配置中心的实现，可以帮助开发者快速构建微服务架构。
nacos适配达梦数据库
yy1209357299的博客
03-14 5685
1、nacos源码 地址：https://github.com/alibaba/nacos/releases/tag/1.4.1 2、修改主pom.xml 引入dm包 3、修改console下的配置文件 spring.datasource.platform=dm ### Count of DB: db.num=1 db.jdbcDriverName=dm.jdbc.driver.DmDriver ### Connect URL of DB: db.url.0=jdbc:dm://ip:5236/N
【Docker】Nacos的单机部署及集群部署
无法自律的人的博客
01-18 2271
Nacos是一个更易于构建云原生应用的动态服务发现、配置管理和服务管理平台。
在docker中安装Nacos--详细教程
xtldcn的博客
02-03 2万+
docker容器安装数据库和nacos的从0到使用的步骤详解
nacos2.2.0适配DM达梦数据库源码
04-27
nacos2.2.0适配DM达梦数据库源码
nacos2.2.1达梦数据库版
06-08
支持达梦数据库配置持久化带数据库初始化sql脚本，原nacos版本只支持mysql与derby数据库配置持久化，不支持达梦数据库配置持久化。在原有的开源nacos上进行了源码更改，解决了网上教程的一些坑，测试持久化成功后...
达梦数据库驱动18-8.1.2.79，用户数据库连接
07-06
达梦数据库驱动18-8.1.2.79，用户数据库连接
nacos适配达梦数据源
02-22
nacos适配达梦数据源，包含window linux版可直接使用，包含源码部分可自行修改内容自行编译。可导入idea自行编译，已编译好可直接使用的从nacos-2.1.2\distribution\target拷贝使用内含脚本sql文件自行导入达梦数据库
DmJdbcDriver18.jar 达梦数据库 win10 64位下载 达梦数据库驱动包DmJdbcDriver18.jar
09-21
达梦数据库 win10 64位下载。达梦数据库驱动包DmJdbcDriver18.jar，全网最好用的驱动包。
nacos2.1.0版本-达梦数据库-linux
09-30
nacos2.1.0版本-达梦数据库-linux
达梦8数据驱动下载 DmJdbcDriver18
06-20
包含 DmJdbcDriver16.jar、DmJdbcDriver17.jar、DmJdbcDriver18.jar、dm8-oracle-jdbc16-wrapper.jar 以及配置说明
Nacos2.1.2适配达梦8数据库
10-21
nacos2.1.2修复上一个版本中注册服务...增加国产数据库达梦8的适配 需在conf/application.properties 文件中更新数据库配置，配置如下： db.jdbcDriverName=dm.jdbc.driver.DmDriver db.url.0=jdbc:dm://127.0.0.1:5236
使用Docker安装部署Nacos，Spring Boot项目使用Nacos作为配置中心
ManGooo0的博客
03-31 2142
我的springboot版本是2.6.4,而springcloud版本是Hoxton.RELEASE。查看mvnrepository，将springcloud改成2021.0.1版本后重新启动项目。项目启动失败，并且没有启动日志，如果把nacos的依赖注释就可以启动。在Nacos管理界面的服务列表中可以看到注册的服务。在配置文件添加nacos服务地址。进入到启动的naocs容器中。在模块的pom文件中引入依赖。在项目的启动类添加注解。查看nacos镜像。启动naocs镜像。进入管理界面，成功。
nacos2.2.3多数据源适配，包括对达梦、kingbase等国产数据库适配
Ice166的博客
01-03 2563
主要是为了信创，需要各种开源组件以及自身开发的产品对国产环境进行验证，其中最重要的一环就是国产数据库的适配，在借鉴了各位大佬的文章以及查阅了无数国产数据库官方文档之后，最后整理出了一版兼容以上数据库的案例，本人已经测试过了，完美运行。整理不易，望诸君高台贵手，点赞支持。 版本 nacos：2.2.3 nacos源码下载什么的在这里就不做赘述了，直接github下载的，数据库版本也没多大限制，只要能跑脚本的一般都没啥问题
docker 按照nacos 适配达梦数据库
09-03
要将Docker与Nacos适配达梦数据库，我们可以采取以下步骤： 1. 在Docker中下载并安装Nacos镜像。可以使用Docker Hub上的官方Nacos镜像，该镜像提供了可用于适配不同数据库的配置选项。 2. 配置Nacos连接达梦数据库。编辑Nacos的配置文件nacos/conf/application.properties，在该文件中找到数据库相关配置项，如`spring.datasource.url`、`spring.datasource.username`、`spring.datasource.password`等，将其按照达梦数据库的连接信息进行相应修改。 3. 构建并启动Nacos容器。使用Docker命令行工具，执行类似以下命令来构建并启动Nacos容器： ``` docker run -d -p 8848:8848 --name nacos-server \ -e MODE=standalone \ -e MYSQL_SERVICE_HOST=<数据库主机地址> \ -e MYSQL_SERVICE_PORT=<数据库端口> \ -e MYSQL_SERVICE_DB_NAME=<数据库名称> \ -e MYSQL_SERVICE_USER=<数据库用户名> \ -e MYSQL_SERVICE_PASSWORD=<数据库密码> \ --restart=always \ nacos/nacos-server:latest ``` 替换<数据库主机地址>、<数据库端口>、<数据库名称>、<数据库用户名>、<数据库密码>为实际达梦数据库的信息。 4. 确认Nacos容器已成功启动。使用Docker命令行工具执行以下命令来查看容器状态： ``` docker ps ``` 如果容器状态为Up，则表示Nacos容器已成功运行。 5. 启动达梦数据库。确保达梦数据库已成功启动，并且Nacos容器可以连接到达梦数据库。可以使用数据库客户端验证连接信息是否正确。 6. 访问Nacos管理界面。在浏览器中输入Nacos容器所在主机的IP地址和端口号（默认为8848），访问Nacos的管理界面。在界面中可以配置和管理Nacos的服务、配置等。 通过以上步骤，我们可以在Docker中适配Nacos和达梦数据库实现服务注册和配置管理。这样，我们就可以使用Docker来构建和管理基于Nacos和达梦数据库的应用程序。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值