Zabbix应用八:Zabbix监控MongoDB

利用Zabbix监控MongoDB

一、首先介绍mongodb采集到的数据含义:

1、状态采集命令:

>db.serverStatus();

2、输出内容:

{
    "host" : "localhost",
    "version" : "2.2.6",
    "process" : "mongod",
    "pid" : 55123,
    "uptime" : 18654536,
    "uptimeMillis" : NumberLong(""),
    "uptimeEstimate" : 18407100,
    "localTime" : ISODate("2017-07-10T08:06:17.628Z"),
    "locks" : {
        "." : {
            "timeLockedMicros" : {
                "R" : NumberLong(1203), #所有库全局读锁总微秒数
                "W" : NumberLong(1607)  #所有全库局写锁总微妙数
            },
            "timeAcquiringMicros" : {
                "R" : NumberLong(168),  #所有库全局读锁的锁等待总微秒数
                "W" : NumberLong(41)    #所有库全局写锁的锁等待总微秒数
            }
        },
        "admin" : {
            "timeLockedMicros" : {                  },
            "timeAcquiringMicros" : {            }
        },
        "local" : {
            "timeLockedMicros" : {
                "r" : NumberLong(4118711),
                "w" : NumberLong(0)
            },
            "timeAcquiringMicros" : {
                "r" : NumberLong(2191541),
                "w" : NumberLong(0)
            }
        },
        "org_center" : {
            "timeLockedMicros" : {
                "r" : NumberLong(""),
                "w" : NumberLong("")
            },
            "timeAcquiringMicros" : {
                "r" : NumberLong(352664878),
                "w" : NumberLong("")
            }
        },
        "org_centr" : {
            "timeLockedMicros" : {
                "r" : NumberLong(124236),
                "w" : NumberLong(180)
            },
            "timeAcquiringMicros" : {
                "r" : NumberLong(10119),
                "w" : NumberLong(10)
            }
        },
        "shopProduct" : {
            "timeLockedMicros" : {
                "r" : NumberLong(134997),
                "w" : NumberLong(0)
            },
            "timeAcquiringMicros" : {
                "r" : NumberLong(14241),
                "w" : NumberLong(0)
            }
        },
        "tb_shop" : {
            "timeLockedMicros" : {
                "r" : NumberLong(1405192),
                "w" : NumberLong(0)
            },
            "timeAcquiringMicros" : {
                "r" : NumberLong(146122),
                "w" : NumberLong(0)
            }
        },
        "test" : {
            "timeLockedMicros" : {
                "r" : NumberLong(3090622),
                "w" : NumberLong(2170)
            },
            "timeAcquiringMicros" : {
                "r" : NumberLong(414040),
                "w" : NumberLong(130)
            }
        }
    },
    "globalLock" : {
        "totalTime" : NumberLong(""),
        "lockTime" : NumberLong(1607),
        "currentQueue" : {
            "total" : 0,
            "readers" : 0,
            "writers" : 0
        },
        "activeClients" : {
            "total" : 0,
            "readers" : 0,
            "writers" : 0
        }
    },
    "mem" : {
        "bits" : 64,         #64位操作系统
        "resident" : 238,    #共占用屋里内存M
        "virtual" : 448,     #占用虚拟内存
        "supported" : true,
        "mapped" : 256       #映射内存
    },
    "connections" : {
        "current" : 16,      #当前活跃连接数
        "available" : 803    #剩余空闲连接数
    },
    "extra_info" : {
        "note" : "fields vary by platform",
        "heap_usage_bytes" : 30607592,
        "page_faults" : 200
    },
    "indexCounters" : {
        "btree" : {
            "accesses" : 24067164,  #索引被访问次数
            "hits" : 24067164,      #索引命中量
            "misses" : 0,
            "resets" : 0,
            "missRatio" : 0
        }
    },
    "backgroundFlushing" : {
        "flushes" : 310905,                   #数据库刷新写到磁盘的次数
        "total_ms" : 214212,                  #数据库刷新数据到磁盘花费的微秒数
        "average_ms" : 0.688995030636368,     #执行单次刷新花费的平均微秒数
        "last_ms" : 5,
        "last_finished" : ISODate("2017-07-10T08:05:26.598Z")
    },
    "cursors" : {
        "totalOpen" : 0,
        "clientCursors_size" : 0,
        "timedOut" : 60
    },
    "network" : {
        "bytesIn" : 5150258135,       #流入数据库总量
        "bytesOut" : 10535203727,     #从数据库流出总量
        "numRequests" : 32203604      #数据库总请求数
    },
    "opcounters" : {
        "insert" : 6010564,       #总insert数据量
        "query" : 7507450,        #总query数据量
        "update" : 573085,        #总update数据量
        "delete" : 2563194,       #总delete数据量
        "getmore" : 308,          #游标调用的getMore总次数
        "command" : 16077462      #执行命令的总次数
    },
    "asserts" : {
        "regular" : 0,
        "warning" : 0,
        "msg" : 0,
        "user" : 37,
        "rollovers" : 0
    },
    "writeBacksQueued" : false,
    "recordStats" : {
        "accessesNotInMemory" : 0,
        "pageFaultExceptionsThrown" : 0,
        "org_center" : {
            "accessesNotInMemory" : 0,
            "pageFaultExceptionsThrown" : 0
        },
        "tb_shop" : {
            "accessesNotInMemory" : 0,
            "pageFaultExceptionsThrown" : 0
        },
        "test" : {
            "accessesNotInMemory" : 0,
            "pageFaultExceptionsThrown" : 0
        }
    },
    "ok" : 1
}

zabbix监控页面的主要数据开源就是这里。

3、利用zabbix用户自定义监控功能 userparameter 来监控MongoDB:

　　3.1、修改zabbix_agentd.conf，允许接受自定义参数:

UnsafeUserParameters=1

　　3.2、定义数据采集命令:

UserParameter=MongoDB.status[*],/bin/echo "db.serverStatus().$1" |/data/mongodb/bin/mongo admin | grep "$2" | awk -F ':' '{print $$2}' | awk -F ',' '{print $$1}'

　　注意:不同环境，请注意主机ip和端口号等。

4、zabbix监控页面新建监控模版、添加监控项、生成图形:

创建模版:Template App MongoDB（已经手动创建完毕，并创建监控项，需要者可自行下载）

由于监控项众多，本例只贴出其中一个监控项的配置，如下图:

需要注意的是 键值 项，需和 UserParameter 中定义的格式一致。

5、模版创建完成后，套用到被监控的主机即可。

最终效果如下图:

<!–
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #29f914; background-color: #000000}
span.s1 {font-variant-ligatures: no-common-ligatures}
–>