Amazon AWS vs SSDNotes – SSD Nodes Rocks

So lately at Risk Metrics we have be developing for our cloud based offerings and API’s.

Amazon vs. SSD Nodes

SSD Nodes vs. Amazon AWS

Having read pretty much everywhere about Amazon’s amazing AWS we thought we would spin it up and give it a go.

Off we went, first simpleDB, then RDS, then a few RDS upgrades.

Its a little interesting that Amazon currently has 4 offerings;

  • Small
  • Large
  • X-Large
  • XX-Large

Wouldn’t you think that they would have a Medium?

Anyway, after spin up, throughput on some, if not all of our queries was taking too long and we started scratching our heads.  Changed some data structure…upgraded…reupgraded etc.

When queries continued to take upwards of 3 minutes we knew something else needed to be done.  Essentially we could go with multi nodes or begin to look elsewhere for database types.  Not wanting to change too much and before multi-multiplying our AWS pricing we looked elsewhere and after getting quotes from a number of players in the space that promised exponential reduction in processing time, we found SSDNodes.  (Front runner otherwise was Vertica but a was bit too much $$)

SSD Nodes allowed us to essentially run queries in 1/100th of the time of that which they were running on AWS.

In all fairness, Amazon isn’t yet pushing solid state drives but they did inform us that its on their road map.  AWS, when you get there, feel free to give us a call.

So, thanks SSD nodes, here is a good customer review for you!

P.S. don’t get bought by Amazon.

A few screenshots of query bench-marking below

SSD Lepton

SSD Preon
SSD Preon

Amazon AWS
Amazon AWS with thoughput at 195.00 seconds….lame

Advertisements

About kmccarthy

Data geek and tech enthusiast intrigued by information and all that is 2.0. VP at insurance data firm - Risk Metrics. Laxer, lacky surfer, fisherman and cook. Happy Heat fan and an unfortunate Dolphins "Finatic".
This entry was posted in Data, Tech and tagged , , , , , , . Bookmark the permalink.

One Response to Amazon AWS vs SSDNotes – SSD Nodes Rocks

  1. Ian Bussière says:

    An article posted only two weeks after this one that might interest you : http://gigaom.com/cloud/amazon-launches-database-friendly-ssd-backed-instances/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s