当在生产环境下使用某种服务时,相应的监控措施也应当完善起来,来检测服务是否正常和获取相关信息是很有必要的。
下面来说说使用nagios-plugin-mongodb来监控mongodb数据库。https://github.com/mzupan/nagios-plugin-mongodb文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
1. 下载check_mongodb nagios插件文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
# cd /usr/local/nagios/libexec/ # wget --no-check-certificate https://github.com/mzupan/nagios-plugin-mongodb/archive/master.zip # unzip master # mv nagios-plugin-mongodb-master nagios-plugin-mongodb # chown -R nagios.nagios nagios-plugin-mongodb/
2. 安装Mongo Python驱动文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
需要先安装EPEL源。参见《CentOS / RHCE 可供使用的yum》。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
# yum install pymongo.x86_64
或者自己下载源码包编译。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
# wget --no-check-certificate https://github.com/mongodb/mongo-python-driver/archive/master.zip # unzip mongo-python-driver-master.zip # cd mongo-python-driver-master # python setup.py install
或通过python easy_install来安装。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
# easy_install pymongo
3. check_mongodb.py 说明文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
# ./check_mongodb.py --help usage: check_mongodb.py [options] This Nagios plugin checks the health of mongodb. options: -h, --help show this help message and exit -H HOST, --host=HOST The hostname you want to connect to -P PORT, --port=PORT The port mongodb is runnung on -u USER, --user=USER The username you want to login as -p PASSWD, --pass=PASSWD The password you want to use for that user -W WARNING, --warning=WARNING The warning threshold we want to set -C CRITICAL, --critical=CRITICAL The critical threshold we want to set -A ACTION, --action=ACTION The action you want to take --max-lag Get max replication lag (for replication_lag action only) --mapped-memory Get mapped memory instead of resident (if resident memory can not be read) -D, --perf-data Enable output of Nagios performance data -d DATABASE, --database=DATABASE Specify the database to check --all-databases Check all databases (action database_size) -s, --ssl Connect using SSL -r, --replicaset Connect to replicaset -q QUERY_TYPE, --querytype=QUERY_TYPE The query type to check [query|insert|update|delete|getmore|command] from queries_per_second -c COLLECTION, --collection=COLLECTION Specify the collection to check -T SAMPLE_TIME, --time=SAMPLE_TIME Time used to sample number of pages faults
Nagios MongoDB监控插件的所有动作:文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
通过参数-A来传递下列任一动作。这些动作有:'connect', 'connections', 'replication_lag', 'replication_lag_percent', 'replset_state', 'memory', 'memory_mapped', 'lock', 'flushing', 'last_flush_time', 'index_miss_ratio', 'databases', 'collections', 'database_size', 'database_indexes', 'collection_indexes', 'queues', 'oplog', 'journal_commits_in_wl', 'write_data_files', 'journaled', 'opcounters', 'current_lock', 'replica_primary', 'page_faults', 'asserts', 'queries_per_second', 'page_faults', 'chunks_balance', 'connect_primary', 'collection_state', 'row_count'文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
connect – 默认动作. 检查连接 connections – 检查打开的数据库连接的百分比 memory – 检测内存使用量 memory_mapped – 检查映射内存的使用情况 lock – 检查锁定时间的百分比 flushing – 检查平均flush时间(以微秒) last_flush_time – 检查上次刷新时间(以微秒) index_miss_ratio – 检查索引命中失败率 databases – 检查数据库的总数 collections – 检查集合的总数 database_size – 检查特定数据库的大小 database_indexes – 检查特定数据库的索引大小 collection_indexes – 检查一个集合的索引大小 replication_lag – 检查复制延迟(以秒为单位) replication_lag_percent – 检查复制延迟(以百分比表示) replset_state – 检查副本集的状态 replica_primary – 检查副本集的主服务器 queries_per_second – 检查每秒查询量 connect_primary – 检查连接在一组中的主服务器 collection_state – 检查数据库中特定集合的状态
4. 定义nagios command文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
# vim /usr/local/nagios/etc/objects/commands.cfg define command { command_name check_mongodb command_line $USER1$/nagios-plugin-mongodb/check_mongodb.py -H $ARG1$ -P $ARG2$ -u $ARG3$ -p $ARG4$ -A $ARG5$ -W $ARG6$ -C $ARG7$ } define command { command_name check_mongodb_database command_line $USER1$/nagios-plugin-mongodb/check_mongodb.py -H $ARG1$ -P $ARG2$ -u $ARG3$ -p $ARG4$ -A $ARG5$ -W $ARG6$ -C $ARG7$ -d $ARG8$ } define command { command_name check_mongodb_collection command_line $USER1$/nagios-plugin-mongodb/check_mongodb.py -H $ARG1$ -P $ARG2$ -u $ARG3$ -p $ARG4$ -A $ARG5$ -W $ARG6$ -C $ARG7$ -d $ARG8$ -c $ARG9$ } define command { command_name check_mongodb_replicaset command_line $USER1$/nagios-plugin-mongodb/check_mongodb.py -H $ARG1$ -P $ARG2$ -u $ARG3$ -p $ARG4$ -A $ARG5$ -W $ARG6$ -C $ARG7$ -r $ARG8$ } define command { command_name check_mongodb_query command_line $USER1$/nagios-plugin-mongodb/check_mongodb.py -H $ARG1$ -P $ARG2$ -u $ARG3$ -p $ARG4$ -A $ARG5$ -W $ARG6$ -C $ARG7$ -q $ARG8$ }
5. 创建监控项文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
5.1 Check Connection 需要监控集群中每台mongodb实例。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Connect Check check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!connect!2!4 }
5.2 Check Percentage of Open Connections 检查空闲连接率文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Free Connections check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!connections!70!80 }
5.3 Check Replication Lag 检测复制延迟文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Replication Lag check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!replication_lag!15!30 }
5.4 Check Replication Lag Percentage 检查复制滞后百分比。如果检查达到100%的话就需要完全重新同步。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Replication Lag Percentage check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!replication_lag_percent!50!75 }
5.5 Check Memory Usage 检查内存使用情况文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Memory Usage check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!memory!20!28 }
5.6 Check Mapped Memory Usage 检查mongodb映射内存使用情况文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Mapped Memory Usage check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!memory_mapped!20!28 }
5.7 Check Lock Time Percentage 检查锁定时间百分比。如果有锁定时间通常意味着数据库已经超载。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Lock Percentage check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!lock!5!10 }
5.8 Check Average Flush Time 检查平均刷新时间。如果平均刷新时间高就意味着数据库存在大量写。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Flush Average check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!flushing!100!200 }
5.9 Check Last Flush Time 检查最后刷新时间。如果最后刷新时间高就意味着服务器可能存在IO压力,需要更换更快的磁盘。文章源自运维生存时间-https://www.ttlsa.com/mongodb/nagios-check_mongodb-plugin-to-monitor-mongodb/
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Last Flush Time check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!last_flush_time!200!400 }
5.10 Check status of mongodb replicaset 检查的MongoDB replicaset状态
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB state check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!replset_state!0!0 }
5.11 Check status of index miss ratio 检查索引命中失败率。如果该值高,需要考虑添加索引了。
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Index Miss Ratio check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!index_miss_ratio!.005!.01 }
5.12 Check number of databases and number of collections
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Number of databases check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!databases!300!500 } define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Number of collections check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!collections!300!500 }
5.13 Check size of a database 检查数据库的大小。跟踪数据增长率。
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Database size db_ttlsa_posts check_command check_mongodb_database!10.1.11.155!27017!check_mongodb!www.ttlsa.com!database_size!300!500!db_ttlsa_posts }
5.14 Check index size of a database 检查数据库的索引大小
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Database index size db_ttlsa_posts check_command check_mongodb_database!10.1.11.155!27017!check_mongodb!www.ttlsa.com!database_indexes!50!100!db_ttlsa_posts }
5.15 Check index size of a collection 检查一个集合的索引大小
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Database index size db_ttlsa_posts check_command check_mongodb_collection!10.1.11.155!27017!check_mongodb!www.ttlsa.com!collection_indexes!50!100!db_ttlsa_posts!posts }
5.16 Check the primary server of replicaset 检查replicaset的主服务器
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Replicaset Master Monitor: replset_ttlsa check_command check_mongodb_replicaset!10.1.11.155!27017!check_mongodb!www.ttlsa.com!replica_primary!0!1!replset_ttlsa }
5.17 Check the number of queries per second 检查每秒查询数量。这将检查服务器上每秒查询数量,类型有:query|insert|update|delete|getmore|command
define service { use generic-service hostgroup_name Mongo Servers service_description MongoDB Updates per Second check_command check_mongodb_query!10.1.11.155!27017!check_mongodb!www.ttlsa.com!queries_per_second!200!150!update }
5.18 Check Primary Connection
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Connect Check check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!connect_primary!2!4 }
5.19 Check Collection State 检测集合状态
define service { use generic-service hostgroup_name Mongo Servers service_description Mongo Collection State check_command check_mongodb!10.1.11.155!27017!check_mongodb!www.ttlsa.com!collection_state!db_ttlsa_posts!posts }
转载请注明来自运维生存时间: https://www.ttlsa.com/html/4188.html
2F
北哥你个贱人跑四川就没人影了,这个监控的mongodb服务器上面要做哪些配置都没说,还有直接运行有数据,监控平台看都是null怎么回事
B1
@ 张总 怎么会
1F
监控结果是 (null),怎么解决啊?我直接运行./check_mongodb.py -H localhost -p 27017 -W 2 -C 4,显示正常(OK – Connection took 0 seconds)。