Public | Automated Build

Last pushed: 4 months ago
Short Description
monitors the slow query logs in the RDS(pgsql) and notifies the event to the slack channel.
Full Description

rds-pgsql-slowlog-monitor

This repository provides a docker image which monitors the slow query logs in the RDS(postgresql engine) and notifies the event to the slack channel.

Architecture

[RDS(pgsql)] --(slow query log)--> {[fluentd on docker]} --(incoming webhook)--> [slack channel]

HowToUse

Requirement

This docker image requires IAM role which has the privilege to fetch RDS log file data from your RDS(pgsql).

Configuration

RDS(pgsql)

slow query logが出力されるようにRDSのparameter groupの設定値を調整してください。

docker image

環境変数によって、対象にするRDS/slackの通知先を変更します。

see sample.env.

HowToRun

環境変数はsample.envを参考に、dotenvのフォーマットでファイルにまとめておくと便利です。

# pull the docker image
docker pull leonisandco/rds-pgsql-slowlog-monitor:latest

# just run , not as a daemon
docker run -it --rm --env-file dot.env leonisandco/rds-pgsql-slowlog-monitor:latest

# run as a daemon
docker run -d --env-file dot.env leonisandco/rds-pgsql-slowlog-monitor:latest

License

MIT

Docker Pull Command
Owner
leonisandco

Comments (0)