Forum Moderators: open
My sites are database intensive requiring a heavy amount of cacheing.
I am looking at Solid State Drives as a solution to db read/write speed issues and general cacheing.
Neither SL nor TP can confirm that they have any near future plans to provide SSD, and I cannot find any mention of it on RS website.
I was wondering if anyone could share their experience with a host providing SSD dedicated servers.
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.)
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...
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.
I'm not sure a new hard drive is the answer here.
