Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As PachinSV pointed out, you can choose whichever DB solution you prefer. I will add one more: you can launch an EC2 instance and install the DBMS of your choice, either NOSQL (MongoDB, Cassandra), SQL (MSSQL, MySQL, Oracle), or whatever. I will try, with this answer, to handle the other aspects of your question (the application itself, the scalability and, if needed, the storage).</p> <p>My suggestion, though, would be something like:</p> <p>-One or two EC2 instances, probably small or medium (take a look at the instance types <a href="http://aws.amazon.com/ec2/instance-types/" rel="nofollow">here</a>), in order to take care of your application load. More on EC2 <a href="http://aws.amazon.com/ec2/" rel="nofollow">here</a>.<br> -Whenever you need to scale, you can add an Elastic Load Balancer in front of the EC2 instances, so you can keep adding instances to your ecosystem while maintaining an horizontal scalability.<br> -For the DB, I would start with a RDS instance (probably small size), with the system of your preference, either MySQL, SQL Server or Oracle. With RDS, you can change your instance size as you go, and you can also add one or more read-replicas in case your app becomes read-intensive in the future. More on RDS <a href="http://aws.amazon.com/rds/" rel="nofollow">here</a>. Another good option, as PachinSV pointed out, would be <a href="http://aws.amazon.com/dynamodb/" rel="nofollow">DynamoDB</a>, for the reasons he mentioned already -- partitioning, performance, less restrictions, etc.<br> -Although you have not mentioned, if you need scalable storage, S3 is definitely the way to go, and would be ready for your use. </p> <p>Hope it helps.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat AWS services to use in my scenario?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USViccari
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat AWS services to use in my scenario?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CODo you think I can also replace my database with Amazon ElastiCache? By using it for a couple of hours with high concurrent access, and then analyzing its results back into a database?
      singulars
      1. PO
      1. USbuddhabrot
    2. COI would prefer using Elasticache in a read-intensive environment. I don't think it makes much sense caching your data **before** persisting it.
      singulars
      1. PO
      1. USViccari
    3. COI tried RDS now, but I'm stuck at about 10000 record updates / minute, for one EC2 instance that is connected to it. Do you think I can still scale that?
      singulars
      1. PO
      1. USbuddhabrot
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload