Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 the users of OTE users and the 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 of harbor server for pulling docker images when applications are being deployed
  • 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 deployments related to the application that stored in tb_app_info.
  • tb_alert_info displays alert messages sent by alertmanager server

Following the installation steps below, a new mysql database container, which contains the configuration and db tables of OTE, will be deployed to edge cluster. If you need to store the OTE metadata in your own database, you can execute the following schema script to create the database and the related tables.

...