- 拉取运行 Nacos
- 进入 nacos
- 配置nacos持久化
- 修改配置文件
- 加入在最后
- 配置 Mysql
- 重启 Nacos
docker run --name nacos -d -p 8848:8848 --privileged=true --restart=always -e JVM_XMS=256m -e JVM_XMX=512m -e MODE=standalone -e PREFER_HOST_MODE=hostname -v /home/nacos/logs:/home/nacos/logs nacos/nacos-server:2.0.3进入 nacos
sudo docker exec -it nacos bash配置nacos持久化
cd conf/修改配置文件
vim application.properties加入在最后
# db mysql spring.datasource.platform=mysql db.num=1 db.url.0=jdbc:mysql://xxx.xxx.xxx.xxx:3306/hdb-config?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC db.user=root db.password=xxxx配置 Mysql
DROp DATAbase IF EXISTS `hdb-config`;
CREATE DATAbase `hdb-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
USE `hdb-config`;
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';
insert into config_info(id, data_id, group_id, content, md5, gmt_create, gmt_modified, src_user, src_ip, app_name, tenant_id, c_desc, c_use, effect, type, c_schema) values
(1,'application-dev.yml','DEFAULT_GROUP','spring:n main:n allow-bean-definition-overriding: truen autoconfigure:n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigurenn#请求处理的超时时间nribbon:n ReadTimeout: 10000n ConnectTimeout: 10000nn# feign 配置nfeign:n sentinel:n enabled: truen okhttp:n enabled: truen httpclient:n enabled: falsen client:n config:n default:n connectTimeout: 10000n readTimeout: 10000n compression:n request:n enabled: truen response:n enabled: truenn# 暴露监控端点nmanagement:n endpoints:n web:n exposure:n include: '*'n','c07e6f7321493f6d5390d0a08bffb75a','2019-11-29 16:31:20','2020-12-21 15:29:24',NULL,'0:0:0:0:0:0:0:1','','','通用配置','null','null','yaml','null'),
(2,'hdb-gateway-dev.yml','DEFAULT_GROUP','spring:n redis:n host: localhostn port: 6379n password: n cloud:n gateway:n discovery:n locator:n lowerCaseServiceId: truen enabled: truen routes:n # 认证中心n - id: hdb-authn uri: lb://hdb-authn predicates:n - Path=/authv2/api-docsn - /csrfn','2f5a6b5a4ccf20b5801c5cf842456ec6','2020-05-14 14:17:55','2021-07-30 09:07:14',NULL,'0:0:0:0:0:0:0:1','','','网关模块','null','null','yaml','null'),
(3,'hdb-auth-dev.yml','DEFAULT_GROUP','spring: rn redis:rn host: localhostrn port: 6379rn password: rn','b7354e1eb62c2d846d44a796d9ec6930','2020-11-20 00:00:00','2021-02-28 21:06:58',NULL,'0:0:0:0:0:0:0:1','','','认证中心','null','null','yaml','null'),
(4,'hdb-monitor-dev.yml','DEFAULT_GROUP','# springrnspring: rn security:rn user:rn name: hdbrn password: 123456rn boot:rn admin:rn ui:rn title: 换电服务状态监控rn','d8997d0707a2fd5d9fc4e8409da38129','2020-11-20 00:00:00','2020-12-21 16:28:07',NULL,'0:0:0:0:0:0:0:1','','','监控中心','null','null','yaml','null'),
(5,'hdb-system-dev.yml','DEFAULT_GROUP','# spring配置rnspring: rn redis:rn host: localhostrn port: 6379rn password: rn datasource:rn druid:rn stat-view-servlet:rn enabled: truern loginUsername: adminrn loginPassword: 123456rn dynamic:rn druid:rn initial-size: 5rn min-idle: 5rn maxActive: 20rn maxWait: 60000rn timeBetweenEvictionRunsMillis: 60000rn minEvictableIdleTimeMillis: 300000rn validationQuery: SELECT 1 FROM DUALrn testWhileIdle: truern testOnBorrow: falsern testOnReturn: falsern poolPreparedStatements: truern maxPoolPreparedStatementPerConnectionSize: 20rn filters: stat,slf4jrn connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000rn datasource:rn # 主库数据源rn master:rn driver-class-name: com.mysql.cj.jdbc.Driverrn url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8rn username: rootrn password: passwordrn # 从库数据源rn # slave:rn # username: rn # password: rn # url: rn # driver-class-name: rn # seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭rnrn# seata配置rnseata:rn # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启rn enabled: falsern # Seata 应用编号，默认为 ${spring.application.name}rn application-id: ${spring.application.name}rn # Seata 事务组编号，用于 TC 集群名rn tx-service-group: ${spring.application.name}-grouprn # 关闭自动代理rn enable-auto-data-source-proxy: falsern # 服务配置项rn service:rn # 虚拟组和分组的映射rn vgroup-mapping:rn hdb-system-group: defaultrn config:rn type: nacosrn nacos:rn serverAddr: 127.0.0.1:8848rn group: SEATA_GROUPrn namespace:rn registry:rn type: nacosrn nacos:rn application: seata-serverrn server-addr: 127.0.0.1:8848rn namespace:rnrn# mybatis配置rnmybatis:rn # 搜索指定包别名rn typeAliasesPackage: com.hdb.systemrn # 配置mapper的扫描，找到所有的mapper.xml映射文件rn mapperLocations: classpath:mapper*.xmlrnrn# swagger配置rnswagger:rn title: 系统模块接口文档rn license: Powered By hdbrn licenseUrl: https://hdb.vip','ac8913dee679e65bb7d482df5f267d4e','2020-11-20 00:00:00','2021-01-27 10:42:25',NULL,'0:0:0:0:0:0:0:1','','','系统模块','null','null','yaml','null'),
(6,'hdb-gen-dev.yml','DEFAULT_GROUP','# spring配置rnspring: rn redis:rn host: localhostrn port: 6379rn password: rn datasource: rn driver-class-name: com.mysql.cj.jdbc.Driverrn url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8rn username: rootrn password: passwordrnrn# mybatis配置rnmybatis:rn # 搜索指定包别名rn typeAliasesPackage: com.hdb.gen.domainrn # 配置mapper的扫描，找到所有的mapper.xml映射文件rn mapperLocations: classpath:mapper*.xmlrnrn# swagger配置rnswagger:rn title: 代码生成接口文档rn license: Powered By hdbrn licenseUrl: https://hdb.viprnrn# 代码生成rngen: rn # 作者rn author: hdbrn # 默认生成包路径 system 需改成自己的模块名称 如 system monitor toolrn packageName: com.hdb.systemrn # 自动去除表前缀，默认是falsern autoRemovePre: falsern # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）rn tablePrefix: sys_rn','8c79f64a4cca9b821a03dc8b27a2d8eb','2020-11-20 00:00:00','2021-01-26 10:36:45',NULL,'0:0:0:0:0:0:0:1','','','代码生成','null','null','yaml','null'),
(7,'hdb-job-dev.yml','DEFAULT_GROUP','# spring配置rnspring: rn redis:rn host: localhostrn port: 6379rn password: rn datasource:rn driver-class-name: com.mysql.cj.jdbc.Driverrn url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8rn username: rootrn password: passwordrnrn# mybatis配置rnmybatis:rn # 搜索指定包别名rn typeAliasesPackage: com.hdb.job.domainrn # 配置mapper的扫描，找到所有的mapper.xml映射文件rn mapperLocations: classpath:mapper*.xmlrnrn# swagger配置rnswagger:rn title: 定时任务接口文档rn license: Powered By hdbrn licenseUrl: https://hdb.viprn','d6dfade9a2c93c463ae857cd503cb172','2020-11-20 00:00:00','2021-01-26 10:36:04',NULL,'0:0:0:0:0:0:0:1','','','定时任务','null','null','yaml','null'),
(8,'hdb-file-dev.yml','DEFAULT_GROUP','# 本地文件上传 rnfile:rn domain: http://127.0.0.1:9300rn path: D:/hdb/uploadPathrn prefix: /staticsrnrn# FastDFS配置rnfdfs:rn domain: http://8.129.231.12rn soTimeout: 3000rn connectTimeout: 2000rn trackerList: 8.129.231.12:22122rnrn# Minio配置rnminio:rn url: http://8.129.231.12:9000rn accessKey: minioadminrn secretKey: minioadminrn bucketName: test','5382b93f3d8059d6068c0501fdd41195','2020-11-20 00:00:00','2020-12-21 21:01:59',NULL,'0:0:0:0:0:0:0:1','','','文件服务','null','null','yaml','null'),
(9,'sentinel-hdb-gateway','DEFAULT_GROUP','[rn {rn "resource": "hdb-auth",rn "count": 500,rn "grade": 1,rn "limitApp": "default",rn "strategy": 0,rn "controlBehavior": 0rn },rn {rn "resource": "hdb-system",rn "count": 1000,rn "grade": 1,rn "limitApp": "default",rn "strategy": 0,rn "controlBehavior": 0rn },rn {rn "resource": "hdb-gen",rn "count": 200,rn "grade": 1,rn "limitApp": "default",rn "strategy": 0,rn "controlBehavior": 0rn },rn {rn "resource": "hdb-job",rn "count": 300,rn "grade": 1,rn "limitApp": "default",rn "strategy": 0,rn "controlBehavior": 0rn }rn]','9f3a3069261598f74220bc47958ec252','2020-11-20 00:00:00','2020-11-20 00:00:00',NULL,'0:0:0:0:0:0:0:1','','','限流策略','null','null','json','null');
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='增加租户字段';
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',
`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',
`tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
CREATE TABLE `config_info_tag` (
`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',
`tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
`tag_id` varchar(128) NOT NULL COMMENT 'tag_id',
`app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
`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',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
CREATE TABLE `config_tags_relation` (
`id` bigint(20) NOT NULL COMMENT 'id',
`tag_name` varchar(128) NOT NULL COMMENT 'tag_name',
`tag_type` varchar(64) DEFAULT NULL COMMENT 'tag_type',
`data_id` varchar(255) NOT NULL COMMENT 'data_id',
`group_id` varchar(128) NOT NULL COMMENT 'group_id',
`tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
`nid` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nid`),
UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
CREATE TABLE `group_capacity` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`group_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
`quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
`usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
`max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
`max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
`max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
`max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';
CREATE TABLE `his_config_info` (
`id` bigint(64) unsigned NOT NULL,
`nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`data_id` varchar(255) NOT NULL,
`group_id` varchar(128) NOT NULL,
`app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
`content` longtext NOT NULL,
`md5` varchar(32) DEFAULT NULL,
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`src_user` text,
`src_ip` varchar(50) DEFAULT NULL,
`op_type` char(10) DEFAULT NULL,
`tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`nid`),
KEY `idx_gmt_create` (`gmt_create`),
KEY `idx_gmt_modified` (`gmt_modified`),
KEY `idx_did` (`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';
CREATE TABLE `tenant_capacity` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`tenant_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Tenant ID',
`quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
`usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
`max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
`max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
`max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
`max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';
CREATE TABLE `tenant_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`kp` varchar(128) NOT NULL COMMENT 'kp',
`tenant_id` varchar(128) default '' COMMENT 'tenant_id',
`tenant_name` varchar(128) default '' COMMENT 'tenant_name',
`tenant_desc` varchar(256) DEFAULT NULL COMMENT 'tenant_desc',
`create_source` varchar(32) DEFAULT NULL COMMENT 'create_source',
`gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
`gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
CREATE TABLE `users` (
`username` varchar(50) NOT NULL PRIMARY KEY,
`password` varchar(500) NOT NULL,
`enabled` boolean NOT NULL
);
CREATE TABLE `roles` (
`username` varchar(50) NOT NULL,
`role` varchar(50) NOT NULL,
UNIQUE INDEX `idx_user_role` (`username` ASC, `role` ASC) USING BTREE
);
CREATE TABLE `permissions` (
`role` varchar(50) NOT NULL,
`resource` varchar(255) NOT NULL,
`action` varchar(8) NOT NULL,
UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
);
INSERT INTO users (username, password, enabled) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', TRUE);
INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');
重启 Nacos
docker restart nacos
进入
xxx.xxx.xxx.xxx:8848/nacos
