Production databases on SSDs?
liz at dijkmat.nl
Tue Nov 10 15:04:08 GMT 2009
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.
More information about the london.pm