"Compress" old data

This page summarizes the projects mentioned and recommended in the original post on /r/mysql

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • TimescaleDB

    An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

    But MySQL is not so great for time series data. TimescaleDB is an extension for postgresql that adds functionality for working with time series data, including automatic partitioning.

  • VictoriaMetrics

    VictoriaMetrics: fast, cost-effective monitoring solution and time series database

    Try storing the data to VictoriaMetrics. It compresses the stored data with very high compression rate, so it needs up to 70x less disk space than sql-based databases. See this benchmark.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts