Nacos-K8S集群部署

moonlingh

已于 2023-03-24 17:34:38 修改

阅读量575

点赞数

文章标签： kubernetes java docker

于 2023-03-24 17:30:42 首次发布

本文链接：https://blog.csdn.net/moonlingh/article/details/129755245

版权

README

以质量管理平台为例子，介绍在kubernetes中，使用statefulset部署Nacos集群。
整体来说，Nacos本身还是无状态的情况，数据持久化到mysql中，集群只是一个高可用的方案。

部署

数据库初始化（由于在之前已经初始化完毕，本文档就不展示初始化过程-- 初始数据见 nacos.sql）
创建Service

kind: Service
apiVersion: v1
metadata:
  name: nacos-headless
  namespace: gqmp-dev
  labels:
    app: nacos-headless
spec:
  ports:
    - name: server
      protocol: TCP
      port: 8848
      targetPort: 8848
      nodePort: 30450
  selector:
    app: nacos
  type: NodePort
  sessionAffinity: None
  externalTrafficPolicy: Cluster

spec. ports. nodePort: 按照每个项目自己的规划进行选择，nodePort可以用来访问Nacos的UI界面
Service创建出来之后，会生成ClusterIP，该IP可以作为服务注册Nacos的IP地址

创建ConfigMap

kind: ConfigMap
apiVersion: v1
metadata:
  name: nacos-db-cm
  namespace: test-dev
data:
  mysql.db.name: nacos
  mysql.password: xxxxxxx
  mysql.port: '3306'
  mysql.service.name: xxxxx
  mysql.user: xxxxx

创建StatefulSet

kind: StatefulSet
apiVersion: apps/v1
metadata:
  name: nacos
  namespace: gqmp-dev
spec:
  replicas: 3
  selector:
    matchLabels:
      app: nacos
  template:
    metadata:
      creationTimestamp: null
      labels:
        app: nacos
      annotations:
        pod.alpha.kubernetes.io/initialized: 'true'
    spec:
      containers:
        - name: k8snacos
          image: 'nacos/nacos-server:2.0.1'
          ports:
            - name: client
              containerPort: 8848
              protocol: TCP
            - name: client-rpc
              containerPort: 9848
              protocol: TCP
            - name: raft-rpc
              containerPort: 9849
              protocol: TCP
            - name: old-raft-rpc
              containerPort: 7848
              protocol: TCP
          env:
            - name: NACOS_REPLICAS
              value: '3'
            - name: MYSQL_SERVICE_HOST
              valueFrom:
                configMapKeyRef:
                  name: nacos-db-cm
                  key: mysql.service.name
            - name: MYSQL_SERVICE_DB_NAME
              valueFrom:
                configMapKeyRef:
                  name: nacos-db-cm
                  key: mysql.db.name
            - name: MYSQL_SERVICE_PORT
              valueFrom:
                configMapKeyRef:
                  name: nacos-db-cm
                  key: mysql.port
            - name: MYSQL_SERVICE_USER
              valueFrom:
                configMapKeyRef:
                  name: nacos-db-cm
                  key: mysql.user
            - name: MYSQL_SERVICE_PASSWORD
              valueFrom:
                configMapKeyRef:
                  name: nacos-db-cm
                  key: mysql.password
            - name: NACOS_SERVER_PORT
              value: '8848'
            - name: NACOS_APPLICATION_PORT
              value: '8848'
            - name: PREFER_HOST_MODE
              value: hostname
            - name: JVM_XMS
              value: 4096m  # 按需填写
            - name: JVM_XMX
              value: 4096m  # 按需填写
            - name: JVM_XMN
              value: 2048m  # 按需填写
            - name: NACOS_SERVERS
              value: >-
                nacos-0.nacos-headless.gqmp-dev.svc.cluster.local:8848
                nacos-1.nacos-headless.gqmp-dev.svc.cluster.local:8848
                nacos-2.nacos-headless.gqmp-dev.svc.cluster.local:8848
          resources:
            requests:
              cpu: '1'
              memory: 3Gi
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          imagePullPolicy: IfNotPresent
      restartPolicy: Always
      terminationGracePeriodSeconds: 30
      dnsPolicy: ClusterFirst
      securityContext: {
   }
      affinity:
        podAntiAffinity:
          requiredDuringSchedulingIgnoredDuringExecution:
            - labelSelector:
                matchExpressions:
                  - key: app
                    operator: In
                    values:
                      - nacos
              topologyKey: kubernetes.io/hostname
      schedulerName: default-scheduler
  serviceName: nacos-headless
  podManagementPolicy: OrderedReady
  updateStrategy:
    type: RollingUpdate
    rollingUpdate:
      partition: 0
  revisionHistoryLimit: 10

spec.containers.env: 这里NACOS_REPLICAS，MYSQL_SERVICE_DB_NAME，MYSQL_SERVICE_PORT，MYSQL_SERVICE_USER，MYSQL_SERVICE_PASSWORD几个是将ConfigMap中的环境变量转变为镜像中定义的环境变量
spec.containers.env.name:NACOS_SERVERS 这个定义了每个Pod节点的域名，让同一个StatefulSet下面的Pod使用域名可以互相通信

页面展示

在这里插入图片描述

常规命令(验证失败)

服务注册

curl -X PUT
‘http://cluster-ip:8848/nacos/v1/ns/instance?serviceName=nacos.naming.serviceName&ip=20.18.7.10&port=8080’

服务发现

curl -X GET
‘http://cluster-ip:8848/nacos/v1/ns/instance/list?serviceName=nacos.naming.serviceName’

发布配置

curl -X POST
“http://cluster-ip:8848/nacos/v1/cs/configs?dataId=nacos.cfg.dataId&group=test&content=helloWorld”

获取配置

curl -X GET
“http://cluster-ip:8848/nacos/v1/cs/configs?dataId=nacos.cfg.dataId&group=test”

nacossql初始化脚本

      
-- MySQL dump 10.14  Distrib 5.5.68-MariaDB, for Linux (x86_64)
--
-- Host: mysql80.rdsmzigjjc3gha5.agilecloud.com    Database: nacos
-- ------------------------------------------------------
-- Server version	8.0.18-baidu-rds-1.0.0.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `config_info`
--

DROP TABLE IF EXISTS `config_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_info`
--

LOCK TABLES `config_info` WRITE;
/*!40000 ALTER TABLE `config_info` DISABLE KEYS */;
INSERT INTO `config_info` VALUES (1,'111','DEFAULT_GROUP','222','bcbe3365e6ac95ea2c0343a2395834dd','2021-10-26 02:06:33','2021-10-26 02:06:33',NULL,'10.167.44.216','','','测试',NULL,NULL,'text',NULL),(2,'com.alibaba.cloud.dubbo.service.DubboMetadataService:1.0.0:lotus-file-server:provider:lotus-file-server','dubbo','{\"parameters\":{\"side\":\"provider\",\"release\":\"2.7.8\",\"methods\":\"getAllServiceKeys,getServiceRestMetadata,getExportedURLs,getAllExportedURLs\",\"deprecated\":\"false\",\"dubbo\":\"2.0.2\",\"interface\":\"com.alibaba.cloud.dubbo.service.DubboMetadataService\",\"version\":\"1.0.0\",\"qos.enable\":\"false\",\"generic\":\"false\",\"revision\":\"2.2.2.RELEASE\",\"metadata-type\":\"remote\",\"application\":\"lotus-file-server\",\"dynamic\":\"true\",\"group\":\"lotus-file-server\",\"anyhost\":\"true\"},\"canonicalName\":\"com.alibaba.cloud.dubbo.service.DubboMetadataService\",\"codeSource\":\"jar:file:/lotus-file-server.jar!/BOOT-INF/lib/spring-cloud-starter-dubbo-2.2.2.RELEASE.jar!/\",\"methods\":[{\"name\":\"getServiceRestMetadata\",\"parameterTypes\":[],\"returnType\":\"java.lang.String\"},{\"name\":\"getAllServiceKeys\",\"parameterTypes\":[],\"returnType\":\"java.util.Set\\u003cjava.lang.String\\u003e\"},{\"name\":\"getExportedURLs\",\"parameterTypes\":[\"java.lang.String\",\"java.lang.String\",\"java.lang.String\"],\"returnType\":\"java.lang.String\"},{\"name\":\"getAllExportedURLs\",\"parameterTypes\":[],\"returnType\":\"java.util.Map\\u003cjava.lang.String,java.lang.String\\u003e\"}],\"types\":[{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"char\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"int\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}]}','f492fe502541a5dd6c162d225669a856','2021-10-26 20:22:56','2021-11-14 14:12:24',NULL,'10.24.96.38','','dev',NULL,NULL,NULL,'text',NULL),(3,'com.lotus.dm.file.sdk.api.ResourceInfoApi:::provider:lotus-file-server','dubbo','{\"parameters\":{\"side\":\"provider\",\"release\":\"2.7.8\",\"methods\":\"uploadFileByBytes,verifyContent,deleteResourceBySnList,getResourceInfoBySnList,getResourceInfoBySn\",\"deprecated\":\"false\",\"dubbo\":\"2.0.2\",\"interface\":\"com.lotus.dm.file.sdk.api.ResourceInfoApi\",\"qos.enable\":\"false\",\"generic\":\"false\",\"metadata-type\":\"remote\",\"application\":\"lotus-file-server\",\"dynamic\":\"true\",\"anyhost\":\"true\"},\"canonicalName\":\"com.lotus.dm.file.sdk.api.ResourceInfoApi\",\"codeSource\":\"jar:file:/lotus-file-server.jar!/BOOT-INF/lib/file-center-sdk-1.0.0.10.jar!/\",\"methods\":[{\"name\":\"uploadFileByBytes\",\"parameterTypes\":[\"com.lotus.dm.file.sdk.req.UploadBytesDTO\"],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"},{\"name\":\"getResourceInfoBySn\",\"parameterTypes\":[\"java.lang.String[]\"],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"},{\"name\":\"getResourceInfoBySn\",\"parameterTypes\":[\"java.lang.Long\",\"java.lang.String[]\"],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"},{\"name\":\"deleteResourceBySnList\",\"parameterTypes\":[\"java.util.List\\u003cjava.lang.String\\u003e\"],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"},{\"name\":\"getResourceInfoBySnList\",\"parameterTypes\":[\"java.util.List\\u003ccom.lotus.dm.file.sdk.req.ResourceGetDTO\\u003e\"],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"},{\"name\":\"verifyContent\",\"parameterTypes\":[\"java.util.List\\u003ccom.lotus.dm.file.sdk.req.VerifyContentReq\\u003e\"],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"}],\"types\":[{\"type\":\"byte\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"boolean\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"char\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"int\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"com.lotus.platform.common.model.base.BaseResult\",\"properties\":{\"code\":{\"type\":\"int\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"data\":{\"type\":\"java.lang.Object\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"message\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"errorArgs\":{\"type\":\"java.lang.String[]\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.ArrayTypeBuilder\"}},\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"com.lotus.dm.file.sdk.req.VerifyContentReq\",\"properties\":{\"sn\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}},\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"com.lotus.dm.file.sdk.req.UploadBytesDTO\",\"properties\":{\"fileName\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"bizType\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"expireTime\":{\"type\":\"java.lang.Long\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"bytes\":{\"type\":\"byte[]\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.ArrayTypeBuilder\"},\"description\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}},\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.Boolean\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.Long\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"com.lotus.dm.file.sdk.req.ResourceGetDTO\",\"properties\":{\"expireTime\":{\"type\":\"java.lang.Long\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"openWaterMark\":{\"type\":\"java.lang.Boolean\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"sn\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}},\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"long\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.Object\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}]}','477795147d7abc76028860eff4436ebd','2021-10-26 20:22:58','2021-11-14 14:12:24',NULL,'10.24.96.38','','dev',NULL,NULL,NULL,'text',NULL),(21,'lqmp-lims','mapping-com.alibaba.cloud.dubbo.service.DubboMetadataService','1635904484675','ebaf6c2120161f394e219f0541f6ae71','2021-11-02 06:36:35','2021-11-02 20:54:45',NULL,'10.167.44.63','','dev',NULL,NULL,NULL,'text',NULL),(22,'com.alibaba.cloud.dubbo.service.DubboMetadataService:1.0.0:lqmp-lims:provider:lqmp-lims','dubbo','{\"parameters\":{\"side\":\"provider\",\"release\":\"2.7.8\",\"methods\":\"getAllServiceKeys,getServiceRestMetadata,getExportedURLs,getAllExportedURLs\",\"deprecated\":\"false\",\"dubbo\":\"2.0.2\",\"interface\":\"com.alibaba.cloud.dubbo.service.DubboMetadataService\",\"version\":\"1.0.0\",\"qos.enable\":\"false\",\"generic\":\"false\",\"revision\":\"2.2.2.RELEASE\",\"metadata-type\":\"remote\",\"application\":\"lqmp-lims\",\"dynamic\":\"true\",\"group\":\"lqmp-lims\",\"anyhost\":\"true\"},\"canonicalName\":\"com.alibaba.cloud.dubbo.service.DubboMetadataService\",\"codeSource\":\"spring-cloud-starter-dubbo-2.2.2.RELEASE.jar\",\"methods\":[{\"name\":\"getServiceRestMetadata\",\"parameterTypes\":[],\"returnType\":\"java.lang.String\"},{\"name\":\"getAllServiceKeys\",\"parameterTypes\":[],\"returnType\":\"java.util.Set\\u003cjava.lang.String\\u003e\"},{\"name\":\"getExportedURLs\",\"parameterTypes\":[\"java.lang.String\",\"java.lang.String\",\"java.lang.String\"],\"returnType\":\"java.lang.String\"},{\"name\":\"getAllExportedURLs\",\"parameterTypes\":[],\"returnType\":\"java.util.Map\\u003cjava.lang.String,java.lang.String\\u003e\"}],\"types\":[{\"type\":\"int\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"char\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}]}','6c56253df2c20d35e8a69104f882cd9f','2021-11-02 06:36:35','2021-11-02 20:54:45',NULL,'10.167.44.63','','dev',NULL,NULL,NULL,'text',NULL),(23,'com.lotus.lqmp.sdk.api.FileOperateApi:::provider:lqmp-lims','dubbo','{\"parameters\":{\"side\":\"provider\",\"release\":\"2.7.8\",\"methods\":\"test\",\"deprecated\":\"false\",\"dubbo\":\"2.0.2\",\"interface\":\"com.lotus.lqmp.sdk.api.FileOperateApi\",\"qos.enable\":\"false\",\"generic\":\"false\",\"metadata-type\":\"remote\",\"application\":\"lqmp-lims\",\"dynamic\":\"true\",\"anyhost\":\"true\"},\"canonicalName\":\"com.lotus.lqmp.sdk.api.FileOperateApi\",\"codeSource\":\"file:/Users/yangtao/workspace/lqmp-lims/lqmp-lims-sdk/target/classes/\",\"methods\":[{\"name\":\"test\",\"parameterTypes\":[],\"returnType\":\"com.lotus.platform.common.model.base.BaseResult\"}],\"types\":[{\"type\":\"com.lotus.platform.common.model.base.BaseResult\",\"properties\":{\"code\":{\"type\":\"int\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"data\":{\"type\":\"java.lang.Object\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"message\":{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},\"errorArgs\":{\"type\":\"java.lang.String[]\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.ArrayTypeBuilder\"}},\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"int\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.Object\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"java.lang.String\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"},{\"type\":\"char\",\"typeBuilderName\":\"org.apache.dubbo.metadata.definition.builder.DefaultTypeBuilder\"}]}','334bfbaaa6a559249b9d56398585a06c','2021-11-02 06:36:35','2021-11-02 20:54:45',NULL,'10.167.44.63','','dev',NULL,NULL,NULL,'text',NULL),(24,'lqmp-lims','mapping-com.lotus.lqmp.sdk.api.FileOperateApi','1635904485022','8fb5edbb324926226669f001b9ca9632','2021-11-02 06:36:35','2021-11-02 20:54:45',NULL,'10.167.44.63','','dev',NULL,NULL,NULL,'text',NULL),(33,'lqmp-lims','DEFAULT_GROUP','idaas:\n  passportHost: https://passport-dev.lotuscars.com.cn\n  appId: 652998503743619072\n  appSecret: JM9Buyww\n\n#SSO\nlotus:\n  idaas:\n    #SSO服务器的授权服务地址\n    sso_openapi_auth_url: https://passport-dev.lotuscars.com.cn/api\n    #sso服务器的服务地址\n    sso_root_url: https://passport-dev.lotuscars.com.cn\n    #sso服务器的服务地址\n    sso_cas_auth_url: https://passport-dev.lotuscars.com.cn/api/authz/cas/login\n    #SSO登录成功后，重定向回业务系统的地址,拿到ticket，中间页面\n    sso_logon_url:\n    #应⽤服务编号，需要向认证服务系统管理员申请获取\n    service_id: 652998503743619072\n  auth:\n    #需要排除过滤的地址，配置后，则⽆需权限过滤\n    exclude_url: /webjars/**,/doc.html,/swagger-ui.html,/swagger-resources/**,/favicon.ico,/v3/api-docs/**,/auth/**\nspring:\n  ## Redis 配置\n  redis:\n    ## Redis数据库索引（默认为0）\n    database: 0\n    ## Redis服务器地址\n    host: 10.24.99.146\n    ## Redis服务器连接端口\n    port: 6379\n    ## Redis服务器连接密码（默认为空）\n    password: +qgwc9RWmtT4\n    jedis:\n      pool:\n        ## 连接池最大连接数（使用负值表示没有限制）\n        #spring.redis.pool.max-active=8\n        max-active: 8\n        ## 连接池最大阻塞等待时间（使用负值表示没有限制）\n        #spring.redis.pool.max-wait=-1\n        max-wait: -1\n        ## 连接池中的最大空闲连接\n        #spring.redis.pool.max-idle=8\n        max-idle: 8\n        ## 连接池中的最小空闲连接\n        #spring.redis.pool.min-idle=0\n        min-idle: 0\n    ## 连接超时时间（毫秒）\n    timeout: 1200\n  redisson:\n    address: redis://10.24.99.146:6379\n    password: +qgwc9RWmtT4','57fedfdc2d43d46a984b80d87ded8d26','2021-11-04 02:27:55','2021-11-15 02:53:55',NULL,'10.167.44.63','','dev','','','','yaml',''),(79,'lqmp-qt-center','DEFAULT_GROUP','idaas:\n  passportHost: https://passport-dev.lotuscars.com.cn\n  appId: 652998503743619072\n  appSecret: JM9Buyww\n\n#SSO\nlotus:\n  idaas:\n    #SSO服务器的授权服务地址\n    sso_openapi_auth_url: https://passport-dev.lotuscars.com.cn/api\n    #sso服务器的服务地址\n    sso_root_url: https://passport-dev.lotuscars.com.cn\n    #sso服务器的服务地址\n    sso_cas_auth_url: https://passport-dev.lotuscars.com.cn/api/authz/cas/login\n    #SSO登录成功后，重定向回业务系统的地址,拿到ticket，中间页面\n    sso_logon_url:\n    #应⽤服务编号，需要向认证服务系统管理员申请获取\n    service_id: 652998503743619072\n  auth:\n    #需要排除过滤的地址，配置后，则⽆需权限过滤\n    exclude_url: /webjars/**,/doc.html,/swagger-ui.html,/swagger-resources/**,/favicon.ico,/v2/api-docs/**,/auth/**\nspring:\n  ## Redis 配置\n  redis:\n    ## Redis数据库索引（默认为0）\n    database: 0\n    ## Redis服务器地址\n    host: 10.24.99.146\n    ## Redis服务器连接端口\n    port: 6379\n    ## Redis服务器连接密码（默认为空）\n    password: +qgwc9RWmtT4\n    jedis:\n      pool:\n        ## 连接池最大连接数（使用负值表示没有限制）\n        #spring.redis.pool.max-active=8\n        max-active: 8\n        ## 连接池最大阻塞等待时间（使用负值表示没有限制）\n        #spring.redis.pool.max-wait=-1\n        max-wait: -1\n        ## 连接池中的最大空闲连接\n        #spring.redis.pool.max-idle=8\n        max-idle: 8\n        ## 连接池中的最小空闲连接\n        #spring.redis.pool.min-idle=0\n        min-idle: 0\n    ## 连接超时时间（毫秒）\n    timeout: 1200\n  redisson:\n    address: redis://10.24.99.146:6379\n    password: +qgwc9RWmtT4','930356e69ac8d404b3333458495f001f','2021-11-12 02:03:58','2021-11-12 02:47:43',NULL,'10.167.16.4','','dev','','','','yaml','');
/*!40000 ALTER TABLE `config_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_info_aggr`
--

DROP TABLE IF EXISTS `config_info_aggr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_info_aggr` (
  `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 NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin 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='增加租户字段';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_info_aggr`
--

LOCK TABLES `config_info_aggr` WRITE;
/*!40000 ALTER TABLE `config_info_aggr` DISABLE KEYS */;
/*!40000 ALTER TABLE `config_info_aggr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_info_beta`
--

DROP TABLE IF EXISTS `config_info_beta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_info_beta` (
  `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(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin 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';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_info_beta`
--

LOCK TABLES `config_info_beta` WRITE;
/*!40000 ALTER TABLE `config_info_beta` DISABLE KEYS */;
/*!40000 ALTER TABLE `config_info_beta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_info_tag`
--

DROP TABLE IF EXISTS `config_info_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_info_tag` (
  `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(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin 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';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_info_tag`
--

LOCK TABLES `config_info_tag` WRITE;
/*!40000 ALTER TABLE `config_info_tag` DISABLE KEYS */;
/*!40000 ALTER TABLE `config_info_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_tags_relation`
--

DROP TABLE IF EXISTS `config_tags_relation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_tags_relation` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',