用于存储SNMP数据的数据库方案

时间:2022-08-08 16:59:46

I am trying to build a MYSQL DB for storing SNMP MIB information (a small subset of OIDs only).. Is there a DB schema that I may refer to?

我正在尝试构建一个MYSQL DB来存储SNMP MIB信息(仅一小部分OID)。我可以参考一个DB模式吗?

Thanks, Neel

谢谢,尼尔

1 个解决方案

#1


0  

I've been thinking about this of late. I would hazard a guess that you just map your MIB types to whatever fits your database e.g. Unsigned32 in the MIB would be UNSIGNED INT in SQL. Then use the OID as your primary key.

我最近一直在考虑这件事。我猜你只是将你的MIB类型映射到适合你数据库的任何类型,例如: MIB中的Unsigned32将是SQL中的UNSIGNED INT。然后使用OID作为主键。

#1


0  

I've been thinking about this of late. I would hazard a guess that you just map your MIB types to whatever fits your database e.g. Unsigned32 in the MIB would be UNSIGNED INT in SQL. Then use the OID as your primary key.

我最近一直在考虑这件事。我猜你只是将你的MIB类型映射到适合你数据库的任何类型,例如: MIB中的Unsigned32将是SQL中的UNSIGNED INT。然后使用OID作为主键。