I've just switched to a VPS at Pair.com, mainly to increase my available disk space and database resources.
I'm running over 20 WordPress blogs, most of which have relatively low traffic. The number will increase to around 40, but I foresee most of these having relatively low traffic. I'm also running Gallery 2 with 23,000 images. Currently I have just moved to a VPS (VQS1) and want to optimize my set-up to the maximum.
At the moment I'm using WP-Minify and Hypercache on all blogs (and yes, for good or ill I am using YARPP); I'm considering switching to W3 total cache and installing eAccelerator. I realize that memcached would be unsuitable for a VPS on Pair.com as there's only 500MB of RAM.
As I previously had a limited number of databases, I have several blogs using each database with different table sets. As the database limitation no longer applies, I presume it would be preferable for me to change to using one database per blog? Anyone know the simplest way of doing this?
If anyone has any experience of using WordPress in these circumstances and can give me some advice, I'd be really grateful. Oh, I'm not using WordPress MU for various reasons.