Our great sponsors
-
Alternatively, reddit was open source up to 2017, so you can see how it was handled then. https://github.com/reddit-archive/reddit
-
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.