Post APJHWmqPMzKgcvFltQ by avlap@scicomm.xyz
 (DIR) More posts by avlap@scicomm.xyz
 (DIR) Post #APCoNr07ZONtaabelc by Gargron@mastodon.social
       2022-11-02T20:44:06Z
       
       0 likes, 2 repeats
       
       From 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.
       
 (DIR) Post #APCoNrSTrx4N0XsIyG by ghard@mastodon.social
       2022-11-02T20:50:19Z
       
       0 likes, 1 repeats
       
       @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.
       
 (DIR) Post #APCoNsymDMUtizzbwu by ghard@mastodon.social
       2022-11-02T20:54:57Z
       
       0 likes, 0 repeats
       
       @Gargron Most DB setups using shared-nothing clustering/sharding aren’t to increase CPU counts, but rather to increase available RAM.
       
 (DIR) Post #APJDviuoiNJbrex0gC by avlap@scicomm.xyz
       2022-11-05T10:50:17Z
       
       0 likes, 0 repeats
       
       @Gargron Could making use of #concurrency with #Golang or #Rust for essential parts of the infrastructure help to improve #Mastodon? #Go
       
 (DIR) Post #APJDvjLl6CrlDDYWfo by MrClon@lor.sh
       2022-11-05T23:40:52Z
       
       0 likes, 0 repeats
       
       @avlap i didn't much look to #Mastodon sources, but i think in not that easy to rewrite part of mastodon to another language. As i remember Mastodon is two daemon (written on RubyOnRails and Node.js) plus Postgres and Redis@Gargron
       
 (DIR) Post #APJHWmqPMzKgcvFltQ by avlap@scicomm.xyz
       2022-11-06T00:06:38Z
       
       0 likes, 0 repeats
       
       @MrClon @Gargron Probably not. I did some newbie stuff in #golang and concurrency can be really neat and fast it seems.
       
 (DIR) Post #APJKFoyEVkcmA1W04u by MrClon@lor.sh
       2022-11-06T00:51:31Z
       
       0 likes, 0 repeats
       
       @avlap Concurrency itself not so important for dealing with huge amount of queries if bottleneck is database/storage, or if you can use many instances of app to distribute queries between them@Gargron