Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
How do you do Load Testing and Capacity Planning for Web Sites

I need to develop a system that connect to multiples outter systems to get XML data and reply with computed XML data. Should I go with EC2 + RDS, or just a bigger EC2 ?

Maybe relevant data: DB size is about 50GB, monthly server data transfer is between 120 and 150 GB.

EC2 is WinServer, RDS should be SQL Server.

share|improve this question

marked as duplicate by EEAA, Michael Hampton, John Gardeniers, sysadmin1138 Nov 23 '12 at 22:42

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

up vote 8 down vote accepted

General rule: keep your data separated from your application. There are many reasons:

  • You can have multiple instances of your application working from the same data set
  • Upgrading your application will not affect your data
  • CPU is dedicated to one thing: data for data, application for application, choose appropriate sizes for each
  • Having read-only replicas for performance boosts

Once you've done that, then it's a question of:

  • EC2 Application server + RDS SQL Server, or
  • EC2 Application server + EC2 SQL Server

That answer to that purely comes down to management and whether you want to be responsible for that or not (applying patches, setting up read-only replicas, setting up multi-AZ, etc.)

RDS allows you to easily set these up. But you're limited to what RDS provides. Running your own SQL Server gives you more flexibility, but you have to manage everything.

share|improve this answer
    
thank you :) –  Vicenç Gascó Nov 27 '12 at 15:40

Not the answer you're looking for? Browse other questions tagged or ask your own question.