Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>Approach</h2> <p>You could always roll your own solution, insofar most cloud providers offer a respective API to start/stop instances on demand (or even on schedule), which is what those management services are actually using as well of course - the <a href="http://docs.amazonwebservices.com/AWSJavaSDK/latest/javadoc/com/amazonaws/services/ec2/AmazonEC2.html" rel="nofollow noreferrer">AmazonEC2</a> Java interface offers all relevant methods for example (amongst many others), specifically:</p> <ul> <li><a href="http://docs.amazonwebservices.com/AWSJavaSDK/latest/javadoc/com/amazonaws/services/ec2/AmazonEC2.html#startInstances%28com.amazonaws.services.ec2.model.StartInstancesRequest%29" rel="nofollow noreferrer">StartInstances()</a></li> <li><a href="http://docs.amazonwebservices.com/AWSJavaSDK/latest/javadoc/com/amazonaws/services/ec2/AmazonEC2.html#stopInstances%28com.amazonaws.services.ec2.model.StopInstancesRequest%29" rel="nofollow noreferrer">StopInstances()</a></li> <li><a href="http://docs.amazonwebservices.com/AWSJavaSDK/latest/javadoc/com/amazonaws/services/ec2/AmazonEC2.html#rebootInstances%28com.amazonaws.services.ec2.model.RebootInstancesRequest%29" rel="nofollow noreferrer">RebootInstances()</a></li> </ul> <h3>Via Scripting (EC2)</h3> <p>The most simple approach for this regarding <a href="http://aws.amazon.com/ec2/" rel="nofollow noreferrer">Amazon EC2</a> would be to craft yourself some Python scripts by means of the excellent <a href="http://code.google.com/p/boto/" rel="nofollow noreferrer">boto</a> <em>(An integrated interface to current and future infrastructural services offered by Amazon Web Services)</em>, which exposes all EC2 methods mentioned above; you could then start those scripts on demand or via your operating system scheduler.</p> <h3>Via Continuous Integration / Automation (EC2)</h3> <p>Another option would be to facilitate a <a href="https://plugins.atlassian.com/plugin/details/774227" rel="nofollow noreferrer">continuous integration</a> server as an automation engine (a sometimes overlooked aspect of these systems), in case you happen to run one anyway; it would allow you to both start/stop instances on demand or scheduled similar to cron.</p> <p>We do exactly this by means of the <a href="https://plugins.atlassian.com/plugin/details/774227" rel="nofollow noreferrer">Bamboo AWS Plugin</a> (it's Open Source and the <a href="https://bitbucket.org/utoolity/bamboo-aws-plugin" rel="nofollow noreferrer">code is available on Bitbucket</a>), see my answer to <a href="https://stackoverflow.com/a/8952412/45773">How to start and stop an Amazon EC2 instance programmatically in java</a> for more details on this approach. While <a href="http://www.google.com/url?sa=t&amp;rct=j&amp;q=atlassian%20bamboo&amp;source=web&amp;cd=1&amp;ved=0CDgQFjAA&amp;url=http://www.atlassian.com/software/bamboo&amp;ei=zPofT5-pDciq-Abp7YjEBA&amp;usg=AFQjCNGRtgSKFoF6YTmc4ZB4-lcvzP754g&amp;cad=rja" rel="nofollow noreferrer">Atlassian Bamboo</a> is a commercial offering, there should be something similar available for popular Open Source CI solutions like e.g. <a href="https://bitbucket.org/utoolity/bamboo-aws-plugin/src/ef5a1a97df2c/src/main/java/net/utoolity/bamboo/plugins/EC2Task.java#cl-233" rel="nofollow noreferrer">Jenkins</a> as well.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to turn on/off cloud instances during office hours
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USSteffen Opel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to turn on/off cloud instances during office hours
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COPerfect. Thanks.
      singulars
      1. PO
      1. USDavid
 

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