Renaud ChaputAug 8, 2023

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

Show threadJanAug 8, 2023
@renchap @timetinytim Single instance or do you use some postgres replication?
Show threadRenaud ChaputAug 8, 2023
@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)
Show threadJanAug 8, 2023
@renchap @timetinytim I saw the Vivaldi issue, is it a read or r/w replica?
Show threadRenaud ChaputAug 8, 2023
@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.
Show threadJan
@renchap @timetinytim Noted thanks.
Aug 8, 2023 at 12:03pmWeb