Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I can perhaps answer some of your questions, but certainly not all. EC2 are virtual machines preconfigured with a number of different options. It sounds like what you want is a Windows instance. They come with a number of different memory and cpu options depending on what you think your application will need.</p> <p>EBS is basically your fault tolerant file-system. That is where you'll put your files, including your database files.</p> <p>S3 is in essence a content delivery network. A REST friendly place to put files. For example if all you have is static content you could put the whole thing up in an S3 bucket, and not pay for any compute power, just storage, and bandwidth (which is cheap). </p> <p>I should add, there is no need to use S3, if you are comfortable with using your EC2 instance to serve up all your content. Its all a question of options.</p> <p>As to why would you shut off an instance -- that would be because you're not using it. For example, a staging server, that you would use to test your app, in a variety of different scenarios. You could have a different EC2 instance per scenario, start them when you want to run your tests and stop then when you're done.</p> <p>As for SQL Server, one of the EC2 instances that Amazon offers "pre-configured" includes a SQL Express already set up. If you don't want SQL Express, then I beleive you'll have use one of your SQL Server Licences and install it on your server.</p> <p>The great thing about AWS is the very low barrier to entry. For just a few dollars investment, you can poke around for a day and see what there is to see. When I first started with AWS I found it helpful to start small, with a single EC2 instance. Just open up the RDP ports and connect into it. You'll soon feel right at home, having a your own machine up in the cloud.</p> <p>Let the CDN and load balancing things come in time.</p> <p>On last bit of advice, is to remember that your ESB data and your instance must be in the same region. If you start a machine in Europe, and your ESB volume is in Seattle you're out of luck. You'll have to move your volume from one region to another (and they charge something for that data transfer)</p>
    singulars
    1. This table or related slice is empty.
    1. POCan someone elaborate on these basic concepts of hosting via Amazon Web Services?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRalph Shillington
    1. USRalph Shillington
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCan someone elaborate on these basic concepts of hosting via Amazon Web Services?
      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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for your great feedback. When you mentioned EBS for storing database files, does it mean I will install SQL server 2005/2008 there or? I'm not an admin, so I don't understand what database file is. I thought it's just a server running there? So for S3, in say a forum site, it will be used to store all user uploaded images, files, movies, etc? So why not store it onto EBS? And the difference between S3 and EBS is one charges "compute" power and the other does not?
      singulars
      1. PO
      1. USLiming
    2. CO@liming, I upated me answer with a bit more clarification. Hope that helps. Have you checked our ServerFault --- i beleive there are some folks over there doing AWS stuff as well.
      singulars
      1. PO
      1. USRalph Shillington
    3. CO@Thanks a lot Ralph. It clears up quite a bit. Yeah, sql express won't cut it, so I'll just use one of our sql server license there. Truly appreciate your time in this matter.
      singulars
      1. PO
      1. USLiming
 

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