check_greenplum

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

You must be logged in to submit a review.

Your review has been submitted and is pending approval.

Your recommendation has been sent.

Project Overview Project Files Project Notes Reviews