Re:Optimizing Your Web App 100x Is Like Adding 99 Servers
by charrondev on Friday November 20, 2020 @06:49PM
(#25166559)
Step one if you haven’t already would be adding caching. Something like varnish in front for, if nothing else guest traffic, and memcached or redis for commonly fetched data.
For a lot of cases varnish (or a different reverse-proxy cache) will shave off 50% of your traffic from ever hitting the servers. It depends on your percentage of guests/sessioned users and and read/writes though.
After that using a cache like redis or memcached for things like user sessions/permissions and commonly fetched data significantly reduce the load on your database.
Re:Optimizing Your Web App 100x Is Like Adding 99 Servers
by dig1 on Friday November 20, 2020 @06:53PM
(#25166581)
Unless you are expecting >1k req/sec with similar amount of writes, default nginx/postgres/mysql settings should be fine.
Focus on your app instead :)
Re:Optimizing Your Web App 100x Is Like Adding 99 Servers
by davidkell on Friday November 20, 2020 @06:09PM
(#25166225)
For Postgres https://pgtune.leopard.in.ua/#/
Re:Optimizing Your Web App 100x Is Like Adding 99 Servers
by jeffbee on Friday November 20, 2020 @06:22PM
(#25166345)
Don't. Just use your cloud's hosted database instead.
Anyone have a link to good write-up on tuning Apache/nginx and Postgres/MySQL for a web app running on a $10-20 typical VM?