jkap

CEO of posting

butch jewish dyke
part of @staff, cohost user #1
married to @kadybat

This user can say it
osu stats


๐Ÿ”ต tumblr
yrfriendjkap.tumblr.com/
๐Ÿ˜ mastodon
xoxo.zone/@jkap
๐Ÿ–ผ๏ธ icon credit
twitter.com/osmoru
๐Ÿฆ twitter
not anymore lol
๐ŸŽฌ letterboxd
letterboxd.com/yrfriendjkap/

here's a chart of requests per second on the main app over the last 14 days (ignore the different colors, they reflect deployed versions)

this week has already been a stress test, but today we once again outgrew the database server we'd been using. unfortunately we were stubborn about upgrading because (a) it's a lot more expensive, and (b) usually upgrading comes with downtime, despite our provider allegedly making it a zero-downtime process

we decided that we probably had enough downtime and went ahead on the upgrade. fortunately, the one time we dreaded it most, it was actually a zero-downtime deploy. just a couple minutes after i hit the button, we were already seeing performance improvements.

we should, hopefully, be able to keep going on the current server size for a bit. we're still making performance improvements (and were able to discover a needlessly slow, common query as a result of this) but at a certain point you just need more compute, and we needed more compute.


i am really hoping things stay stable because i want to not have to think about Servers on my weekend lol


You must log in to comment.

in reply to @jkap's post:

I wouldn't think so? Here's some napkin math - obviously there are a lot of assumptions within:

On Nov 1 they reported 38,165 users. If every user loaded cohost and made a chost in a day you'd end up with ~80k requests - let's assume most people clicked post (generating an extra page load) rather than using the modal and say 100k.

Spread evenly over a day, that's ~1 request per second. Obviously load isn't spread evenly. If we assume that 80% of the traffic happens in 25% of the day, we're looking at 80k requests / 6 hours ~= peak activity of 4 requests per second.

With significant growth over the past few days, we can see the climb from an actual ~5 RPS on the first to >15 RPS now.