News for hackers. Stuff that matters.
Re:Optimizing Your Web App 100x Is Like Adding 99 Servers by fareesh on Friday November 20, 2020 @06:03PM (#25166176)
> Make sure your web server and database are set up and tuned right - that they have enough memory, threads, etc.

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?

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)
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.
Re:Optimizing Your Web App 100x Is Like Adding 99 Servers by ZephyrBlu on Friday November 20, 2020 @08:03PM (#25167003)
I don't really understand why people _want_ to deal with all the nitty gritty stuff when it's so cheap and easy to have everything work perfectly and be maintained out of the box.