aodh: 3、aodh资源模型

目标:
掌握aodh资源模型与主要表结构

目录:
1 进入数据库
2 alarm资源模型
3 alarm_history资源模型

1 进入数据库
cat /etc/aodh/aodh.conf|grep mysql
connection = mysql+pymysql://aodh:ct15k08j@mariadb.openstack.svc.cluster.local:3306/aodh

mysql -uaodh -pct15k08j
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 715428
Server version: 10.1.30-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use aodh;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [aodh]> show tables;
+-----------------+
| Tables_in_aodh  |
+-----------------+
| alarm           |
| alarm_history   |
| alembic_version |
+-----------------+

2 alarm资源模型
alarm表作用: 存储云平台创建的告警

MariaDB [aodh]> desc alarm;
+---------------------------+---------------+------+-----+---------+-------+
| Field                     | Type          | Null | Key | Default | Extra |
+---------------------------+---------------+------+-----+---------+-------+
| alarm_id