Table of Contents

The guide shows step by step to deploy ote-stack platform with one edge cluster as well as add a new edge cluster to management.

License

Apache 2.0 license

How to use this document

The guide covers the details of pre-installation requirements, installation steps and uninstallation guide. The installation steps should be executed before the prerequisites and pre-installation requirements are ready. In addition, one IEC edge cluster with 3 nodes needs to be prepared in advance.

...

Minimum Hardware Requirements

HW Aspect	Requirement
1 Jumpserver	A physical or virtualized machine that has direct network connectivity to the edge nodes. For virtual deployments, CPU/RAM/disk requirements of cluster nodes should be satisfiable as virtual machine resources when using the jumpserver as a hypervisor.
CPU	Minimum 1 socket for IEC and 2 socket for ote-stack components and usecase test (each cluster node)
RAM	Minimum 4GB/server (Depending on usecase work load)
Disk	Minimum 20GB (each cluster node)
Networks	Mininum 1

Recommended Hardware Requirements

3 Huawei TaiShan 2280 Arm Server are required:

Processor	2*Kunpeng 920 processor
RAM	12*32G-DDR4-2666MT/s
Storage	33.5 inch 4000G SATA and 12.5 inch 3200G NVMe SSD
Network	1 onboard network card, each card supports 4GE port or 410GE port or 4*25GE port

Refer TaiShan 2280 Server User Guide here

View file

name	TaiShan 200 Server User Guide (Model 2280) 06.pdf
height	250

Software Prerequisites

Available harbor (>=1.7, <2.0) with admin user and password
At least one IEC edge cluster with healthy container network.

Database Prerequisites

...

(option)

It is not necessary to execute the below scripts. MySQL database will be deployed on the root edge cluster after executing the installation scripts. If there is an existing MySQL database, you can perform the below scripts so as to initialize the database for ote-stack platform.

...

A mysql database is required to store the related metadata of OTE models, like users, businesses, projects, apps, deployments, clusters, nodes, etc. The database `sys_ote_manage_platform` is consists of following tables:

tb_system_config stores global configuration of OTE web portal.
tb_business_info maintains the relation between OTE users and namespace which divide cluster resources between different users.
tb_ote_web_users stores the informations of general users and administrator in OTE stack.
tb_ote_web_repository_users stores the information of users who are used to pull docker images.
tb_ote_cluster_label stores the labels which are attached to edge clusters, while the information of clusters are stored as CRD resource in the etcd.
tb_ote_node_label stores the labels which are attached to edge nodes, while the information of edge nodes are stored as CRD resource in the etcd.
tb_app_info stores the information about application that will be deployed, such as name, image, required resource, execution command.
tb_deploy_info maintains the information and status of deployment related to the application that stored in tb_app_info.
tb_alert_info displays alert messages sent by alertmanager.

Schema scripts

The following schema scripts will help you to generate the database for OTE-stack. But It is not necessary to execute the scripts, because a new MySQL database will be deployed on the root edge cluster after executing the installation scripts.

Code Block

collapse	true

CREATE DATABASE sys_ote_manage_platform;
USE sys_ote_manage_platform;
SET names utf8;

CREATE TABLE IF NOT EXISTS `tb_otesystem_web_users`config` (
  `id``key` bigintvarchar(2064) unsigned NOT NULL AUTO_INCREMENT,
  `uid``value` varchar(50) COLLATE utf8_unicode_ci64) NOT NULL,
COMMENT 'user id',
  `namespace` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' COMMENT 'namespace',
  `user_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT '' COMMENT 'username',
  `display_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT '' COMMENT 'nickname',
  `real_name` varchar(50) COLLATE utf8_unicode_ci PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='system configuration';

CREATE TABLE IF NOT EXISTS `tb_business_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL COMMENT 'business name',
  `namespace` varchar(64) NOT NULL DEFAULT '' COMMENT 'real namenamespace',
  `password``user_id` varcharbigint(6020) COLLATE utf8_unicode_ciunsigned NOT NULL DEFAULTCOMMENT '' COMMENT 'passworduser id',
  `email``introduce` varchar(255) COLLATE utf8_unicode_ci512) NOT NULL DEFAULTCOMMENT ''business COMMENT introduction'email',
  `phone``objective` varchar(11512) COLLATE utf8_unicode_ci NOT NULL DEFAULTCOMMENT ''resource COMMENT requirements'phone',
  `status``scale` tinyintvarchar(4512) unsigned NOT NULL DEFAULT '3' COMMENT 'status: 0:pending,1:reviewed,2:failed,3:forbidden，business scale',
  `is_admin``comment` tinyintvarchar(3512) unsigned NOT NULL DEFAULT '0' COMMENT 'isreview admincomments',
  `role``status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'role:0:unauthorized,1:general manager,2:admin,3:super admin 0 COMMENT 'status',
  `updated`update_at`time` timestampTIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created`create_at`time` timestampTIMESTAMP NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tb_ote_web_users_uid_unique` (`uid`) USING BTREE,
  UNIQUE KEY `tb_ote_web_users_phone_unique` (`phone`) USING BTREE KEY (`id`),
  UNIQUE KEY `tb_ote_web_users_user_name_unique` (`user_name`) USING BTREE(`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tb_ote_web_repository_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user id',
  `namespace` varchar(64) NOT NULLCOLLATE utf8_unicode_ci DEFAULT '' COMMENT 'namespace',
  `repository`user_uid`name` bigintvarchar(2050) unsignedCOLLATE utf8_unicode_ci DEFAULT '0' COMMENT 'uidusername',
  `repository`display_username`name` varchar(50) COLLATE utf8_unicode_ci NOTDEFAULT NULL'' COMMENT 'usernamenickname',
  `repository`real_email`name` varchar(25550) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'emailreal name',
  `repository_password``password` varchar(25560) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'password',
  `email` varchar(255) COLLATE `updated_at` timestamputf8_unicode_ci NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`namespace`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='harbor user';

CREATE TABLE IF NOT EXISTS `tb_ote_web_third_repository` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(64) COLLATE utf8_unicode_ci '' COMMENT 'email',
  `phone` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'phone',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '3' COMMENT 'status: 0:pending,1:reviewed,2:failed,3:forbidden，',
  `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'is admin',
  `role` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'user namespacerole:0:unauthorized,1:general manager,2:admin,3:super admin',
  `repository`updated_id` varchar(50) COLLATE utf8_unicode_ciat` timestamp NOT NULL DEFAULT '' COMMENT 'repository id'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `repository`created_url` varchar(500) COLLATE utf8_unicode_ciat` timestamp NOT NULL,
DEFAULT '' COMMENTPRIMARY 'repository addr'KEY (`id`),
  `repository_username` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'username,
  `repository_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'passwoed',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`namespace`, `repository_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='third repo';

CREATE TABLE IF NOT EXISTS `tb_ote_cluster_label` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cluster_name` varchar(64UNIQUE KEY `tb_ote_web_users_uid_unique` (`uid`) USING BTREE,
  UNIQUE KEY `tb_ote_web_users_phone_unique` (`phone`) USING BTREE,
  UNIQUE KEY `tb_ote_web_users_user_name_unique` (`user_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tb_ote_web_repository_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(64) NOT NULL DEFAULT '' COMMENT 'namespace',
  `repository_uid` bigint(20) unsigned DEFAULT '0' COMMENT 'uid',
  `repository_username` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'username',
  `repository_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'cluster nameemail',
  `label``repository_password` varchar(64255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'labelpassword',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`cluster_name`, `label``namespace`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='harbor user';

CREATE TABLE IF NOT EXISTS `tb_ote_web_nodethird_label`repository` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cluster_name``namespace` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'clusteuser namespace',
  `node_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'nodename',
  `label``repository_id` varchar(6450) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'noderepository labelid',
  `updated`repository_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`cluster_name`, `node_name`, `label`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=url` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'repository addr',
  `repository_username` varchar(50) COLLATE utf8_unicode_ci; NOT CREATENULL TABLEDEFAULT IF'' NOTCOMMENT EXISTS `tb_app_info` (
  `id` bigint(20) unsigned'username,
  `repository_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL AUTO_INCREMENT COMMENT 'passwoed',
  `namespace` varchar(64)`updated_at` timestamp NOT NULL COMMENT 'namespace' DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `app`created_name` varchar(64)at` timestamp NOT NULL,
COMMENT 'app_name', PRIMARY KEY `main_version` varchar(32`id`),
NOT NULL COMMENTUNIQUE 'major version'KEY (`namespace`, `repository_id`) USING `version_count` int(11) NOT NULL COMMENT 'minor version',
  `image` varchar(256) NOT NULL COMMENT 'image',
  `repository_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'repository_id',
  `port` varchar(1024) NOT NULL DEFAULT '0' COMMENT 'port',
  `env` varchar(1024)BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='third repo';

CREATE TABLE IF NOT EXISTS `tb_ote_cluster_label` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cluster_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'envcluster name',
  `volume``label` varchar(102464) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'volumelabel',
  `dependence` varchar(1024)`updated_at` timestamp NOT NULL DEFAULT '' COMMENT '' CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `replicas` int(10)`created_at` timestamp NOT NULL,
DEFAULT  '1'PRIMARY COMMENT 'replicas'KEY (`id`),
  `command`UNIQUE KEY varchar(512) NOT NULL DEFAULT '' COMMENT 'command',
  `deploy_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'deploy_type: 0:deployment, 1:daemonset',
  `gpu` int(10) NOT NULL DEFAULT '0',
  `request_cpu` int(10) (`cluster_name`, `label`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tb_ote_node_label` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cluster_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '80' COMMENT 'cluste',
  `request`node_mem`name` intvarchar(10)64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '4096' COMMENT 'nodename',
  `limit_cpu``label` intvarchar(10)64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '80node label',
  `limit_mem` int(10)`updated_at` timestamp NOT NULL DEFAULT '4096'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `min`created_replicas` int(10)at` timestamp NOT NULL,
DEFAULT '1',  PRIMARY `max_replicas`KEY int(10`id`),
NOT  UNIQUE NULL DEFAULT '5',
  `is_hpa` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'is_hpa：0：no，1：yes',
  `hpa_target_cpu` int(10) NOT NULL DEFAULT '80',
  `hpa_target_mem` int(10) NOT NULL DEFAULT '4096',
  `min_ready_seconds` int(10KEY (`cluster_name`, `node_name`, `label`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tb_app_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(64) NOT NULL DEFAULTCOMMENT '10namespace',
  `max`app_surge`name` intvarchar(1064) NOT NULL DEFAULTCOMMENT '1app_name',
  `max`main_unavailable`version` intvarchar(1032) NOT NULL DEFAULTCOMMENT '0major version',
  `status``version_count` tinyintint(411) NOT NULL DEFAULT '0' COMMENT 'statur:0:init,1:success,2:fail,3:logical del,4:delminor version',
  `update_time` timestamp`image` varchar(256) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'image',
  `create`repository_time` timestampid` varchar(64) NOT NULL DEFAULT '' COMMENT 'repository_id',
  PRIMARY`port` KEY varchar(`id`1024), NOT NULL UNIQUEDEFAULT KEY'0' `namespace` (`namespace`,`app_name`,`main_version`,`version_count`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `tb_deploy_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL COMMENT 'name',
  `namespace` varchar(64) NOT NULL COMMENT 'namespace',
  `app_name` varchar(64) NOT NULL COMMENT 'app_name',
  `version` varchar(48) NOT NULL COMMENT 'version',
  `cluster` varchar(64) NOT NULL COMMENT 'cluster',
  `node_label` varchar(64COMMENT 'port',
  `env` varchar(1024) NOT NULL DEFAULT '' COMMENT 'env',
  `volume` varchar(1024) NOT NULL DEFAULT '' COMMENT 'volume',
  `dependence` varchar(1024) NOT NULL DEFAULT '' COMMENT '',
  `replicas` int(10) NOT NULL DEFAULT '1' COMMENT 'replicas',
  `command` varchar(512) NOT NULL DEFAULT '' COMMENT 'command',
  `deploy_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'deploy_type: 0:deployment, 1:daemonset',
  `gpu` int(10) NOT NULL DEFAULT '0',
  `request_cpu` int(10) NOT NULL DEFAULT 'all80',
  `status``request_mem` tinyintint(410) NOT NULL DEFAULT '0' COMMENT 'status'4096',
  `editable``limit_cpu` tinyintint(410) NOT NULL DEFAULT '1' COMMENT 'editable: 0:no，1:yes'80',
  `running``limit_mem` tinyintint(410) NOT NULL DEFAULT '0' COMMENT 'running: 0:no，1:yes'4096',
  `deploy`min_type`replicas` tinyintint(410) NOT NULL DEFAULT '0' COMMENT 'deploy_type: 0:new,1:upgrade,2:rollback,3:del',
  `comment``max_replicas` varcharint(25610) NOT NULL DEFAULT '' COMMENT 'comment5',
  `audit`is_comment`hpa` varchartinyint(2564) NOT NULL DEFAULT '0' COMMENT 'auditis_commenthpa：0：no，1：yes',
  `error`hpa_target_message`cpu` varcharint(25610) NOT NULL DEFAULT '80' COMMENT 'error_message,
  `hpa_target_mem` int(10) NOT NULL DEFAULT '4096',
  `update`min_ready_time` timestampseconds` int(10) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'10',
  `create`max_time` timestampsurge` int(10) NOT NULL DEFAULT '1',
  `execute`max_time` timestampunavailable` int(10) NOT NULL,   PRIMARY KEY (`id`)DEFAULT '0',
  KEY`status` `name` (`namespace`,`name`),
  KEY `namespace` (`namespace`,`app_name`,`cluster`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS tb_domain_info (
  `id`       BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `namespace`  varchar(64) NOT NULL COMMENT 'namespace',
  `domain`   varchar(128) NOT NULL COMMENT 'domain',
  `used_count`   int NOT NULL DEFAULT 0 COMMENT 'used_count',
  `update_time`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time`  TIMESTAMP NOT NULL,
  PRIMARY KEY(`id`),
  KEY(`namespace`),
  UNIQUE KEY(`domain`)
) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS tb_ingress_info (
  `id`         BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `namespace`  tinyint(4) NOT NULL DEFAULT '0' COMMENT 'statur:0:init,1:success,2:fail,3:logical del,4:del',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ,
  `create_time` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `namespace` (`namespace`,`app_name`,`main_version`,`version_count`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `tb_deploy_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL COMMENT 'name',
  `namespace` varchar(64) NOT NULL COMMENT 'namespace',
  `app_name` varchar(64) NOT NULL COMMENT 'app_name',
  `version` varchar(48) NOT NULL COMMENT 'version',
  `cluster` varchar(64) NOT NULL COMMENT 'cluster',
  `node_label` varchar(64) NOT NULL COMMENTDEFAULT 'namespaceall',
  `domain`     varchar(128`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'domainstatus',
  `editable` tinyint(4) NOT NULL `uri`DEFAULT '1' COMMENT 'editable: 0:no，1:yes',
  `running` varchartinyint(1284) NOT NULL NULL DEFAULT '0' COMMENT 'urirunning: 0:no，1:yes',
  `is`deploy_rewrite` int8type` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'deploy_type: 0:new,1:upgrade,2:rollback,3:del',
  `deploy_name` `comment` varchar(64256) NOT NULL DEFAULT '' COMMENT 'deploy namecomment',
  `status`       tinyint(4`audit_comment` varchar(256) NOT NULL DEFAULT '0' COMMENT 'statusaudit_comment',
  `unique_key`
  `error_message` varchar(64256) NOT NULL DEFAULT 'unique key' COMMENT 'error_message',
  `update_time` timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time`  TIMESTAMPtimestamp NOT NULL,
  `execute_time` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY  UNIQUE`name` (`namespace`,`name`),
  KEY `namespace` (`namespace`,`unique_key``app_name`,`cluster`,`version`)
) ENGINE = InnoDB DEFAULT CHARACTER SET CHARSET= utf8;

CREATE TABLE  IF NOT EXISTS `tbtb_halodomain_service`info (
  `id` bigint(20) unsigned       BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `service_name``namespace`  varchar(64) NOT NULL COMMENT 'service_namenamespace',
  `package` `domain`    varchar(64128) NOT NULL COMMENT 'packagedomain',
  `used_count`   int NOT NULL DEFAULT 0 COMMENT 'used_count',
  `update_time` timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time` timestamp TIMESTAMP NOT NULL,
  PRIMARY KEY(`id`),
  KEY(`id``namespace`),
  UNIQUE KEY `service_name` (`service_name`(`domain`)
) ENGINE = InnoDB DEFAULT CHARACTER CHARSETSET = utf8;

CREATE TABLE IF NOT EXISTS tb_haloingress_packageinfo (
  id`id`         BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `namespace` package_name varchar(64) NOT NULL COMMENT 'package_namenamespace',
  reserve_num int NOT NULL DEFAULT 2 COMMENT 'reserve_num',
  source_type varchar(16`domain`     varchar(128) NOT NULL COMMENT 'source_type',
  update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  create_time TIMESTAMP NOT NULL,
  PRIMARY KEY(`id`),
  UNIQUE KEY(`package_name`)
) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS tb_halo_command (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  name varchar(64domain',
  `uri`        varchar(128) NOT NULL COMMENT 'uri',
  `is_rewrite` int8 NOT NULL DEFAULT 0 COMMENT '',
  `deploy_name`  varchar(64) NOT NULL COMMENT 'deploy name',
  `status`       tinyint(4) NOT NULL DEFAULT '0' COMMENT 'jobNamestatus',
  job`unique_idkey`   varchar(5064) NOT NULL COMMENTDEFAULT 'jobIDunique key',
  command`update_infotime`  textTIMESTAMP NOT NULL COMMENTDEFAULT 'command_info with base64'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  create`create_timetime`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(`id`),
  UNIQUE KEY `name` (`name`(`namespace`,`unique_key`)
) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS `tb_alert_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `instance` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'alert host',
  `ipaddr` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'alert ip',
  `alert_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'alert name',
  `alert_user` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'alert user',
  `limit_value` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'alert limit value',
  `current_value` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'current alert value',
  `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'description',
  `generator_url` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '',
  `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'status',
  `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time` TIMESTAMP NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY(`instance`, `alert_name`,`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

...

Code Block
git clone https://gerrit.akraino.org/r/aiedge.git cd ote-stack/aiedge/deploymentdeployments vim interface_conf

Running

...

Versions Compared

Old Version 4

New Version 5

Key

License

How to use this document

Minimum Hardware Requirements

Recommended Hardware Requirements

Software Prerequisites

Database Prerequisites

(option)

Schema scripts

Running

Page Comparison

Versions Compared

Old Version 4

New Version 5

Key

License

How to use this document

Minimum Hardware Requirements

Recommended Hardware Requirements

Software Prerequisites

Database Prerequisites

(option)

Schema scripts

Running