Production databases on SSDs?

[Elizabeth Mattijsen]

On Nov 10, 2009, at 3:46 PM, Ovid wrote:
> Does anyone here have any experience putting a production database on a solid-state drive?  Our database is heavily used and it sounds to me like we could get a massive performance boost for minimal cost and no architectural changes.  Are there any downsides I should be aware of?

If you're using MySQL and replication, I've heard stories about performance gains putting the binlog on an SSD, rather than the db itself.  Advantages: smaller SSD necessary, and no unrecoverable problems should the SSD decide to quit in the end.


Liz