News for hackers. Stuff that matters.

A comment on Ask HN: Has anybody shipped a web app at scale with 1 DB per account?. Parent comment

Re:Ask HN: Has anybody shipped a web app at scale with 1 DB ... by krainboltgreene on Tuesday May 26, 2020 @12:59AM (#23307568)
> If connecting to your DB is significantly increasing your page times, you've got seriously fast pages. Even back when I was working with a MySQL database regularly in 2010, connect + login was 5 ms at maximum (and I think it was much less, I just don't remember that far).

One of the major ways I helped Mastodon was improving their connection pooling situation. If you haven't encountered connection size issues with your database count yourself lucky.

[ Parent | on HN ]
Re:Ask HN: Has anybody shipped a web app at scale with 1 DB ... by toast0 on Tuesday May 26, 2020 @11:47AM (#23312613)
My experience was with Apache + mod_php, so there was no option to pool connections between workers, and you would set the Apache connection limits such that they summed up to less than the MySQL connection limits (unless you had a lot of traffic that didn't hit the database... then sizing would be tricky)
[ Parent | on HN ]