...
A mysql database is required to store to store the related metadata of OTE models, like users, businesses, projects, apps, deployments, clusters, nodes, etc. The database `sys When the OTE runs, the OpenAPI Server will connect to the database "sys_ote_manage_platform` consists of following tablesplatform" for providing services. Some brief description of tables which related to this database are shown below:
- tb_system_config stores global configuration of OTE web portal.
- tb_business_info maintains the relation between the users of OTE 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 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 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 the edge cluster. If you need to store the these OTE metadata in your own database, you can execute the following schema script to create the database and the related tables.
...