Amazon EC2: Which platform solution would cost less to run over time, Windows+SQL Server or Linux+Oracle?
-
Assuming that your web application has 100+ million # of users, and bandwidth, storage consumption is the same for both platforms Which platform solution would cost less to run overtime via Amazon EC2?
-
Answer:
Linux is consistently cheaper than WinServ. MySQL is about half the cost of SQL Server (in RDS). So, Linux+MySQL is going to be a lot cheaper. Check Amazon's pricing (which frequently changes) here for EC2 -> http://aws.amazon.com/ec2/pricing/ and here for RDS -> http://aws.amazon.com/rds/pricing/
Stan Hanks at Quora Visit the source
Other answers
Stan's answer is quite good from the standpoint of licensing costs. As a long-time enterprise architect, I also learned to factor in a lot of other elements in addition to license costs. These costs includes things like the cost and availability of expert-level talent both for in-house personnel and for consultants, cost and availability of training, cost and quality of enterprise-quality support for bug fixes, etc.
Kevin Edward Kline
In straight licensing costs I'm not sure that Stan Hank's answer is actually an answer.Windows+SQL will generally be more expensive in terms of pure licensing than Linux+MySQL BUT not more expensive than Linux+Oracle which is where I take exception to Stan's answer. The question was in regard to Linux+Oracle..The underlying VM size is taken out of this consideration because it is highly variable to your query load.I would also point out that pure licensing costs is not the ONLY factor, availability of experts to maintain the environment and keep your systems running is a HUGE factor and not to be dismissed.I don't like spending any more money than I need to for anything, regardless of whether it is coming out of my pocket or not.
Elliott Whitlow
Related Q & A:
- How to control the excessive use of ram by SQL Server?Best solution by Database Administrators
- Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- How to upgrade sql server express 2005 to 2008R2?Best solution by Server Fault
- Is SQL Server or oracle more employable?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.