Nacos 适配达梦数据源

最近为了适配国产化改造，接到一个需求，需要把我们应用的数据源都切换成达梦，其中就涉及对 Nacos 适配达梦数据源的改造，此篇文章记录我的改造过程。

前提

为了避免不一致或者不兼容，我使用的 Nacos 版本为 2.4.2，在 Nacos 官网的多数据源章节中有提到：

Nacos 从 2.2.0 版本开始，可通过 SPI 机制注入多数据源实现插件，并在引入对应数据源实现后，便可在Nacos启动时通过读取application.properties配置文件中spring.datasource.platform配置项选择加载对应多数据源插件。

在 2.2.0 之前的版本，所有的 SQL 操作的执行是通过直接使用 JdbcTemplate 执行固定SQL语句的形式，使得 SQL 语句与业务逻辑高度耦合，并且只支持 Derby 与 MySQL 两种数据源，而 2.2.0 之后的版本，通过 SPI 机制，将原有的操作抽象成多个接口，我们可以按照自己要用的数据源去实现这些接口并编写对应的 SQL 方言，默认的插件提供 Derby 以及 MySQL 的 Mapper 实现，我们模仿这些默认的插件去实现我们的插件。

实现

1. 下载 Nacos 源码

git clone github.com/alibaba/nac…

对 nacos-all 整个项目进行 clean & install

2. 添加依赖

在 nacos-all 的父 Pom 下引入达梦的依赖

<properties>
  <dm.version>8.1.2.79</dm.version>
</properties>

<dependencyManagement>
  <dependencies>
    <dependency>
      <groupId>com.dameng</groupId>
        <artifactId>DmJdbcDriver18</artifactId>
        <version>${dm.version}</version>
    </dependency>
  </dependencies>
</dependencyManagement>

接着分别在 common、config、naming 模块下引入

<dependencies>
  <dependency>
      <groupId>com.dameng</groupId>
      <artifactId>DmJdbcDriver18</artifactId>
  </dependency>
</dependencies>

3. 修改源代码

3.1. 修改 DataSourceConstant

com.alibaba.nacos.plugin.datasource.constants.DataSourceConstant

添加 public static final String DM = "dm";

public class DataSourceConstant {
    public static final String MYSQL = "mysql";
    
    public static final String DERBY = "derby";

    public static final String DM = "dm";
}

3.2. 修改 PersistenceConstant

com.alibaba.nacos.persistence.constants.PersistenceConstant

添加 public static final String DM = "dm";

package com.alibaba.nacos.persistence.constants;

public class PersistenceConstant {
    
    public static final String DEFAULT_ENCODE = "UTF-8";
    
    /**
     * May be removed with the upgrade of springboot version.
     */
    public static final String DATASOURCE_PLATFORM_PROPERTY_OLD = "spring.datasource.platform";
    
    public static final String DATASOURCE_PLATFORM_PROPERTY = "spring.sql.init.platform";
    
    public static final String MYSQL = "mysql";
    
    public static final String DERBY = "derby";

    public static final String DM = "dm";
    
    public static final String EMPTY_DATASOURCE_PLATFORM = "";
    
    public static final String EMBEDDED_STORAGE = "embeddedStorage";
    
    /**
     * The derby base dir.
     */
    public static final String DERBY_BASE_DIR = "derby-data";
    
    /**
     * Specifies that reads wait without timeout.
     */
    public static final String EXTEND_NEED_READ_UNTIL_HAVE_DATA = "00--0-read-join-0--00";
    
    public static final String CONFIG_MODEL_RAFT_GROUP = "nacos_config";
    
}

3.3. 新增 TrustedDmFunctionEnum

com.alibaba.nacos.plugin.datasource.enums

在这个路径下，我们新建一个 dm 包，并复制 mysql 包下的 TrustedMysqlFunctionEnum 到 dm 包下，更名为 TrustedDmFunctionEnum

package com.alibaba.nacos.plugin.datasource.enums.dm;

import java.util.HashMap;
import java.util.Map;

public enum TrustedDmFunctionEnum {

    /**
     * NOW().
     */
    NOW("NOW()", "NOW(3)");

    private static final Map<String, TrustedDmFunctionEnum> LOOKUP_MAP = new HashMap<>();

    static {
        for (TrustedDmFunctionEnum entry : TrustedDmFunctionEnum.values()) {
            LOOKUP_MAP.put(entry.functionName, entry);
        }
    }

    private final String functionName;

    private final String function;

    TrustedDmFunctionEnum(String functionName, String function) {
        this.functionName = functionName;
        this.function = function;
    }

    /**
     * Get the function name.
     *
     * @param functionName function name
     * @return function
     */
    public static String getFunctionByName(String functionName) {
        TrustedDmFunctionEnum entry = LOOKUP_MAP.get(functionName);
        if (entry != null) {
            return entry.function;
        }
        throw new IllegalArgumentException(String.format("Invalid function name: %s", functionName));
    }
}

3.4. 实现 Mapper 接口

com.alibaba.nacos.plugin.datasource.impl

在这里我们可以模仿 mysql 包下的实现，新建一个 dm 包，并复制 mysql 包下的 AbstractMapperByMysql、ConfigInfoAggrMapperByMySql、ConfigInfoBetaMapperByMySql、ConfigInfoMapperByMySql、ConfigInfoTagMapperByMySql、ConfigTagsRelationMapperByMySql、GroupCapacityMapperByMysql、HistoryConfigInfoMapperByMySql、TenantCapacityMapperByMySql、TenantInfoMapperByMySql 到 dm 包下，并更名为 AbstractMapperByDm、ConfigInfoAggrMapperByDm、ConfigInfoBetaMapperByDm、ConfigInfoMapperByDm、ConfigInfoTagMapperByDm、ConfigTagsRelationMapperByDm、GroupCapacityMapperByDm、HistoryConfigInfoMapperByDm、TenantCapacityMapperByDm、TenantInfoMapperByDm

1. 修改 AbstractMapperByDm 的 getFunction 方法

package com.alibaba.nacos.plugin.datasource.impl.dm;

import com.alibaba.nacos.plugin.datasource.enums.dm.TrustedDmFunctionEnum;
import com.alibaba.nacos.plugin.datasource.mapper.AbstractMapper;

public abstract class AbstractMapperByDm extends AbstractMapper {

    @Override
    public String getFunction(String functionName) {
        return TrustedDmFunctionEnum.getFunctionByName(functionName);
    }
}

2. 修改所有 Mapper 实现的 getDataSource 方法

public String getDataSource() {
    return DataSourceConstant.DM;
}

3.5. 修改 com.alibaba.nacos.plugin.datasource.mapper.Mapper

META-INF/services/com.alibaba.nacos.plugin.datasource.mapper.Mapper

com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoAggrMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoBetaMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoTagMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigTagsRelationMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.HistoryConfigInfoMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.TenantInfoMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.TenantCapacityMapperByDm
com.alibaba.nacos.plugin.datasource.impl.dm.GroupCapacityMapperByDm

com.alibaba.nacos.plugin.datasource.impl.mysql.ConfigInfoAggrMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.ConfigInfoBetaMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.ConfigInfoMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.ConfigInfoTagMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.ConfigTagsRelationMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.HistoryConfigInfoMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.TenantInfoMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.TenantCapacityMapperByMySql
com.alibaba.nacos.plugin.datasource.impl.mysql.GroupCapacityMapperByMysql

com.alibaba.nacos.plugin.datasource.impl.derby.ConfigInfoAggrMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.ConfigInfoBetaMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.ConfigInfoMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.ConfigInfoTagMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.ConfigInfoTagsRelationMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.HistoryConfigInfoMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.TenantInfoMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.TenantCapacityMapperByDerby
com.alibaba.nacos.plugin.datasource.impl.derby.GroupCapacityMapperByDerby

3.6. 新增 DmPageHandlerAdapter

com.alibaba.nacos.plugin.auth.impl.persistence.handler.support

在该目录新建 DmPageHandlerAdapter 类

package com.alibaba.nacos.plugin.auth.impl.persistence.handler.support;

import com.alibaba.nacos.persistence.constants.PersistenceConstant;
import com.alibaba.nacos.plugin.auth.impl.constant.AuthPageConstant;
import com.alibaba.nacos.plugin.auth.impl.model.OffsetFetchResult;
import com.alibaba.nacos.plugin.auth.impl.persistence.handler.PageHandlerAdapter;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

public class DmPageHandlerAdapter implements PageHandlerAdapter {
  
    @Override  
    public boolean supports(String dataSourceType) {  
        return PersistenceConstant.DM.equals(dataSourceType);
    }  
  
    @Override  
    public OffsetFetchResult addOffsetAndFetchNext(String fetchSql, Object[] arg, int pageNo, int pageSize) {
        if (!fetchSql.contains(AuthPageConstant.LIMIT)) {
            fetchSql += " " + AuthPageConstant.LIMIT_SIZE;  
            List<Object> newArgsList = new ArrayList<>(Arrays.asList(arg));
            newArgsList.add((pageNo - 1) * pageSize);  
            newArgsList.add(pageSize);  
  
            Object[] newArgs = newArgsList.toArray(new Object[0]);  
            return new OffsetFetchResult(fetchSql, newArgs);  
        }  
  
        return new OffsetFetchResult(fetchSql, arg);  
    }  
  
}

3.7. 修改 PageHandlerAdapterFactory

com.alibaba.nacos.plugin.auth.impl.persistence.handler.PageHandlerAdapterFactory

添加 DM 的适配器 addHandlerAdapter.accept(new DmPageHandlerAdapter());

package com.alibaba.nacos.plugin.auth.impl.persistence.handler;

import com.alibaba.nacos.plugin.auth.impl.persistence.handler.support.DefaultPageHandlerAdapter;
import com.alibaba.nacos.plugin.auth.impl.persistence.handler.support.DerbyPageHandlerAdapter;
import com.alibaba.nacos.plugin.auth.impl.persistence.handler.support.DmPageHandlerAdapter;
import com.alibaba.nacos.plugin.auth.impl.persistence.handler.support.MysqlPageHandlerAdapter;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Collections;
import java.util.function.Consumer;

public class PageHandlerAdapterFactory {

    private final List<PageHandlerAdapter> handlerAdapters;

    private final Map<String, PageHandlerAdapter> handlerAdapterMap;

    public List<PageHandlerAdapter> getHandlerAdapters() {
        return handlerAdapters;
    }

    public Map<String, PageHandlerAdapter> getHandlerAdapterMap() {
        return handlerAdapterMap;
    }

    private PageHandlerAdapterFactory() {
        List<PageHandlerAdapter> handlerAdapters = new ArrayList<>(3);
        Map<String, PageHandlerAdapter> handlerAdapterMap = new HashMap<>(3);
        Consumer<PageHandlerAdapter> addHandlerAdapter = handlerAdapter -> {
            handlerAdapters.add(handlerAdapter);
            handlerAdapterMap.put(handlerAdapter.getClass().getName(), handlerAdapter);
        };
        // DmPageHandlerAdapter
        addHandlerAdapter.accept(new DmPageHandlerAdapter());
        // MysqlPageHandlerAdapter
        addHandlerAdapter.accept(new MysqlPageHandlerAdapter());
        // DerbyPageHandlerAdapter
        addHandlerAdapter.accept(new DerbyPageHandlerAdapter());
        // DefaultPageHandlerAdapter
        addHandlerAdapter.accept(new DefaultPageHandlerAdapter());
        this.handlerAdapters = Collections.unmodifiableList(handlerAdapters);
        this.handlerAdapterMap = Collections.unmodifiableMap(handlerAdapterMap);
    }

    private static final class InstanceHolder {
        static final PageHandlerAdapterFactory INSTANCE = new PageHandlerAdapterFactory();
    }

    public static PageHandlerAdapterFactory getInstance() {
        return InstanceHolder.INSTANCE;
    }

}

3.8. 修改 ExternalDataSourceProperties

com/alibaba/nacos/persistence/datasource/ExternalDataSourceProperties.java

1. 新增 jdbcDriverName 属性

private List<String> jdbcDriverName = new ArrayList<>();

public List<String> getJdbcDriverName() {
    return jdbcDriverName;
}

public void setJdbcDriverName(List<String> jdbcDriverName) {
    this.jdbcDriverName = jdbcDriverName;
}

2. 修改 build 方法

修改 for 循环中的 if 判断

if (StringUtils.isEmpty(poolProperties.getDataSource().getDriverClassName())) {
    poolProperties.setDriverClassName(getOrDefault(jdbcDriverName, index, jdbcDriverName.get(index)).trim());
    //poolProperties.setDriverClassName(JDBC_DRIVER_NAME);
}

4. 调试

1. 新建 NACOS 数据库，并创建对应的表结构

CREATE TABLE "USERS"  
(  
 "USERNAME" VARCHAR(50) NOT NULL,  
 "PASSWORD" VARCHAR(500) NOT NULL,  
 "ENABLED" TINYINT NOT NULL  
);  
  
CREATE TABLE "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 "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 "ROLES"  
(  
 "USERNAME" VARCHAR(50) NOT NULL,  
 "ROLE" VARCHAR(50) NOT NULL  
);  
  
CREATE TABLE "PERMISSIONS"  
(  
 "ROLE" VARCHAR(50) NOT NULL,  
 "RESOURCE" VARCHAR(255) NOT NULL,  
 "ACTION" VARCHAR(8) NOT NULL  
);  
  
CREATE TABLE "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 "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 "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 "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 "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 "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 "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 "CONFIG_INFO" ON;  
SET IDENTITY_INSERT "CONFIG_INFO" OFF;  
SET IDENTITY_INSERT "CONFIG_INFO_AGGR" ON;  
SET IDENTITY_INSERT "CONFIG_INFO_AGGR" OFF;  
SET IDENTITY_INSERT "CONFIG_INFO_BETA" ON;  
SET IDENTITY_INSERT "CONFIG_INFO_BETA" OFF;  
SET IDENTITY_INSERT "CONFIG_INFO_TAG" ON;  
SET IDENTITY_INSERT "CONFIG_INFO_TAG" OFF;  
SET IDENTITY_INSERT "CONFIG_TAGS_RELATION" ON;  
SET IDENTITY_INSERT "CONFIG_TAGS_RELATION" OFF;  
SET IDENTITY_INSERT "GROUP_CAPACITY" ON;  
SET IDENTITY_INSERT "GROUP_CAPACITY" OFF;  
SET IDENTITY_INSERT "HIS_CONFIG_INFO" ON;  
SET IDENTITY_INSERT "HIS_CONFIG_INFO" OFF;  
INSERT INTO "ROLES"("USERNAME","ROLE") VALUES('nacos','ROLE_ADMIN');  
  
SET IDENTITY_INSERT "TENANT_CAPACITY" ON;  
SET IDENTITY_INSERT "TENANT_CAPACITY" OFF;  
SET IDENTITY_INSERT "TENANT_INFO" ON;  
SET IDENTITY_INSERT "TENANT_INFO" OFF;  
INSERT INTO "USERS"("USERNAME","PASSWORD","ENABLED") VALUES('nacos','$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu',1);  
  
ALTER TABLE "USERS" ADD CONSTRAINT  PRIMARY KEY("USERNAME") ;  
  
ALTER TABLE "TENANT_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "TENANT_INFO" ADD CONSTRAINT "UK_TENANT_INFO_KPTENANTID" UNIQUE("KP","TENANT_ID") ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CONSTRAINT "UK_TENANT_ID" UNIQUE("TENANT_ID") ;  
  
ALTER TABLE "ROLES" ADD CONSTRAINT "IDX_USER_ROLE" UNIQUE("USERNAME","ROLE") ;  
  
ALTER TABLE "PERMISSIONS" ADD CONSTRAINT "UK_ROLE_PERMISSION" UNIQUE("ROLE","RESOURCE","ACTION") ;  
  
ALTER TABLE "HIS_CONFIG_INFO" ADD CONSTRAINT  PRIMARY KEY("NID") ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CONSTRAINT "UK_GROUP_ID" UNIQUE("GROUP_ID") ;  
  
ALTER TABLE "CONFIG_TAGS_RELATION" ADD CONSTRAINT  PRIMARY KEY("NID") ;  
  
ALTER TABLE "CONFIG_TAGS_RELATION" ADD CONSTRAINT "UK_CONFIGTAGRELATION_CONFIGIDTAG" UNIQUE("ID","TAG_NAME","TAG_TYPE") ;  
  
ALTER TABLE "CONFIG_INFO_TAG" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "CONFIG_INFO_TAG" ADD CONSTRAINT "UK_CONFIGINFOTAG_DATAGROUPTENANTTAG" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID","TAG_ID") ;  
  
ALTER TABLE "CONFIG_INFO_BETA" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "CONFIG_INFO_BETA" ADD CONSTRAINT "UK_CONFIGINFOBETA_DATAGROUPTENANT" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID") ;  
  
ALTER TABLE "CONFIG_INFO_AGGR" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "CONFIG_INFO_AGGR" ADD CONSTRAINT "UK_CONFIGINFOAGGR_DATAGROUPTENANTDATUM" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID","DATUM_ID") ;  
  
ALTER TABLE "CONFIG_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;  
  
ALTER TABLE "CONFIG_INFO" ADD CONSTRAINT "UK_CONFIGINFO_DATAGROUPTENANT" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID") ;  
  
CREATE UNIQUE INDEX "PRIMARY"  
ON "USERS"("USERNAME");  
  
COMMENT ON COLUMN "USERS"."USERNAME" IS 'username';  
  
COMMENT ON COLUMN "USERS"."PASSWORD" IS 'password';  
  
COMMENT ON COLUMN "USERS"."ENABLED" IS 'enabled';  
  
CREATE INDEX "IDX_TENANT_ID"  
ON "TENANT_INFO"("TENANT_ID");  
  
CREATE UNIQUE INDEX "INDEX134402165964299"  
ON "TENANT_INFO"("ID");  
  
COMMENT ON TABLE "TENANT_INFO" IS 'tenant_info';  
  
COMMENT ON COLUMN "TENANT_INFO"."ID" IS 'id';  
  
COMMENT ON COLUMN "TENANT_INFO"."KP" IS 'kp';  
  
COMMENT ON COLUMN "TENANT_INFO"."TENANT_ID" IS 'tenant_id';  
  
COMMENT ON COLUMN "TENANT_INFO"."TENANT_NAME" IS 'tenant_name';  
  
COMMENT ON COLUMN "TENANT_INFO"."TENANT_DESC" IS 'tenant_desc';  
  
COMMENT ON COLUMN "TENANT_INFO"."CREATE_SOURCE" IS 'create_source';  
  
COMMENT ON COLUMN "TENANT_INFO"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "TENANT_INFO"."GMT_MODIFIED" IS '修改时间';  
  
ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("QUOTA" >= 0) ENABLE ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_HISTORY_COUNT" >= 0) ENABLE ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_AGGR_SIZE" >= 0) ENABLE ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_AGGR_COUNT" >= 0) ENABLE ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_SIZE" >= 0) ENABLE ;  
  
ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("USAGE" >= 0) ENABLE ;  
  
CREATE UNIQUE INDEX "INDEX134403016796300"  
ON "TENANT_CAPACITY"("ID");  
  
COMMENT ON TABLE "TENANT_CAPACITY" IS '租户容量信息表';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."ID" IS '主键ID';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."TENANT_ID" IS 'Tenant ID';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."USAGE" IS '使用量';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "TENANT_CAPACITY"."GMT_MODIFIED" IS '修改时间';  
  
COMMENT ON COLUMN "ROLES"."USERNAME" IS 'username';  
  
COMMENT ON COLUMN "ROLES"."ROLE" IS 'role';  
  
COMMENT ON COLUMN "PERMISSIONS"."ROLE" IS 'role';  
  
COMMENT ON COLUMN "PERMISSIONS"."RESOURCE" IS 'resource';  
  
COMMENT ON COLUMN "PERMISSIONS"."ACTION" IS 'action';  
  
ALTER TABLE "HIS_CONFIG_INFO" ADD CHECK ("ID" >= 0) ENABLE ;  
  
CREATE INDEX "IDX_DID"  
ON "HIS_CONFIG_INFO"("DATA_ID");  
  
CREATE INDEX "IDX_GMT_MODIFIED"  
ON "HIS_CONFIG_INFO"("GMT_MODIFIED");  
  
CREATE INDEX "IDX_GMT_CREATE"  
ON "HIS_CONFIG_INFO"("GMT_CREATE");  
  
CREATE UNIQUE INDEX "INDEX134404266256800"  
ON "HIS_CONFIG_INFO"("NID");  
  
COMMENT ON TABLE "HIS_CONFIG_INFO" IS '多租户改造';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."ID" IS 'id';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."NID" IS 'nid, 自增标识';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."DATA_ID" IS 'data_id';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."GROUP_ID" IS 'group_id';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."APP_NAME" IS 'app_name';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."CONTENT" IS 'content';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."MD5" IS 'md5';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."GMT_MODIFIED" IS '修改时间';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."SRC_USER" IS 'source user';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."SRC_IP" IS 'source ip';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."OP_TYPE" IS 'operation type';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."TENANT_ID" IS '租户字段';  
  
COMMENT ON COLUMN "HIS_CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '密钥';  
  
ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("QUOTA" >= 0) ENABLE ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_HISTORY_COUNT" >= 0) ENABLE ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_AGGR_SIZE" >= 0) ENABLE ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_AGGR_COUNT" >= 0) ENABLE ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_SIZE" >= 0) ENABLE ;  
  
ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("USAGE" >= 0) ENABLE ;  
  
CREATE UNIQUE INDEX "INDEX134405629453900"  
ON "GROUP_CAPACITY"("ID");  
  
COMMENT ON TABLE "GROUP_CAPACITY" IS '集群、各Group容量信息表';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."ID" IS '主键ID';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."GROUP_ID" IS 'Group ID，空字符表示整个集群';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."USAGE" IS '使用量';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数，，0表示使用默认值';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "GROUP_CAPACITY"."GMT_MODIFIED" IS '修改时间';  
  
CREATE INDEX "INDEX134406418558100"  
ON "CONFIG_TAGS_RELATION"("TENANT_ID");  
  
CREATE UNIQUE INDEX "INDEX134406537578900"  
ON "CONFIG_TAGS_RELATION"("NID");  
  
COMMENT ON TABLE "CONFIG_TAGS_RELATION" IS 'config_tag_relation';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."ID" IS 'id';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TAG_NAME" IS 'tag_name';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TAG_TYPE" IS 'tag_type';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."DATA_ID" IS 'data_id';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."GROUP_ID" IS 'group_id';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TENANT_ID" IS 'tenant_id';  
  
COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."NID" IS 'nid, 自增长标识';  
  
CREATE UNIQUE INDEX "INDEX134407033963000"  
ON "CONFIG_INFO_TAG"("ID");  
  
COMMENT ON TABLE "CONFIG_INFO_TAG" IS 'config_info_tag';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."ID" IS 'id';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."DATA_ID" IS 'data_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."GROUP_ID" IS 'group_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."TENANT_ID" IS 'tenant_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."TAG_ID" IS 'tag_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."APP_NAME" IS 'app_name';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."CONTENT" IS 'content';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."MD5" IS 'md5';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."GMT_MODIFIED" IS '修改时间';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."SRC_USER" IS 'source user';  
  
COMMENT ON COLUMN "CONFIG_INFO_TAG"."SRC_IP" IS 'source ip';  
  
CREATE UNIQUE INDEX "INDEX134407798104699"  
ON "CONFIG_INFO_BETA"("ID");  
  
COMMENT ON TABLE "CONFIG_INFO_BETA" IS 'config_info_beta';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."ID" IS 'id';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."DATA_ID" IS 'data_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."GROUP_ID" IS 'group_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."APP_NAME" IS 'app_name';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."CONTENT" IS 'content';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."BETA_IPS" IS 'betaIps';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."MD5" IS 'md5';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."GMT_MODIFIED" IS '修改时间';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."SRC_USER" IS 'source user';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."SRC_IP" IS 'source ip';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."TENANT_ID" IS '租户字段';  
  
COMMENT ON COLUMN "CONFIG_INFO_BETA"."ENCRYPTED_DATA_KEY" IS '密钥';  
  
CREATE UNIQUE INDEX "INDEX134408619300900"  
ON "CONFIG_INFO_AGGR"("ID");  
  
COMMENT ON TABLE "CONFIG_INFO_AGGR" IS '增加租户字段';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."ID" IS 'id';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."DATA_ID" IS 'data_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."GROUP_ID" IS 'group_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."DATUM_ID" IS 'datum_id';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."CONTENT" IS '内容';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."GMT_MODIFIED" IS '修改时间';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."APP_NAME" IS 'app_name';  
  
COMMENT ON COLUMN "CONFIG_INFO_AGGR"."TENANT_ID" IS '租户字段';  
  
CREATE UNIQUE INDEX "INDEX134409166029299"  
ON "CONFIG_INFO"("ID");  
  
COMMENT ON TABLE "CONFIG_INFO" IS 'config_info';  
  
COMMENT ON COLUMN "CONFIG_INFO"."ID" IS 'id';  
  
COMMENT ON COLUMN "CONFIG_INFO"."DATA_ID" IS 'data_id';  
  
COMMENT ON COLUMN "CONFIG_INFO"."GROUP_ID" IS 'group_id';  
  
COMMENT ON COLUMN "CONFIG_INFO"."CONTENT" IS 'content';  
  
COMMENT ON COLUMN "CONFIG_INFO"."MD5" IS 'md5';  
  
COMMENT ON COLUMN "CONFIG_INFO"."GMT_CREATE" IS '创建时间';  
  
COMMENT ON COLUMN "CONFIG_INFO"."GMT_MODIFIED" IS '修改时间';  
  
COMMENT ON COLUMN "CONFIG_INFO"."SRC_USER" IS 'source user';  
  
COMMENT ON COLUMN "CONFIG_INFO"."SRC_IP" IS 'source ip';  
  
COMMENT ON COLUMN "CONFIG_INFO"."APP_NAME" IS 'app_name';  
  
COMMENT ON COLUMN "CONFIG_INFO"."TENANT_ID" IS '租户字段';  
  
COMMENT ON COLUMN "CONFIG_INFO"."C_DESC" IS 'configuration description';  
  
COMMENT ON COLUMN "CONFIG_INFO"."C_USE" IS 'configuration usage';  
  
COMMENT ON COLUMN "CONFIG_INFO"."EFFECT" IS '配置生效的描述';  
  
COMMENT ON COLUMN "CONFIG_INFO"."TYPE" IS '配置的类型';  
  
COMMENT ON COLUMN "CONFIG_INFO"."C_SCHEMA" IS '配置的模式';  
  
COMMENT ON COLUMN "CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '密钥';

2. 我们可以通过启动 nacos-console 模块下的 Nacos 来进行调试，修改 application.properties，新增配置项：

spring.sql.init.platform=dm
db.pool.config.driverClassName=dm.jdbc.driver.DmDriver
db.num=1
db.url.0=jdbc:dm://localhost:30236?schema=NACOS
db.user.0=SYSDBA
db.password.0=SYSDBA001

3. 添加 Nacos VM options

-Dnacos.standalone=true

tips：如果启动过程中，报程序包不存在（java: 程序包com.alibaba.nacos.consistency.entity不存在

），将那个模块重新 compile 一下。

5. 编译

执行 mvn -Prelease-nacos -Dmaven.test.skip=true -Dcheckstyle.skip=true -DskipTests -Dpmd.skip=true -Drat.skip=true clean install -U 进行编译打包

打包成功会在 nacos-distribution 模块的 target 下生成打包文件：

至此，我们的适配就完成了。

其他解决方案

github.com/nacos-group…

github.com/wuchubuzai2…

参考

nacos.io/docs/latest…

nacos.io/en/blog/faq…

www.cnblogs.com/zhoutuo/p/1…