Presented by:

02cb47d9205a64cc8e52e91ab6831f4d

Lloyd Albin

from Fred Hutchinson Cancer Research Center

I have been a PostgreSQL administrator since 2002 and have worked for Fred Hutchinson Cancer Research Center for the last 10+ years. Within Fred Hutch, I work for the largest group called SCHARP, Statistical Center for HIV/AIDS Research and Prevention.

I host the Seattle Postgres Users Group where I give many of the presentations. I have many of the presentations posted at Lloyd's Presentations

In this presentation we will go over how to setup the following software to setup a monitoring solution:

  • Whisper Database -- This is a specialized database for storing time related data.
  • Graphite -- Graphite is used to display the data from the Whisper database.
  • collectd -- collectd is used to insert data into the Whisper Database from the OS and PostgreSQL.
  • Grafana -- Grafana reads Graphite and PostgreSQL directly to create comprehensive dashboards.

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Medium

Happening at the same time:

  1. Monitoring PostgreSQL - Part 1
  2. Start Time:
    2019 April 28 13:45

    Room:
    HC-103 Postgres

  3. "Just don't buy it"
  4. Start Time:
    2019 April 28 13:45

    Room:
    G-103

  5. ByStar Autonomous Content Collaborative-Authorship, Generation, Publication, and Distribution Software And Services
  6. Start Time:
    2019 April 28 13:45

    Room:
    CC-236

  7. Linux Gaming - The Dark Ages, Today, And Beyond
  8. Start Time:
    2019 April 28 13:45

    Room:
    HC-108

  9. Automation with Node-RED
  10. Start Time:
    2019 April 28 13:45

    Room:
    CC-208

  11. Linux Timestamps: Where have all the files gone, long-time passing?
  12. Start Time:
    2019 April 28 13:45

    Room:
    CC-200

  13. OpenZFS: Best Filesystem for every OS
  14. Start Time:
    2019 April 28 13:45

    Room:
    HC-104 Jupiter

  15. Deploying Your ...Whatever More Securely With Linux
  16. Start Time:
    2019 April 28 13:45

    Room:
    CC-235

  17. sudo apt install Happiness
  18. Start Time:
    2019 April 28 13:45

    Room:
    CC-115

  19. Evolution of Wireless Testing with Linux
  20. Start Time:
    2019 April 28 13:45

    Room:
    CC-114