We just updated the database servers powering mastodon.social:
Before: Intel W-2295 (18 cores), 128 GB RAM, standard SSDs
After: AMD EPYC 7502P (36 cores), 256 GB RAM, Datacenter-grade NVMe

mastodon.online also got new hardware yesterday (from 6 to 24 core, and with a replica now).

This should help with the growth and any future spike in activity!

Thanks @timetinytim for setting all of this up and handling the migration 💪

#mastoadmin

@renchap @timetinytim Single instance or do you use some postgres replication?
@jan @timetinytim There is a replica (the blue line on the graphs).
We recently improved replication support in Mastodon, coming soon in 4.2.0 (beta1 should be released today)
@renchap @timetinytim I saw the Vivaldi issue, is it a read or r/w replica?
@jan @timetinytim Read replica only, which is also kind of supported before 4.2.0, but you need it to only be enabled for Puma (web server), not Sidekiq, and can cause issues, as it automatically send `SELECT` queries to it, without special handling.
The new 4.2 replica support also works for Sidekiq, and we hand-picked the most heavy queries to run them on the replica, when possible.
@renchap @timetinytim why not go with a self scaling kubernetes cluster?