自学Nocas集群搭建
新建数据库以及导入相应的表
CREATE TABLE config_info
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id
varchar(255) NOT NULL COMMENT ‘data_id’,
group_id
varchar(255) DEFAULT NULL,
content
longtext NOT NULL COMMENT ‘content’,
md5
varchar(32) DEFAULT NULL COMMENT ‘md5’,
gmt_create
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
gmt_modified
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘修改时间’,
src_user
text COMMENT ‘source user’,
src_ip
varchar(50) DEFAULT NULL COMMENT ‘source ip’,
app_name
varchar(128) DEFAULT NULL,
tenant_id
varchar(128) DEFAULT ‘’ COMMENT ‘租户字段’,
c_desc
varchar(256) DEFAULT NULL,
c_use
varchar(64) DEFAULT NULL,
effect
varchar(64) DEFAULT NULL,
type
varchar(64) DEFAULT NULL,
c_schema
text,
PRIMARY KEY (id
),
UNIQUE KEY uk_configinfo_datagrouptenant
(data_id
,group_id
,tenant_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘config_info’;
CREATE TABLE config_info_aggr
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id
varchar(255) NOT NULL COMMENT ‘data_id’,
group_id
varchar(255) NOT NULL COMMENT ‘group_id’,
datum_id
varchar(255) NOT NULL COMMENT ‘datum_id’,
content
longtext NOT NULL COMMENT ‘内容’,
gmt_modified
datetime NOT NULL COMMENT ‘修改时间’,
app_name
varchar(128) DEFAULT NULL,
tenant_id
varchar(128) DEFAULT ‘’ COMMENT ‘租户字段’,
PRIMARY KEY (id
),
UNIQUE KEY uk_configinfoaggr_datagrouptenantdatum
(data_id
,group_id
,tenant_id
,datum_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘增加租户字段’;
//
/ 数据库全名 = nacos_config /
/ 表名称 = config_info_beta /
//
CREATE TABLE config_info_beta
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id
varchar(255) NOT NULL COMMENT ‘data_id’,
group_id
varchar(128) NOT NULL COMMENT ‘group_id’,
app_name
varchar(128) DEFAULT NULL COMMENT ‘app_name’,
content
longtext NOT NULL COMMENT ‘content’,
beta_ips
varchar(1024) DEFAULT NULL COMMENT ‘betaIps’,
md5
varchar(32) DEFAULT NULL COMMENT ‘md5’,
gm