Correct approach for simple like system at scale?

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

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

    Alternatively, reddit was open source up to 2017, so you can see how it was handled then. https://github.com/reddit-archive/reddit

  • gh-ost

    GitHub's Online Schema-migration Tool for MySQL

    Source: I've had to do the same thing on a table with "only" a billion rows. It took weeks and weeks of planning (we had a document with over 200 steps, including all the people we had to notify and all the possible problems), and was under the gun to be done by the holidays. We ran the actual migration in 'screen' because the command took over 2 weeks to run. During that time, the load on our databases got dangerously high several times, and had to be paused for a few hours. (We were using pt-OSC at the time, but later switched to gh-ost which was much safer. We also had smaller migrations that hit a snag and had to be aborted and restarted.)

  • 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