We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Infrastructure Monitoring with Postgres

Formal Metadata

Title
Infrastructure Monitoring with Postgres
Title of Series
Number of Parts
611
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production Year2017

Content Metadata

Subject Area
Genre
Abstract
The revolt against SQL continues at a steady but considerably slower pace.Bespoke database software seems to crop up daily in the name of performance orfunctionality. This talk will examine the ever growing field of monitoringsystems and their respective databases, and look in depth as to how Postgrescan be used in a number of these places. Systems of this nature are typicallytasked with collecting and storing metrics from your infrastructure, drawingpretty graphs, and nagging you when things break. Forms of data stored by these systems are nothing to be afraid of - they ofteninclude: \- Time series metrics - the history of a measurement over time, e.g.temperatures \- Logs - unstructured text emitted by applications, operatingsystems and hardware \- Events - schema-less but well structured notifications An assertion of this talk is that for a majority of use cases, Postgres ismore than capable of storing all of this data. We will attempt to replacenumerous well known pieces of software with just one Postgres database. Ofcourse we are told to use the right tool for the job, but having to learn andoperate a single tool is a huge operational advantage. We’ll get quite technical in this talk, take a look the data models and accesspatterns required, and how this can be fitted into the general purposeenvironment of Postgres. Additionally, it is always constructive to look atwhat can be problematic, and not just focus on the positives, and why manyturn to other bespoke solutions.