EC2 Vs NAS Or SAN Storage For High Transaction Read and Write Web Apps using MySQL

Greetings,

What's the best performance concept for an enterprise environment with lots of reads and writes. Would we benefit from EC2 concept or NAS\SAN concept? The MySQL environment has bottle neck issues and we want to make sure we are using the most ideal concept to compliment or web apps and MySQL database environment. Please chime in.
Omega002Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AncillasConnect With a Mentor Commented:
Is the bottle neck the connection to the DB server or is disk activity causing a long write queue?  If it's a long write-queue, you can scale upwards and get a bigger machine to handle the DB.  In this case, Amazon EC2 would be a fine solution.

If the network is your bottle-neck, you'd be better served using a SAN solution.

Going back to EC2, you might want to do a quick google search to see if there are any issues with their EBS volumes and read/write intensive applications.  We used to experience write queue issues with our app, but a recent patch at Amazon fixed the issue.
0
 
oztrodamusCommented:
I would be afraid of any cloud provider that could not contractually guarantee they aren't going to farm out their storage to some other provider that you can't see, because it's in the cloud. For that reason if high transaction rates are what you require I would stick with a SAN. If cost control is what you're after todays iSCSI can be just as good as FC.
0
 
shalomcCTOCommented:
When you say EC2, do you mean the non-relational Amazon SimpleDB, or something else?

There is a growing tendency among really high volume transaction producers to use "non standard" databases, like Cassandra, Dynamo and others. It eventually depends on your application design whether you can use such a solution.


0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
lynxITCommented:
I would suggest the best question to ask first is what security needs (i.e does it need be kept private?) surround the data?  

If its high security (ie personal data that your company or organisation is responsible for) that has strict usage guidelines then an in-house NAS/SAN would (in my opinion) be your only option.  If the data does not need to be kept that secure, the EC2/S3 and a NAS/SAN could both be options.

Is this purely data in a database, or is this data to both database and disc?
0
 
Omega002Author Commented:
None
0
 
Omega002Author Commented:
none
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.