Name

DB.DBA.AMAZON_STOP_INSTANCE — Stops an existing AMI instance.

Synopsis

DB.DBA.AMAZON_STOP_INSTANCE ( in aws_access_key varchar ,
  in instance_id varchar ,
  in secret_key varchar ,
  in http_proxy varchar (default null) );
 

Description

Stops an existing AMI instance. Each time user performs transition an instance from stopped to started, OpenLink charges a full instance hour, even if transitions happen multiple times within a single hour.

Parameters

aws_access_key

Amazon Access Key ID.

instance_id

Image instance ID (check Amazon list of instances).

secret_key

AWS Security Token.

http_proxy

Proxy server, can be null or empty.

Examples

Example 24.231. Simple Use

create procedure simple_test()
{
  declare access_key, sec_token, p_name varchar;

  access_key := 'AKIAJI7ZL427TI5EDF5A'; -- amazon manager site access key
  sec_token  := 'CGI/UMaXf2LRUctaj/HGJ57UNy/t7fNCshh8wpJg'; -- amazon manager site secret token
  p_name     := 'my_instance_of_linux';

  DB.DBA.AMAZON_STOP_INSTANCE (access_key, p_name, sec_token);

}
;