Amazon Relational Database Service

User Guide (API Version 2014-10-31)

What Is Amazon RDS?
Setting Up
Getting Started
- Creating an Aurora DB Instance on an Aurora Cluster and Connecting to a Database
- Creating a MariaDB DB Instance and Connecting to a Database
- Creating a Microsoft SQL Server DB Instance and Connecting to a DB Instance
- Creating a MySQL DB Instance and Connecting to a Database
- Creating an Oracle DB Instance and Connecting to a Database
- Creating a PostgreSQL DB Instance and Connecting to a Database
- Tutorial: Create a Web Server and an Amazon RDS Database
  - Step 1: Create a DB Instance
  - Step 2: Create a Web Server
Tutorials
Best Practices
DB Instances
- DB Instance Class
- DB Instance Status
- DB Instance Storage
- Regions and Availability Zones
- High Availability (Multi-AZ)
- DB Instance Lifecycle
- Tagging RDS Resources
- Working with Read Replicas
- Working with Option Groups
- Working with DB Parameter Groups
- Working with ARNs
- Working with Storage
- DB Instance Billing
  - On-Demand DB Instances
  - Reserved DB Instances
Backing Up and Restoring
- Working With Backups
- Creating a DB Snapshot
- Restoring from a DB Snapshot
- Copying a Snapshot
  - Copying a DB Snapshot
  - Copying a DB Cluster Snapshot
- Sharing a Snapshot
- Point-in-Time Recovery
- Tutorial: Restore a DB Instance from a DB Snapshot
Monitoring
- Enhanced Monitoring
- Performance Insights
- Using Amazon RDS Recommendations
- Using Amazon RDS Event Notification
- Viewing Amazon RDS Events
- Database Log Files
- Logging Amazon RDS API Calls with AWS CloudTrail
Security
- Authentication and Access Control
- Encrypting Amazon RDS Resources
- Using SSL to Encrypt a Connection
- IAM Database Authentication for MySQL and Aurora
- Amazon RDS Security Groups
- Working with DB Security Groups (EC2-Classic Platform)
- Master User Account Privileges
- Using Service-Linked Roles
- Using Amazon RDS with Amazon VPC
Amazon Aurora
- Overview of Amazon Aurora
- Creating a DB Cluster
  - Creating a VPC for Aurora
- Using Aurora Serverless
- Connecting to a DB Cluster
- Viewing a DB Cluster
- DB Cluster Status
- Migrating Data to a DB Cluster
- Managing a DB Cluster
- Monitoring a DB Cluster
- Replication with Aurora
- Cloning Databases in an Aurora DB Cluster
- Integrating with AWS Services
  - Using Auto Scaling with Aurora Replicas
- Working with Aurora MySQL
- Working with Aurora PostgreSQL
- Best Practices with Aurora
- Aurora Updates
MariaDB on Amazon RDS
- Creating a DB Instance Running MariaDB
- Connecting to a DB Instance Running MariaDB
- Modifying a DB Instance Running MariaDB
- Upgrading the MariaDB DB Engine
- Migrating Data from a MySQL DB Snapshot to a MariaDB DB Instance
- Working with MariaDB Replication
  - Working with MariaDB Read Replicas
  - Configuring GTID-Based Replication
- Importing Data into a MariaDB DB Instance
- Options for MariaDB
- Parameters for MariaDB
- MariaDB on Amazon RDS SQL Reference
  - mysql.rds_set_external_master_gtid
  - mysql.rds_kill_query_id
Microsoft SQL Server on Amazon RDS
- Licensing SQL Server on Amazon RDS
- Creating a DB Instance Running SQL Server
- Connecting to a DB Instance Running SQL Server
- Modifying a DB Instance Running SQL Server
- Upgrading the SQL Server DB Engine
- Importing and Exporting SQL Server Databases
  - Importing and Exporting SQL Server Data Using Other Methods
- Multi-AZ Deployments for SQL Server with Database Mirroring
- Using SSL with a SQL Server DB Instance
- Options for SQL Server
  - Native Backup and Restore
  - Transparent Data Encryption
- Common DBA Tasks for SQL Server
- Advanced Administrative Tasks and Concepts for SQL Server
  - Using Windows Authentication with a SQL Server DB Instance
MySQL on Amazon RDS
- Creating a DB Instance Running MySQL
- Connecting to a DB Instance Running MySQL
- Modifying a DB Instance Running MySQL
- Upgrading the MySQL DB Engine
- Upgrading a MySQL DB Snapshot
- Importing Data into a MySQL DB Instance
- Working with MySQL Replication
  - Working with MySQL Read Replicas
  - Replication with a MySQL or MariaDB Instance Running External to Amazon RDS
- Exporting Data From a MySQL DB Instance
- Options for MySQL
  - MariaDB Audit Plugin
  - MEMCACHED
- Common DBA Tasks for MySQL
- Known Issues and Limitations
- MySQL on Amazon RDS SQL Reference
Oracle on Amazon RDS
- Creating a DB Instance Running Oracle
- Connecting to a DB Instance Running Oracle
- Modifying a DB Instance Running Oracle
- Upgrading the Oracle DB Engine
- Upgrading an Oracle DB Snapshot
- Importing Data into Oracle on Amazon RDS
- Oracle Character Sets
- Options for Oracle
- Common DBA Tasks for Oracle
- Tools and Third-Party Software for Oracle
- Oracle Database Engine Release Notes
  - Database Engine: 12.1.0.2
  - Database Engine: 11.2.0.4
PostgreSQL on Amazon RDS
- Creating a DB Instance Running PostgreSQL
- Connecting to a DB Instance Running the PostgreSQL Database Engine
- Modifying a DB Instance Running PostgreSQL
- Upgrading the PostgreSQL DB Engine
- Working with PostgreSQL Read Replicas
- Importing Data into PostgreSQL on Amazon RDS
- Common DBA Tasks for PostgreSQL
Limits
Troubleshooting
Amazon RDS API
- Using the Query API
- Troubleshooting Applications
Document History

Starting an Amazon RDS DB Instance That Was Previously Stopped

You can stop your Amazon RDS DB instance temporarily to save money. After you stop your DB instance, you can restart it to begin using it again. For more details about stopping and starting DB instances, see Stopping an Amazon RDS DB Instance Temporarily.

When you start a DB instance that you previously stopped, the DB instance retains the ID, Domain Name Server (DNS) endpoint, parameter group, security group, and option group. When you start a stopped instance, you are charged a full instance hour.

AWS Management Console

To start a DB instance

Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the navigation pane, choose Instances, and then select the DB instance that you want to start.
Choose Instance actions, and then choose Start.

CLI

To start a DB instance by using the AWS CLI, call the start-db-instance command with the following parameters:

--db-instance-identifier – the name of the DB instance.

Example


start-db-instance --db-instance-identifier mydbinstance

API

To start a DB instance by using the Amazon RDS API, call the StartDBInstance action with the following parameters:

DBInstanceIdentifier – the name of the DB instance.

Example


https://rds.amazonaws.com/
    ?Action=StartDBInstance
    &DBInstanceIdentifier=mydbinstance
    &SignatureMethod=HmacSHA256
    &SignatureVersion=4
    &Version=2014-10-31
    &X-Amz-Algorithm=AWS4-HMAC-SHA256
    &X-Amz-Credential=AKIADQKE4SARGYLE/20131016/us-west-1/rds/aws4_request
    &X-Amz-Date=20131016T233051Z
    &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date
    &X-Amz-Signature=087a8eb41cb1ab5f99e81575f23e73757ffc6a1e42d7d2b30b9cc0be988cff97

Warning Javascript is disabled or is unavailable in your browser.

To use the AWS Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Document Conventions

« Previous Next »

© 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

On this page:

AWS Management Console
CLI
API
Related Topics