I'm sure you all have noticed the latency problems on this instance. Stage 1 of my 4 stage scaling roadmap is taking place tonight as I migrate the database to physically run closer to the machines running lemmy.
I will do a more detailed write-up on this later, but the gist is that each db operation required a new connection from lemmy, and that means a brand new SSL handshake since the db is managed elsewhere. Pooling would solve this, but lemmy does not handle a properly configured pg bouncer correctly in my testing. So the solution is move the database closer and within the private network to avoid SSL handshakes altogether.
TL;DR instance gonna go brrrr, downtime starting at 10:30pm pacific time tonight, should be done by 11:30pm
5 Comments
reclipse@lemdro.id · 3 pts · 3y
Thanks for the heads-up.
ImDankMom@lemdro.id · 2 pts · 3y
Good stuff man. Just joined up here. Thanks for spinning up this instance
ijeff@lemdro.id · 1 pts · 3y
Thanks for all your hard work!
cole@lemdro.id · 1 pts · 3y
test comment please ignore
cole@lemdro.id · 1 pts · 3y
test 2