/mymon

MySQL Monitor Script

Primary LanguageGoApache License 2.0Apache-2.0

Introduction

mymon(MySQL-Monitor) -- MySQL数据库运行状态数据采集脚本，采集包括global status, global variables, slave status等。

Installation

# set $GOPATH and $GOROOT

mkdir -p $GOPATH/src/github.com/open-falcon
cd $GOPATH/src/github.com/open-falcon
git clone https://github.com/open-falcon/mymon.git

cd mymon
go get ./...
go build -o mymon

echo '* * * * * cd $GOPATH/src/github.com/open-falcon/mymon && ./mymon -c etc/mon.cfg' > /etc/cron.d/mymon

Configuration

    [default]
    log_file=mymon.log # 日志路径和文件名
    # Panic 0
    # Fatal 1
    # Error 2
    # Warn 3
    # Info 4
    # Debug 5
    log_level=4 # 日志级别

    falcon_client=http://127.0.0.1:1988/v1/push # falcon agent连接地址

    #自定义endpoint
    endpoint=127.0.0.1 #若不设置则使用OS的hostname

    #自动扫描多实例
    mycnf = /usr/local/mysql/my.cnf

    [mysqld]
    user=root # 数据库用户名
    password= # 数据库密码
    host=127.0.0.1 # 数据库连接地址
    port=3306 # 数据库端口

    #[mysqld3060]
    #user=root
    #password=123456
    #host=127.0.0.1
    #port=3060

    # 往kafka发送 show processlist 消息
    # {"server":"127.0.0.1:3060","processlist":[{"COMMAND":"Sleep","DB":"test","HOST":"10.10.10.10:51811","ID":"68893","INFO":"","STATE":"","TIME":"1","USER":"root"}]}
    [kafka]
    brokers = 10.10.10.10:9092
    topic=test

MySQL metrics

请参考./metrics.txt，其中的内容，仅供参考，根据MySQL的版本、配置不同，采集到的metrics也有差别。

Contributors