News for hackers. Stuff that matters.
Re:How to handle 1000s of concurrent users on a 360MB VPS by jacques_chester on Saturday May 28, 2011 @10:11AM (#2594452)
Missing: caching. Caching. Caching. And more caching.

I speak of Wordpress and database-backed PHP applications of its ilk. Wordpress loves to spray MySQL in a thick stew of queries for every single page load.

Without sensible -- preferably aggressive -- caching, your Wordpress site will die in the arse.

My setup generates cached .gz files, which nginx can serve directly. It flies. It didn't used to.

Re:How to handle 1000s of concurrent users on a 360MB VPS by aonic on Saturday May 28, 2011 @10:22AM (#2594468)
Or if you dont want to deal with Wordpress to implement the caching, use Varnish. (also mentioned few times in this thread)

I've used Varnish for some high-traffic Wordpress sites by sitting it in front of Apache running Wordpress. With well planned TTLs, and logged-in cookie detection, most of the inconveniences of caching can be eliminated.

Also, using Disqus or similar services for comments will be helpful. You wont have to worry about comments not showing up until the cache clears, leading to confused users. That is, if you use the javascript implementation of these comment services.

Alternatively, plugins like WP Super Cache have automatic post cache flushing if there are updates, and you can also tell it to bypass cache for logged in users. But it is IO-bound.

Re:How to handle 1000s of concurrent users on a 360MB VPS by euroclydon on Saturday May 28, 2011 @11:18AM (#2594545)
WP Super Cache will serve up cached files via PHP with the flip of a switch. While this isn't as fast as letting the server serve up cached files, it's an easy win.
Re:How to handle 1000s of concurrent users on a 360MB VPS by nicksergeant on Saturday May 28, 2011 @11:35AM (#2594578)
It's not missing, he specifically addressed caching at the end of the article (indicating he didn't cover it).
Re:How to handle 1000s of concurrent users on a 360MB VPS by getsat on Saturday May 28, 2011 @12:41PM (#2594710)
This is the best caching plugin I've found for WP: http://wordpress.org/extend/plugins/w3-total-cache/

It supports disk-based caches and memcached.