Eugen RochkoFrom 8 cores to 36 cores processing power, let's see how the new database server holds up. Hopefully everything will be much faster from now on, but it should also give me a bit more room to scale horizontally.
Yrjänä Rankka 🌻@Gargron Also most DB engines really need a sh*t-ton of RAM. If the DB has to go to disk - even SSD - you’re in a world of pain. Biggest challenge is to balance RAM / CPU. Sometimes need to tweak OS VM paging parms as well. A good DB does its own paging, as these workloads differ greatly from regular processes.
@Gargron Most DB setups using shared-nothing clustering/sharding aren’t to increase CPU counts, but rather to increase available RAM.