Jonah Aragon :MN:

Jonah Aragon :MN:'s avatar
Jonah Aragon :MN:
npub18rj8...pgfg
Sometimes people read things I write or watch things I say • I work at @privacyguides and @triplebit (ASN 401332) • Instance admin @ https://mstdn.party, https://mstdn.plus, and https://neat.computer • Formerly @techlore [ Minneapolis 🏙️ ][ Minnesota :MN: ][ USA 🇺🇸 ]
So, I helped Britt out with moving her instance to a new server provider this week. While the people at toot.io were relatively helpful in our email chain (once she was finally able to get a hold of them in the first place anyways), the setup at toot.io was a bit strange and not optimized for an instance of her size. The actual server itself was well *over*powered for her to be seeing the slowdowns she was, and Mastodon & especially Postgres just weren’t using those resources to a full extent. Honestly the biggest red flag 🚩🚩🚩 to me isn’t what toot.io is doing now necessarily, but that it was apparently sold(?) to completely new management without notice to customers. In a niche service industry like this, that seems like a big problem to me, to not even explain who’s taking over and why you should trust them. The previous ownership is probably more at fault for this relatively speaking, but it’s probably a good opportunity for toot.io customers to reevaluate their hosting options… Even if you ultimately end up sticking with toot.io, you simply might not be fully aware of what’s going on over at your own hosting company anymore, and that’s always worth double-checking 👀 #MastoAdmin #MastodonAdmin #MstdnGames #InstanceMigration #Tootio View quoted note →
Attention please, I would like to get opinions on this question from people who actually use #Cloudron, and aren’t just aware that it’s proprietary software which is what originally put me off of it all the way back in 2016: Is Cloudron actually good? 🙂
1500 connection limit? 👀 I have double your active users running on under 30 direct postgres connections most of the time. WEB_CONCURRENCY=24 and MAX_THREADS=15 (this is specific to my 44 CPU core count, don't overdo it...) This might be over-explaining, but this is my setup: 1. You need to install pgBouncer I have max_client_conn = 10000 and default_pool_size = 30 and reserve_pool_size = 120 set in pgbouncer.ini This allows practically unlimited connections from Mastodon, but only 30 will be opened with postgres. It will scale up to 150 if absolutely required but that very rarely ever happens. 2. You should set max connections in Postgres itself to 300 and check again. Use OLTP instead of Web as the DB type. If your DB is on the same server as Mastodon don't just enter your total core count and RAM, enter only what you want dedicated to Postgres (so... probably about half). Some settings depend on what max connections is, so if you ran pgTune before and then increased it they're probably wrong, best to double-check them all. 3. Profit