Rootconf 2015

DevOps and scaling infrastructure

Himanchali

@himanchali

Logstash, statsd and graphite combo for PostgreSQL log monitoring

Submitted Mar 31, 2015

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.

Outline

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

  • Final performance

  • Kind of metrics generated and their usage

Speaker bio

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.

Comments

{{ gettext('Login to leave a comment') }}

{{ gettext('Post a comment…') }}
{{ gettext('New comment') }}
{{ formTitle }}

{{ errorMsg }}

{{ gettext('No comments posted yet') }}

Hosted by

We care about site reliability, cloud costs, security and data privacy