| 12:04 am on Sep 6, 2008 (gmt 0)|
I doubt you'll find anyone offering SSD machines in their hosting plans, though you could always buy such a machine yourself and send it to the datacenter.
However, I wonder if what you need isn't super-expensive hardware, but better data management. What does data access look like now? Is it straight to a database query, or do you have process and machine-local caches? Are you using an in-memory network cache such as memcached? Are you using database replication or partitioning, or is your database hosted by a single machine / server instance?
If you haven't yet explored these possibilities, it may well be worth your while to do so before investing in new hardware.
(Profiling your code to find the trouble spots may also be beneficial, but perhaps you've already done that.)
| 7:59 am on Sep 6, 2008 (gmt 0)|
pinterface: All valid points, I have done all that.
I have tweaked sql, currently running a master with two slaves and cacheing everything that I can, all on quad core, quad cpu, with 16gb of ram for all three servers.
With 1.5 million pages of content, I am filling the (shared) ram with the cache pages too fast.
With our growth (alexa 2000) we need to improve on what we are doing and SSD looks like a solution to us.
But no one is offering it, as it seems...
| 11:41 am on Sep 6, 2008 (gmt 0)|
SSDs vary in speed and quality - it is a very difficult choice at the moment, you will most certainly have to add them to your own dedicated server.
16 GB of RAM for 1.5 mln pages is 10KB per page, are your pages that big? Maybe you need to look at "memcached" project - it allows to spread database cache over multiple PCs using their RAM, sounds like perfect solution for your problem.
| 12:51 pm on Sep 6, 2008 (gmt 0)|
LW offers SSD but the premium is very high. Sticky sent.
| 2:15 am on Sep 10, 2008 (gmt 0)|
I'd be looking at a GOOD raid controller before switching to SSD. With my mid(ish) priced raid controller I'm reading at about 380MB/s and writing at 200MB/s on a 4 drive raid 5 setup.
I'm not sure a new hard drive is the answer here.