Page History

...

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

...

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_system_config` (
  `key` varchar(64) NOT NULL,
  `value` varchar(64)

Code Block

CREATE DATABASE sys_ote_manage_platform;
USE sys_ote_manage_platform;
SET names utf8;

CREATE TABLE IF NOT EXISTS `tb_system_config` (
  `key` varchar(64) NOT NULL,
  `value` varchar(64) NOT NULL,
  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 'namespace',
  `user_id` bigint(20) unsigned NOT NULL COMMENT 'user id',
  `introduce` varchar(512) NOT NULL COMMENT 'business introduction',
  `objective` varchar(512) NOT NULL COMMENT 'resource requirements',
  `scale` varchar(512) NOT NULL COMMENT 'business scale',
  `comment` varchar(512) NOT NULL DEFAULT '' COMMENT 'review comments',
  `status` tinyint NOT NULL DEFAULT 0 COMMENT 'status',
  `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time` TIMESTAMP NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `tb_ote_web_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) COLLATE utf8_unicode_ci 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 NOT NULL DEFAULT '' COMMENT 'real name',
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'password',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' 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 'role:0:unauthorized,1:general manager,2:admin,3:super admin',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp 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,
  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``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 'namespace',
  `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'user id',
  `namespace``introduce` varchar(64512) NOT NULL DEFAULTCOMMENT '' COMMENT 'namespacebusiness introduction',
  `repository_uid``objective` bigintvarchar(20512) unsigned DEFAULT '0'NOT NULL COMMENT 'uidresource requirements',
  `repository_username``scale` varchar(50) COLLATE utf8_unicode_ci512) NOT NULL COMMENT 'usernamebusiness scale',
  `repository_email``comment` varchar(255) COLLATE utf8_unicode_ci512) NOT NULL DEFAULT '' COMMENT 'emailreview comments',
  `repository_password` varchar(255) COLLATE utf8_unicode_ci`status` tinyint NOT NULL DEFAULT ''0 COMMENT 'passwordstatus',
  `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 (`namespace``name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='harbor user';

CREATE TABLE IF NOT EXISTS `tb_ote_web_third_repository`users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace``uid` varchar(6450) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user id',
  `namespace` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' COMMENT 'user namespace',
  `repository`user_id`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'repository idusername',
  `repository`display_url`name` varchar(50050) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'repository addrnickname',
  `repository`real_username`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'usernamereal name',
  `repository_password``password` varchar(25560) COLLATE utf8_unicode_ci NOT NULL COMMENTDEFAULT 'passwoed',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL'' COMMENT 'password',
  PRIMARY`email` KEY varchar(`id`255),
  UNIQUE KEY (`namespace`, `repository_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE= COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'email',
  `phone` varchar(11) COLLATE utf8_unicode_ci COMMENT='third repo';

CREATE TABLE IF NOT EXISTS `tb_ote_cluster_label` (
  `id` bigint(20NOT NULL DEFAULT '' COMMENT 'phone',
  `status` tinyint(4) unsigned NOT NULL AUTO_INCREMENT DEFAULT '3' COMMENT 'status: 0:pending,1:reviewed,2:failed,3:forbidden，',
  `cluster`is_name`admin` varchartinyint(643) COLLATE utf8_unicode_ciunsigned NOT NULL DEFAULT '0' COMMENT 'clusteris nameadmin',
  `label` varchar(64) COLLATE utf8_unicode_ci`role` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'labelrole:0:unauthorized,1:general manager,2:admin,3:super admin',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tb_ote_web_users_uid_unique` (`uid`) USING BTREE,
  UNIQUE KEY `tb_ote_web_users_phone_unique` (`id``phone`) USING BTREE,
  UNIQUE KEY `tb_ote_web_users_user_name_unique` (`cluster`user_name`, `label`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tb_ote_web_noderepository_label`users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(64) NOT NULL DEFAULT '' COMMENT 'namespace',
  `repository_uid` bigint(20) unsigned DEFAULT NOT'0' NULL AUTO_INCREMENTCOMMENT 'uid',
  `cluster`repository_name`username` varchar(6450) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'clusteusername',
  `node`repository_name`email` varchar(64255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'nodenameemail',
  `label``repository_password` varchar(64255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'node 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`, `node_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_appthird_info`repository` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(64)(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'user namespace',
  `app`repository_name`id` varchar(64)50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'app_namerepository id',
  `main`repository_version`url` varchar(32)500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'majorrepository versionaddr',
  `version`repository_count`username` intvarchar(11)50) COLLATE utf8_unicode_ci NOT NULL COMMENTDEFAULT 'minor' COMMENT version'username,
  `image``repository_password` varchar(256)255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'imagepasswoed',
  `repository`updated_id` varchar(64)at` timestamp NOT NULL DEFAULT '' COMMENT 'repository_id' CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `port` varchar(1024)`created_at` timestamp NOT NULL,
 DEFAULT '0'PRIMARY COMMENT 'port'KEY (`id`),
  UNIQUE KEY `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)(`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(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT 'replicascluster name',
  `command``label` varchar(512)64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'commandlabel',
  `deploy`updated_type` tinyint(4)at` timestamp NOT NULL DEFAULT '0' COMMENT 'deploy_type: 0:deployment, 1:daemonset' CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL,
  `gpu`PRIMARY KEY int(10`id`),
 NOT NULLUNIQUE DEFAULT '0',
  `request_cpu` int(10) NOT NULL DEFAULT '80',
  `request_mem` int(10) NOT NULL DEFAULT '4096',
  `limit_cpu` int(10)KEY (`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 '' COMMENT '80cluste',
  `limit`node_mem`name` intvarchar(10)64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '4096nodename',
  `min_replicas``label` intvarchar(10)64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1 NULL DEFAULT '' COMMENT 'node label',
  `max`updated_replicas` int(10)at` timestamp NOT NULL DEFAULT '5' CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is`created_hpa` tinyint(4)at` timestamp NOT NULL,
 DEFAULT '0'PRIMARY COMMENT 'is_hpa：0：no，1：yes'KEY (`id`),
  `hpa_target_cpu` int(10) NOT NULL DEFAULT '80',
  `hpa_target_mem` int(10) NOT NULL DEFAULT '4096',
  `min_ready_seconds` int(10) NOT NULL DEFAULT '10',
  `max_surge` int(10 UNIQUE KEY (`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 '1namespace',
  `max`app_unavailable`name` intvarchar(1064) NOT NULL DEFAULTCOMMENT '0app_name',
  `status``main_version` tinyintvarchar(432) NOT NULL DEFAULT '0' COMMENT 'statur:0:init,1:success,2:fail,3:logical del,4:delmajor version',
  `update`version_time` timestampcount` int(11) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT COMMENT 'minor version',
  `create_time` timestamp`image` varchar(256) NOT NULL COMMENT 'image',
  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`repository_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'repository_id',
  `port` varchar(1024) NOT NULL DEFAULT '0' COMMENT '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 'all0',
  `status``request_cpu` tinyintint(410) NOT NULL DEFAULT '0' COMMENT 'status80',
  `editable``request_mem` tinyintint(410) NOT NULL DEFAULT '1' COMMENT 'editable: 0:no，1:yes'4096',
  `running``limit_cpu` tinyintint(410) NOT NULL DEFAULT '0' COMMENT 'running: 0:no，1:yes80',
  `deploy`limit_type`mem` tinyintint(410) NOT NULL DEFAULT '0' COMMENT 'deploy_type: 0:new,1:upgrade,2:rollback,3:del4096',
  `comment``min_replicas` varcharint(25610) NOT NULL DEFAULT '' COMMENT 'comment1',
  `audit`max_comment`replicas` varcharint(25610) NOT NULL DEFAULT '' COMMENT 'audit_comment5',
  `error`is_message`hpa` varchartinyint(2564) NOT NULL DEFAULT '0' COMMENT 'erroris_messagehpa：0：no，1：yes',
  `update`hpa_target_time` timestampcpu` int(10) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'80',
  `create_time` timestamp NOT NULL,
  `execute_time` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `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`  `hpa_target_mem` int(10) NOT NULL DEFAULT '4096',
  `min_ready_seconds` int(10) NOT NULL DEFAULT '10',
  `max_surge` int(10) NOT NULL DEFAULT '1',
  `max_unavailable` int(10) NOT NULL DEFAULT '0',
  `status` 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',
  `status` tinyint(4) NOT  `domain`  NULL DEFAULT '0' COMMENT 'status',
  `editable` varchartinyint(1284) NOT NULL DEFAULT '1' COMMENT 'domaineditable: 0:no，1:yes',
  `uri`        varchar(128`running` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'urirunning: 0:no，1:yes',
  `is`deploy_rewrite` int8type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '' 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`error_key`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` timestamp NOT NULL,
  `execute_time` TIMESTAMPtimestamp 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,
  `namespace`  varchar(64) NOT NULL COMMENT 'namespace',
  `service_name``domain`   varchar(64128) NOT NULL COMMENT 'service_namedomain',
  `package``used_count`   int NOT varchar(64) NOT NULLNULL DEFAULT 0 COMMENT 'packageused_count',
  `update_time` timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_time`  timestampTIMESTAMP NOT NULL,
  PRIMARY KEY(`id`),
  KEY(`id``namespace`),
  UNIQUE KEY `service_name` (`service_name`(`domain`)
) ENGINE = InnoDB DEFAULT CHARACTER SET CHARSET= utf8;


CREATE TABLE IF NOT EXISTS tb_halo_package (
  idCREATE TABLE IF NOT EXISTS tb_ingress_info (
  `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`domain`     varchar(16128) NOT NULL COMMENT 'source_typedomain',
  update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  create_time TIMESTAMP`uri`        varchar(128) NOT NULL,
  PRIMARY KEY(`id`)COMMENT 'uri',
  UNIQUE KEY(`package_name`)
) ENGINE = InnoDB`is_rewrite` int8 NOT NULL DEFAULT CHARACTER0 SET = utf8;

CREATE TABLE IF NOT EXISTS tb_halo_command (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  name varchar(64COMMENT '',
  `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

...

Space shortcuts

Page tree

Versions Compared

Old Version 4

New Version 5

Key