Writing metrics to TimescaleDB¶
What’s TimescaleDB? Here’s how their team defines the project on their GitHub page:
TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support.
To get started archiving metrics to TimescaleDB right away, check out Mahlon’s
repository on GitHub.
This small program takes JSON streams from a Netdata client and writes them to a PostgreSQL (aka TimescaleDB) table. You’ll run this program in parallel with Netdata, and after a short configuration process, your metrics should start populating TimescaleDB.
Finally, another member of Netdata’s community has built a project that quickly launches Netdata, TimescaleDB, and
Grafana in easy-to-manage Docker containers. Rune Juhl Jacobsen’s
project uses a
Makefile to create everything, which makes it
perferct for testing and experimentation.
Netdata↔TimescaleDB in action¶
Aside from creating incredible contributions to Netdata, Mahlon works at LAIKA, an Oregon-based animation studio that’s helped create acclaimed films like Coraline and Kubo and the Two Strings.
As part of his work to maintain the company’s infrastructure of render farms, workstations, and virtual machines, he’s
netdata-timescale-relay, and TimescaleDB to store Netdata metrics alongside other data from other
LAIKA is a long-time PostgreSQL user and added TimescaleDB to their infrastructure in 2018 to help manage and store their IT metrics and time-series data. So far, the tool has been in production at LAIKA for over a year and helps them with their use case of time-based logging, where they record over 8 million metrics an hour for netdata content alone.
By archiving Netdata metrics to a backend like TimescaleDB, LAIKA can consolidate metrics data from distributed machines efficiently. Mahlon can then correlate Netdata metrics with other sources directly in TimescaleDB.
And, because LAIKA will soon be storing years worth of Netdata metrics data in TimescaleDB, they can analyze long-term metrics as their films move from concept to final cut.
Read the full blog post from LAIKA at the TimescaleDB blog.
Thank you to Mahlon, Rune, TimescaleDB, and the members of the Netdata community that requested and then built this backend connection between Netdata and TimescaleDB!