部署敏捷管理

创建数据库

编写参数配置文件

env:
  MYSQL_HOST: c7n-mysql.c7n-system.svc
  MYSQL_PORT: "3306"
  MYSQL_USER: root
  MYSQL_PASS: password
  SQL_SCRIPT: |
    CREATE USER IF NOT EXISTS 'choerodon'@'%' IDENTIFIED BY 'password';
    CREATE DATABASE IF NOT EXISTS agile_service DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    CREATE DATABASE IF NOT EXISTS knowledgebase_service DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    CREATE DATABASE IF NOT EXISTS test_manager_service DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    GRANT ALL PRIVILEGES ON test_manager_service.* TO choerodon@'%';
    GRANT ALL PRIVILEGES ON knowledgebase_service.* TO choerodon@'%';
    GRANT ALL PRIVILEGES ON agile_service.* TO choerodon@'%';
    FLUSH PRIVILEGES;

执行安装

helm upgrade --install create-c7nagile-db c7n/mysql-client \
  -f create-c7nagile-db.yaml \
  --create-namespace \
  --version 0.1.0 \
  --namespace c7n-system

若需了解项目详情及各项参数含义，请移步。

编写参数配置文件 agile-service.yaml

preJob:
  preInitDB:
    datasource:
      url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
      username: choerodon
      password: password
    datasources:
      # 多数据源初始化
      # 支持框架数据和agile进行分库 指定菜单初始化地址
      platform:
         url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
         username: choerodon
         password: password
         driver: com.mysql.jdbc.Driver
      message:
        url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
       username: choerodon
        password: password
        driver: com.mysql.jdbc.Driver
env:
  open:
    SPRING_REDIS_PORT: 6379
    EUREKA_CLIENT_SERVICEURL_DEFAULTZONE: http://choerodon-register.c7n-system:8000/eureka/
    SPRING_DATASOURCE_URL: jdbc:mysql://c7n-mysql.c7n-system:3306/agile_service?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
    SPRING_DATASOURCE_USERNAME: choerodon
    SPRING_DATASOURCE_PASSWORD: password
    SERVICES_ATTACHMENT_URL: http://minio.example.choerodon.io
    SERVICES_DOMAIN_URL: http://app.example.choerodon.io
    SPRING_APPLICATION_NAME: agile-service

验证部署

验证命令

curl -s $(kubectl get po -n c7n-system -l choerodon.io/release=agile-service -o jsonpath="{.items[0].status.podIP}"):8379/actuator/health | jq -r .status

出现以下类似信息即为成功部署

```
UP
```

部署 test manager service

若需了解项目详情及各项参数含义，请移步。

编写参数配置文件 test-manager-service.yaml

preJob:
  preInitDB:
    datasource:
      url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&allowMultiQueries=true&serverTimezone=Asia/Shanghai
      username: choerodon
      password: password
    datasources:
      # 多数据源初始化
      # 支持框架数据和agile进行分库 指定菜单初始化地址
      platform:
         url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
         username: choerodon
         password: password
         driver: com.mysql.jdbc.Driver
env:
  open:
    SPRING_REDIS_HOST: c7n-redis.c7n-system
    SPRING_REDIS_PORT: 6379
    SPRING_REDIS_DATABASE: 13
    EUREKA_CLIENT_SERVICEURL_DEFAULTZONE: http://choerodon-register.c7n-system:8000/eureka/
    SPRING_DATASOURCE_URL: jdbc:mysql://c7n-mysql.c7n-system:3306/test_manager_service?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&allowMultiQueries=true&serverTimezone=Asia/Shanghai
    SPRING_DATASOURCE_USERNAME: choerodon
    SPRING_DATASOURCE_PASSWORD: password
    CHOERODON_CLEANPERMISSION: false
    SERVICES_ATTACHMENT_URL: http://minio.example.choerodon.io

部署服务
- 验证命令

```
curl -s $(kubectl get po -n c7n-system -l choerodon.io/release=test-manager-service -o jsonpath="{.items[0].status.podIP}"):8094/actuator/health | jq -r .status
```
-   出现以下类似信息即为成功部署  
```
UP
```

若需了解项目详情及各项参数含义，请移步 open-hand/elasticsearch-kb。

安装 elasticsearch

helm upgrade --install elasticsearch-kb c7n/elasticsearch-kb \
  --version 0.23.0 \
  --create-namespace \
  --namespace c7n-system

部署 knowledgebase service

若需了解项目详情及各项参数含义，请移步 open-hand/knowledgebase-service。

编写参数配置文件 knowledgebase-service.yaml

preJob:
  preInitDB:
    datasource:
      url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
      username: choerodon
      password: password
    datasources:
      # 多数据源初始化 初始化菜单数据
      # 支持框架数据和agile进行分库 指定菜单初始化地址
      platform:
         url: jdbc:mysql://c7n-mysql.c7n-system:3306/?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
         username: choerodon
         password: password
         driver: com.mysql.jdbc.Driver
env:
  open:
    SPRING_REDIS_HOST: c7n-redis.c7n-system
    SPRING_REDIS_PORT: 6379
    SPRING_REDIS_DATABASE: 14
    EUREKA_CLIENT_SERVICEURL_DEFAULTZONE: http://choerodon-register.c7n-system:8000/eureka/
    SPRING_DATASOURCE_URL: jdbc:mysql://c7n-mysql.c7n-system:3306/knowledgebase_service?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&serverTimezone=Asia/Shanghai
    SPRING_DATASOURCE_USERNAME: choerodon
    SPRING_DATASOURCE_PASSWORD: password
    SERVICES_ATTACHMENT_URL: http://minio.example.choerodon.io/knowledgebase-service/
    ELASTICSEARCH_IP: elasticsearch-kb:9200

验证部署
- 验证命令

```
curl -s $(kubectl get po -n c7n-system -l choerodon.io/release=knowledgebase-service -o jsonpath="{.items[0].status.podIP}"):8281/actuator/health | jq -r .status
```
-   出现以下类似信息即为成功部署  
```
```

敏捷管理部署

部署敏捷管理

创建数据库

部署 test manager service

部署 knowledgebase service