Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_greenplum
Meet The New Nagios Core Services Platform
Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.
Monitoring Made Magically Better
- Nagios Core on Overdrive
- Powerful Monitoring Dashboards
- Time-Saving Configuration Wizards
- Open Source Powered Monitoring On Steroids
- And So Much More!
currently implemented
- check ability to login
- check ability to select from tables
- check ability to create temp table
- check status of segments in clusters
A nagios check to go in and check various Greenplum availability pieces
GENERAL OPTIONS:
-t, --timeout Plugin timeout in seconds [default=300]
-U, --username Username to connect with (mandatory)
-P, --password Password to connect with (mandatory)
-H, --dbhost Database Hostname to connect to (mandatory)
-D, --db Database to connect to (mandatory)
TESTS:
Check to see if Greenplum accepts a connection
This is the default check
--do-connect-test
Check to see if getting data from a table works
The check executes a SELECT count by segment_id query
for the specified table. This could also be used to
setup SLA checks for getting data from the db
--do-select-test
--select-schema Schema for Select check (mandatory)
--select-table Table for Select check (mandatory)
Check to see if table creation works
The check creates a temp table with and id(int) and
vlas(char) columns and set the distributed by to id.
This helps to monitor if the catalog queries and table
creation are happening in a reasonable amount of table
--do-create-test
--create-table Table for Create check (mandatory)
Check to see if GP considers any segments offline
Query the gp_configuration (3.x) and gp_segment_configuration (4.x)
tables to see if any segments are marked down at the master level.
Currently this will crit if any show down.
--do-3x-all-segments-valid
--do-4x-all-segments-valid
GENERAL OPTIONS:
-t, --timeout Plugin timeout in seconds [default=300]
-U, --username Username to connect with (mandatory)
-P, --password Password to connect with (mandatory)
-H, --dbhost Database Hostname to connect to (mandatory)
-D, --db Database to connect to (mandatory)
TESTS:
Check to see if Greenplum accepts a connection
This is the default check
--do-connect-test
Check to see if getting data from a table works
The check executes a SELECT count by segment_id query
for the specified table. This could also be used to
setup SLA checks for getting data from the db
--do-select-test
--select-schema Schema for Select check (mandatory)
--select-table Table for Select check (mandatory)
Check to see if table creation works
The check creates a temp table with and id(int) and
vlas(char) columns and set the distributed by to id.
This helps to monitor if the catalog queries and table
creation are happening in a reasonable amount of table
--do-create-test
--create-table Table for Create check (mandatory)
Check to see if GP considers any segments offline
Query the gp_configuration (3.x) and gp_segment_configuration (4.x)
tables to see if any segments are marked down at the master level.
Currently this will crit if any show down.
--do-3x-all-segments-valid
--do-4x-all-segments-valid
Reviews (0)
Be the first to review this listing!