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

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

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

  • 4
    点赞
  • 11
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
要将DockerNacos适配达梦数据库,我们可以采取以下步骤: 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、付费专栏及课程。

余额充值