Pretty interesting post from Percona this week about the cost of scaling out MySQL.  They compared the cost/benefit of increasing memory vs switching to an SSD. The above graph is a little confusing at first, but take a look at the 6GB point on the x-axis.  By switching to an SSD, you can get a 5x speed boost (TPS).  To do the same thing with RAM, you’d have to add another 10GB. Anecdotally we all knew SSDs improve performance, but it’s great to see someone throw some numbers behind that claim. Of course there are a million YMMV caveats here (data size, read-write ratio, active data vs historical, etc) but it’s always good to have alternative ways to scale out a single host that don’t just involve throwing RAM at it.

Pretty interesting post from Percona this week about the cost of scaling out MySQL.  They compared the cost/benefit of increasing memory vs switching to an SSD.

The above graph is a little confusing at first, but take a look at the 6GB point on the x-axis.  By switching to an SSD, you can get a 5x speed boost (TPS).  To do the same thing with RAM, you’d have to add another 10GB.

Anecdotally we all knew SSDs improve performance, but it’s great to see someone throw some numbers behind that claim. Of course there are a million YMMV caveats here (data size, read-write ratio, active data vs historical, etc) but it’s always good to have alternative ways to scale out a single host that don’t just involve throwing RAM at it.

← Previous post
Next post →