Data Engineering Podcast

SiriDB: Scalable Open Source Timeseries Database with Jeroen van der Heijden - Episode 11

Listen Later
Summary

Time series databases have long been the cornerstone of a robust metrics system, but the existing options are often difficult to manage in production. In this episode Jeroen van der Heijden explains his motivation for writing a new database, SiriDB, the challenges that he faced in doing so, and how it works under the hood.

Preamble
  • Hello and welcome to the Data Engineering Podcast, the show about modern data infrastructure
  • When you’re ready to launch your next project you’ll need somewhere to deploy it. Check out Linode at dataengineeringpodcast.com/linode and get a $20 credit to try out their fast and reliable Linux virtual servers for running your data pipelines or trying out the tools you hear about on the show.
  • Continuous delivery lets you get new features in front of your users as fast as possible without introducing bugs or breaking production and GoCD is the open source platform made by the people at Thoughtworks who wrote the book about it. Go to dataengineeringpodcast.com/gocd to download and launch it today. Enterprise add-ons and professional support are available for added peace of mind.
  • Go to dataengineeringpodcast.com to subscribe to the show, sign up for the newsletter, read the show notes, and get in touch.
  • You can help support the show by checking out the Patreon page which is linked from the site.
  • To help other people find the show you can leave a review on iTunes, or Google Play Music, and tell your friends and co-workers
  • Your host is Tobias Macey and today I’m interviewing Jeroen van der Heijden about SiriDB, a next generation time series database
    • Interview
    • Introduction
    • How did you get involved in the area of data engineering?
    • What is SiriDB and how did the project get started?
      • What was the inspiration for the name?


      • What was the landscape of time series databases at the time that you first began work on Siri?

      • How does Siri compare to other time series databases such as InfluxDB, Timescale, KairosDB, etc.?

      • What do you view as the competition for Siri?

      • How is the server architected and how has the design evolved over the time that you have been working on it?

      • Can you describe how the clustering mechanism functions?

        • Is it possible to create pools with more than two servers?


        • What are the failure modes for SiriDB and where does it fall on the spectrum for the CAP theorem?

        • In the documentation it mentions needing to specify the retention period for the shards when creating a database. What is the reasoning for that and what happens to the individual metrics as they age beyond that time horizon?

        • One of the common difficulties when using a time series database in an operations context is the need for high cardinality of the metrics. How are metrics identified in Siri and is there any support for tagging?

        • What have been the most challenging aspects of building Siri?

        • In what situations or environments would you advise against using Siri?

          • Contact Info
          • joente on Github
          • LinkedIn
            • Parting Question
            • From your perspective, what is the biggest gap in the tooling or technology for data management today?
              • Links
              • SiriDB
              • Oversight
              • InfluxDB
              • LevelDB
              • OpenTSDB
              • Timescale DB
              • KairosDB
              • Write Ahead Log
              • Grafana

                • The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA

                Support Data Engineering Podcast

                ...more
                View all episodesView all episodes
                Download on the App Store
                Data Engineering PodcastBy Tobias Macey
                • 4.5
                • 4.5
                • 4.5
                • 4.5
                • 4.5

                4.5

                142 ratings

                More shows like Data Engineering Podcast

                View all
                This Week in Startups by Jason Calacanis

                This Week in Startups

                1,299 Listeners

                The Changelog: Software Development, Open Source by Changelog Media

                The Changelog: Software Development, Open Source

                288 Listeners

                The a16z Show by Andreessen Horowitz

                The a16z Show

                1,106 Listeners

                Software Engineering Daily by Software Engineering Daily

                Software Engineering Daily

                630 Listeners

                Risky Business by Risky Business Media

                Risky Business

                372 Listeners

                Talk Python To Me by Michael Kennedy

                Talk Python To Me

                583 Listeners

                Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

                Super Data Science: ML & AI Podcast with Jon Krohn

                309 Listeners

                NVIDIA AI Podcast by NVIDIA

                NVIDIA AI Podcast

                346 Listeners

                Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

                Syntax - Tasty Web Development Treats

                987 Listeners

                Practical AI by Practical AI LLC

                Practical AI

                210 Listeners

                Dwarkesh Podcast by Dwarkesh Patel

                Dwarkesh Podcast

                550 Listeners

                The Data Engineering Show by The Firebolt Data Bros

                The Data Engineering Show

                10 Listeners

                Latent Space: The AI Engineer Podcast by Latent.Space

                Latent Space: The AI Engineer Podcast

                104 Listeners

                This Day in AI Podcast by Michael Sharkey, Chris Sharkey

                This Day in AI Podcast

                227 Listeners

                The AI Daily Brief: Artificial Intelligence News and Analysis by Nathaniel Whittemore

                The AI Daily Brief: Artificial Intelligence News and Analysis

                680 Listeners