Accessing Command Center Data using SNMP

Post date: Nov 08, 2012 8:51:45 PM

You can configure a Greenplum system to trigger SNMP alerts or send email notifications to system administrators whenever certain database events occur.

Greenplum’s gpsnmpd agent is an SNMP (Simple Network Management Protocol) daemon that supports SNMP requests on the health and state of a Greenplum system by using a set of MIBs (Management Information Bases).

MIBs are a collection of objects that describe an SNMP-manageable entity — in this case, a Greenplum system. MIBs can be used by enterprise monitoring systems such

as IBM Tivoli, HP Openview, and Nagios to monitor our Greenplum system.

SNMP on the Greenplum Data Computing Appliance

For more information about SNMP on the DCA, see the Greenplum Data Computing Appliance Getting Started Guide. 

Starting with Greenplum Data Computing Appliance version 1.2, we have a new MIB definition that will help you monitor software and hardware as follows:

•Software

•Version information

•Database

•Hadoop

•Hardware

•Master Node

•Segment Nodes

•Interconnect switches

•DIA/ETL loads

•Hadoop Master Nodes

•Hadoop Worker Nodes

•Admin switches

SNMP on Greenplum Database

For more information about SNMP on the Greenplum Database software-only, see chapter 18, Monitoring a Greenplum System, in Greenplum Database Administrator Guide.

There are the following two MIB definitions for Greenplum Database:

•RDBMS-MIB

•NETWORK-SERVICES-MIB