Logstash, statsd and graphite combo for PostgreSQL log monitoring
Submitted by Himanchali (@himanchali) on Tuesday, 31 March 2015
Section: Full talk Technical level: Beginner
The session (full length talk of 40 mins) will aim to explain the use case of log monitoring done for Postgres DB server with the help of logstash, statsd and graphite. The same combination can be used for other logs as well.
Mindmap Link for the session: http://i.imgur.com/cYti1E1.jpg
When you have a system where the DB server is generating 1GB log per 10 minutes, monitoring those logs for different kind of performance and security analysis is a big challenge.
The session will cover the monitoring setup for db server logs using the 3 opensource tools and how these graphs can help in analysis improvement.
The key points covered:
Introduction of the used tools
The basic setup of these tools
The basic conf setup
Proper aggregation of metrics
Issues faced during setup and their solution
Kind of metrics generated and their usage
I am currently working as Tech lead Production & Infra Engg @ Inmobi. Other than being part of DBE team, has been involved in evaluating and implementing open source tools for production environment.