New SSDs have wear leveling algorithms and will fare just as well as any mechanical drive. And I seriously doubt most people will be running a database with enough transactions to cause SSDs a problem, if at all.
I'd like to get an SSD if they weren't so damn expensive.
Faster yes? More reliable? Only if you're NOT using them for a write-heavy purpose. Once you start writing to them repeatedly their lifespan quickly drops. For instance, having mysql databases that are written to often on an SSD (or a RAID 0 of SSDs for that matter) is a VERY BAD IDEA. Lunchb0x can attest to this fact.
I work with our System Restore team at work pretty closely, and they tell me horror stories of customers with SSDs in the web servers and database servers failing after a couple of months due to heavy writing to the SSD. And when the SSDs die, they die. The cloner at work rarely gets info off of those things.
I would highly recommend against using SSDs for anything that is slightly write heavy.
Comments
I'd like to get an SSD if they weren't so damn expensive.
I work with our System Restore team at work pretty closely, and they tell me horror stories of customers with SSDs in the web servers and database servers failing after a couple of months due to heavy writing to the SSD. And when the SSDs die, they die. The cloner at work rarely gets info off of those things.
I would highly recommend against using SSDs for anything that is slightly write heavy.