Spring Cloud版本的若依(5)--Nacos版本

安装
Git网址
https://gitee.com/zhangmrit/ruoyi-cloud/tree/nacos/
因项目使用spring-cloud-alibaba nacos作为注册中心,移除了eureka和config。

下载编译后压缩包方式
您可以从 最新稳定版本https://github.com/alibaba/nacos/releases 下载 nacos-server-$version.zip 包。
解压
cd nacos/bin

启动命令:
cmd startup.cmd
或者双击startup.cmd运行文件。

找到 nacos/conf 目录下的 “application.properties” 文件,文件中添加链接数据库的配置,例如

spring.datasource.platform=mysql
db.num=1
db.url.0=jdbc:mysql://127.0.0.1:3306/nacos_test01?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true
db.user=root
db.password=

mysql导入

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : nacos

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 30/08/2019 11:41:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime(0) NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_info
-- ----------------------------
INSERT INTO `config_info` VALUES (1, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    database: 1\r\n    host: 192.168.0.185\r\n    port: 6379\r\n    password:      \r\n    timeout: 6000ms  \r\n    lettuce:\r\n      pool:\r\n        max-active: 1000  \r\n        max-wait: -1ms     \r\n        max-idle: 10     \r\n        min-idle: 5       ', '93655372645a71ad603259e7dba81a43', '2019-06-21 19:10:20', '2019-06-28 16:42:48', NULL, '127.0.0.1', '', '', '', NULL, NULL, 'yaml', NULL);
INSERT INTO `config_info` VALUES (3, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\r\n redis:\r\n   database: 1\r\n   host: 192.168.0.185\r\n   port: 6379\r\n   password:      # 密码(默认为空)\r\n   timeout: 6000ms  # 连接超时时长(毫秒)\r\n   lettuce:\r\n     pool:\r\n       max-active: 1000  # 连接池最大连接数(使用负值表示没有限制)\r\n       max-wait: -1ms      # 连接池最大阻塞等待时间(使用负值表示没有限制)\r\n       max-idle: 10      # 连接池中的最大空闲连接\r\n       min-idle: 5       # 连接池中的最小空闲连接', '01479c9861c53b798b95f3df59acc5ba', '2019-06-24 11:01:34', '2019-06-28 15:29:56', NULL, '127.0.0.1', '', '', '', NULL, NULL, 'yaml', NULL);
INSERT INTO `config_info` VALUES (4, 'ruoyi-gateway-prod.yml', 'DEFAULT_GROUP', 'spring: \r\n  redis:\r\n    database: 1\r\n    host: 127.0.0.1\r\n    port: 6379\r\n    password:      \r\n    timeout: 6000ms  \r\n    lettuce:\r\n      pool:\r\n        max-active: 1000  \r\n        max-wait: -1ms      \r\n        max-idle: 10      \r\n        min-idle: 5      ', 'ca1f5dd577be7b2fba38f0d03bd90ac8', '2019-06-24 11:04:26', '2019-06-24 11:18:08', NULL, '127.0.0.1', '', '', '', NULL, NULL, 'yaml', NULL);
INSERT INTO `config_info` VALUES (6, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# 数据源配置\r\nspring:\r\n  redis:\r\n    database: 1\r\n    host: 192.168.0.185\r\n    port: 6379\r\n    password:      # 密码(默认为空)\r\n    timeout: 6000ms  # 连接超时时长(毫秒)\r\n    lettuce:\r\n      pool:\r\n        max-active: 1000  # 连接池最大连接数(使用负值表示没有限制)\r\n        max-wait: -1ms      # 连接池最大阻塞等待时间(使用负值表示没有限制)\r\n        max-idle: 10      # 连接池中的最大空闲连接\r\n        min-idle: 5       # 连接池中的最小空闲连接\r\n  datasource:\r\n    type: com.alibaba.druid.pool.DruidDataSource\r\n    driverClassName: com.mysql.cj.jdbc.Driver\r\n    druid:\r\n      # 主库数据源\r\n      master:\r\n        url: jdbc:mysql://localhost:3306/ry_cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n        username: root\r\n        password: root\r\n      # 从库数据源\r\n      slave:\r\n        #从数据源开关/默认关闭\r\n        enabled: false\r\n        url: jdbc:mysql://localhost:3306/ry_cloud_read?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n        username: root\r\n        password: root\r\n      # 初始连接数\r\n      initialSize: 5\r\n      # 最小连接池数量\r\n      minIdle: 10\r\n      # 最大连接池数量\r\n      maxActive: 20\r\n      # 配置获取连接等待超时的时间\r\n      maxWait: 60000\r\n      # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒\r\n      timeBetweenEvictionRunsMillis: 60000\r\n      # 配置一个连接在池中最小生存的时间,单位是毫秒\r\n      minEvictableIdleTimeMillis: 300000\r\n      # 配置一个连接在池中最大生存的时间,单位是毫秒\r\n      maxEvictableIdleTimeMillis: 900000\r\n      # 配置检测连接是否有效\r\n      validationQuery: SELECT 1 FROM DUAL\r\n      testWhileIdle: true\r\n      testOnBorrow: false\r\n      testOnReturn: false\r\n      webStatFilter:\r\n          enabled: true\r\n      statViewServlet:\r\n          enabled: true\r\n          # 设置白名单,不填则允许所有访问\r\n          allow:\r\n          url-pattern: /monitor/druid/*\r\n      filter:\r\n          stat:\r\n              enabled: true\r\n              # 慢SQL记录\r\n              log-slow-sql: true\r\n              slow-sql-millis: 1000\r\n              merge-sql: true\r\n          wall:\r\n              config:\r\n                  multi-statement-allow: true', 'b90c0295df7b34950ccae3f9005b98d6', '2019-06-24 11:28:38', '2019-07-31 10:56:43', NULL, '127.0.0.1', '', '', '', 'null', 'null', 'yaml', 'null');
INSERT INTO `config_info` VALUES (7, 'ruoyi-system-prod.yml', 'DEFAULT_GROUP', '# 数据源配置\r\nspring:\r\n  redis:\r\n    database: 1\r\n    host: 127.0.0.1\r\n    port: 6379\r\n    password:      # 密码(默认为空)\r\n    timeout: 6000ms  # 连接超时时长(毫秒)\r\n    lettuce:\r\n      pool:\r\n        max-active: 1000  # 连接池最大连接数(使用负值表示没有限制)\r\n        max-wait: -1ms      # 连接池最大阻塞等待时间(使用负值表示没有限制)\r\n        max-idle: 10      # 连接池中的最大空闲连接\r\n        min-idle: 5       # 连接池中的最小空闲连接\r\n  datasource:\r\n    type: com.alibaba.druid.pool.DruidDataSource\r\n    driverClassName: com.mysql.cj.jdbc.Driver\r\n    druid:\r\n      # 主库数据源\r\n      master:\r\n        url: jdbc:mysql://localhost:3306/ry?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n        username: root\r\n        password: root\r\n      # 从库数据源\r\n      slave:\r\n        #从数据源开关/默认关闭\r\n        enabled: false\r\n        url: jdbc:mysql://localhost:3306/wind?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n        username: root\r\n        password: root\r\n      # 初始连接数\r\n      initialSize: 5\r\n      # 最小连接池数量\r\n      minIdle: 10\r\n      # 最大连接池数量\r\n      maxActive: 20\r\n      # 配置获取连接等待超时的时间\r\n      maxWait: 60000\r\n      # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒\r\n      timeBetweenEvictionRunsMillis: 60000\r\n      # 配置一个连接在池中最小生存的时间,单位是毫秒\r\n      minEvictableIdleTimeMillis: 300000\r\n      # 配置一个连接在池中最大生存的时间,单位是毫秒\r\n      maxEvictableIdleTimeMillis: 900000\r\n      # 配置检测连接是否有效\r\n      validationQuery: SELECT 1 FROM DUAL\r\n      testWhileIdle: true\r\n      testOnBorrow: false\r\n      testOnReturn: false\r\n      webStatFilter:\r\n          enabled: true\r\n      statViewServlet:\r\n          enabled: true\r\n          # 设置白名单,不填则允许所有访问\r\n          allow:\r\n          url-pattern: /monitor/druid/*\r\n      filter:\r\n          stat:\r\n              enabled: true\r\n              # 慢SQL记录\r\n              log-slow-sql: true\r\n              slow-sql-millis: 1000\r\n              merge-sql: true\r\n          wall:\r\n              config:\r\n                  multi-statement-allow: true', '008f0cec24930e75b987886519048048', '2019-06-24 11:29:29', '2019-06-24 11:29:29', NULL, '127.0.0.1', '', '', NULL, NULL, NULL, 'yaml', NUL
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值