---

Amazon RDS Functionality

Amazon RDS is designed for developers or businesses who require the full features and capabilities of a relational database, or who wish to migrate existing applications and tools that utilize a relational database. It gives you access to the full capabilities of a MySQL 5.1 database running on your own Amazon RDS database instance.

To use Amazon RDS, you simply:

• Launch a database instance (DB Instance), selecting the DB Instance class and storage capacity that best meets your needs.
• Select the desired retention period (in number of days) for your automated database backups. Amazon RDS will automatically back up your database during your predefined backup window. For typical workloads, this allows you to restore to any point in time within your retention period, up to the last five minutes. You can also restore from a DB Snapshot, a user-initiated backup that can be run at any time with a simple API call.
• Connect to your DB Instance using your favorite database tool or programming language. Since you have direct access to a full-featured MySQL database, any tool designed for the MySQL engine will work unmodified with Amazon RDS.
• Monitor the compute and storage resource utilization of your DB Instance, for no additional charge, via Amazon CloudWatch. If at any point you need additional capacity, you can scale the compute and storage resources associated with your DB Instance with a simple API call.
• Pay only for the resources you actually consume, based on your DB Instance hours consumed, database storage, backup storage, and data transfer.

---

Service Highlights

Simple to Deploy – Amazon RDS makes it easy to go from project conception to deployment. Use simple API calls to access the capabilities of a production-ready relational database without worrying about infrastructure provisioning or installing and maintaining database software.

Managed – Amazon RDS handles generic, time-consuming database management tasks, such as patch management and backup, which allows you to pursue higher value application development or database refinements.

Compatible – With Amazon RDS, you get full native access to a MySQL database. This means Amazon RDS works with your existing tools, applications, and drivers. You can port an existing database to Amazon RDS without changing a line of code – just point your tools or applications at your Amazon RDS DB Instance and you are ready to go.

Scalable – With a simple API call you can scale the compute and storage resources available to your database to meet your business needs and application load.

Reliable – Amazon RDS runs on the same highly reliable infrastructure used by other Amazon Web Services. Amazon RDS gives you additional peace of mind by enabling automated database backup. For typical workloads, this allows you to restore your DB Instance to any point in time during your retention period, up to the last five minutes. And, there is no additional charge for backup storage, up to 100% of your primary provisioned storage size.

Designed for use with other Amazon Web Services – Amazon RDS is tightly integrated with other Amazon Web Services. For example, an application running in Amazon EC2 will experience low-latency database access to an Amazon RDS DB Instance in the same region.

Secure – Amazon RDS provides web service interfaces to configure firewall settings that control network access to your database.

Inexpensive – You pay very low rates and only for the resources you actually consume. There are no long-term contracts or up-front commitments to use Amazon RDS.

DB Instance Classes

Amazon RDS currently supports five DB Instance Classes:

• Small DB Instance: 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform.
• Large DB Instance: 7.5 GB memory, 4 ECUs (2 virtual cores with 2 ECUs each), 64-bit platform
• Extra Large DB Instance: 15 GB of memory, 8 ECUs (4 virtual cores with 2 ECUs each), 64-bit platform
• Double Extra Large DB Instance: 34 GB of memory, 13 ECUs (4 virtual cores with 3,25 ECUs each), 64-bit platform
• Quadruple Extra Large DB Instance: 68 GB of memory, 26 ECUs (8 virtual cores with 3.25 ECUs each), 64-bit platform

For each DB Instance class, RDS provides you with the ability to select from 5GB to 1TB of associated storage capacity. One ECU provides the equivalent CPU capacity of a 1.0-1.2 GHz 2007 Opteron or 2007 Xeon processor.

---

Pricing

Pay only for what you use. There is no minimum fee.

Amazon RDS DB Instance Pricing

On Demand Instance Pricing:

Pricing is per DB Instance-hour consumed, from the time a DB Instance is launched until it is terminated. Each partial DB Instance-hour consumed will be billed as a full hour.

Provisioned Database Storage

For each DB Instance class, Amazon RDS provides you the ability to select from 5 GB to 1 TB of associated storage capacity for your primary data set.

• $0.10 per GB-month of provisioned storage
• $0.10 per 1 million I/O requests

Backup Storage

Backup storage is the storage associated with your automated database backups and any user-initiated DB Snapshots you have taken. Increasing your backup retention period or taking additional database snapshots increases the backup storage consumed by your database.

• There is no additional charge for backup storage up to 100% of your provisioned database storage for an active DB Instance.* After the DB Instance is terminated, backup storage is billed at $0.15 per GB-month.
• Additional backup storage: $0.15 per GB-month

* For example, if you have an active DB Instance with 10GB-month of provisioned database storage, we will provide up to 10GB-month of backup storage at no additional charge. Based upon our experience as database administrators, the vast majority of databases require less raw storage for a backup than for the primary data set, meaning that most customers will never pay for backup storage.

Data Transfer

The pricing below is based on data transferred “in” and “out” of Amazon RDS.

Data Transfer In

• All Data Transfer $0.10 per GB

Data Transfer Out

• First 10 TB per Month $0.17 per GB
• Next 40 TB per Month $0.13 per GB
• Next 100TB per Month $0.11 per GB
• Over 150 TB per Month $0.10 per GB

Data transferred between two Amazon Web Services within the same region (e.g. between Amazon SQS US and Amazon RDS US) is free of charge. Data transferred between AWS services in different regions will be charged as Internet Data Transfer on both sides of the transfer.

Availability Zone Data Transfer

• $0.00 per GB – all data transferred between instances in the same Availability Zone using private IP addresses.
• $0.01 per GB in/out – all data transferred between Amazon EC2 instances, or between Amazon EC2 instances and Amazon RDS DB Instances in different Availability Zones in the same region.

All pricing listed above is for DB Instances running in the US Region. We expect to make the service available in the EU Region in the coming months.

---

Resources

---

Detailed Description

Working with Amazon RDS

Amazon RDS allows you to use a simple set of web services APIs to create, delete and modify relational database instances (DB Instances). You can also use the APIs to control access and security for your instance(s) and manage your database backups and snapshots. For a full list of the available Amazon RDS APIs, please see the Amazon RDS API Guide. Some of the most commonly used APIs and their functionality are listed below:

• CreateDBInstance — Provision a new DB Instance, specifying DB Instance class, storage capacity and the backup retention policy you wish to use. This one API call is all that’s needed to give you access to a running MySQL database, with the software pre-installed and the available resource capacity you request.
• ModifyDBInstance — Modify settings for a running DB Instance. This lets you use a single API call to scale the resources available to your DB Instance in response to the load on your database, or change how it is automatically backed up and maintained on your behalf.
• DeleteDBInstance — Delete a running DB Instance. With Amazon RDS, you can terminate your DB Instance at any time and pay only for the resources you used.
• CreateDBSnapshot — Generate a snapshot of your DB Instance. You can restore your DB Instance to these user-created snapshots at any point, even to reinstate a previously deleted DB Instance.
• RestoreDBInstanceToPointInTIme — Create a new DB Instance from a point-in-time backup. You can restore to any point within the retention period you specified, usually up to the last five minutes of your database’s usage.

For a brief explanation on how simple it is to get started using Amazon RDS, see AWS Evangelist Jeff Barr’s post announcing Amazon RDS.

Easily port your existing MySQL-based applications

If your application already relies on a MySQL database, porting to Amazon RDS is simple. In general, to port your application to Amazon RDS you simply:

• Create a DB Instance with the compute, storage capacity and access controls required.
• For smaller databases (e.g. up to 1 GB), extract the data with mysqldump and pipe it directly into Amazon RDS. Below is an example showing the “acme” database being copied to Amazon RDS:

mysqldump acme | mysql --host=hostname --user=username --password acme

• For larger databases, build your database schema in Amazon RDS, then convert the data into a flat file and import it into your DB Instance using the mysqlimport utility. Below is an example showing the “acme” database being copied to Amazon RDS:

mysqlimport --local --compress --user=username --password --host=hostname --fields-terminated-by=',' Acme sales.part_*

• Update the database connection string in your application config file.

For more information on porting an application to Amazon RDS, see the Amazon RDS Customer Data Import Guide for MySQL

New Features for Amazon RDS Coming Soon

To help you better plan future hardware and software investments, Amazon RDS would like to share the following features that we plan to make available in the coming months:

• Reserved DB Instances — With Reserved DB Instances you pay a low, one-time fee and in turn receive a discount on the ongoing hourly usage charge for that DB Instance. Reserved DB Instances can provide substantial savings over owning your own hardware or even running only On-Demand DB Instances.
• High Availability Offering — For developers and business who want additional resilience beyond the automated backups provided by Amazon RDS at no additional charge. With the high availability offer, developers and business can easily and cost-effectively provision synchronously replicated DB Instances in multiple availability zones (AZ’s), to protect against failure within a single location.

Paying for What You Use

You will be charged at the end of each month for the Amazon RDS resources you actually consume. Once a DB Instance you have created is available for connection, you will be charged for each hour your DB Instance is running (e.g. $0.11/hr for a Small DB Instance). Each DB Instance will run until termination, which occurs when you issue an API call to delete the DB Instance, or in the event of an instance failure. Partial DB Instance hours consumed are billed as full hours. In addition to DB Instance hours, you are also billed for your monthly storage, IO requests, and backups. If you scale your storage capacity within the billing period, your bill will be pro-rated accordingly.

Getting Started

The best way to understand Amazon RDS is to review the Getting Started Guide, part of our Technical Documentation. Within a few minutes, you will be able to log into your own instance and start building applications.

Choosing an AWS Database Solution

Amazon Web Services provides a number of database alternatives for developers. Amazon RDS enables you to run a fully featured relational database while offloading database administration; Amazon SimpleDB provides simple index and query capabilities with seamless scalability; and using one of our many relational database AMIs on Amazon EC2 and Amazon EBS allows you to operate your own relational database in the cloud. There are important differences between these alternatives that may make one more appropriate for your use case.

Amazon RDS

If your application requires relational storage, but you want to reduce the time you spend on database management, Amazon RDS automates common administrative tasks to reduce your complexity and total cost of ownership. Amazon RDS automatically backs up your database and maintains your database software, allowing you to spend more time on application development. With the native database access Amazon RDS provides, you get the programmatic familiarity, and tooling and application compatibility, of a traditional relational database. You also benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your relational database instance via a single API call.

With Amazon RDS, you still control the database settings that are specific to your business. This includes building a relational schema to fit your use case, creating indices, and tuning the performance of your database to your application’s workflow. You also take an active role in the scaling decisions for your database – you tell the service when you want to add more storage or change to a larger or smaller DB Instance class.

We recommend Amazon RDS for customers who:

• Have existing or new applications, code, or tools that require a relational database
• Want native access to a MySQL relational database, but prefer to offload the infrastructure management and database administration to AWS
• Like the flexibility of being able to scale their database compute and storage resources with an API call, and only pay for the infrastructure resources they actually consume

Amazon EC2 – Relational Database AMIs

Developers may use a number of leading relational databases on Amazon EC2. An Amazon EC2 instance can be used to run a database, and the data can be stored within an Amazon Elastic Block Store (Amazon EBS) volume. Amazon EBS is a fast and reliable persistent storage feature of Amazon EC2. By designing, building, and managing their own relational database on Amazon EC2, developers avoid the friction of provisioning and scaling their own infrastructure while gaining access to a variety of standard database engines over which they can exert full administrative control. Available AMIs include IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase, Aster Data, and Vertica.

We recommend Amazon EC2 Relational Database AMIs for customers who:

• Wish to select from a wide variety of database engines
• Want to exert complete administrative control over their database server

Amazon SimpleDB

For database implementations that do not require a relational model, and that principally demand index and query capabilities, Amazon SimpleDB eliminates the administrative overhead of running a highly-available production database, and is unbound by the strict requirements of a RDBMS. With Amazon SimpleDB, you store and query data items via simple web services requests, and Amazon SimpleDB does the rest. In addition to handling infrastructure provisioning, software installation and maintenance, Amazon SimpleDB automatically indexes your data, creates geo-redundant replicas of the data to ensure high availability, and performs database tuning on customers’ behalf. Amazon SimpleDB also provides no-touch scaling. There is no need to anticipate and respond to changes in request load or database utilization; the service simply responds to traffic as it comes and goes, charging only for the resources consumed. Finally, Amazon SimpleDB doesn’t enforce a rigid schema for data. This gives customers flexibility – if their business changes, they can easily reflect these changes in Amazon SimpleDB without any schema updates or changes to the database code.

However, Amazon SimpleDB is not a relational database, and does not offer some features needed in certain applications, e.g. complex transactions or joins.

We recommend Amazon SimpleDB for customers who:

• Principally utilize index and query functions rather than more complex relational database functions
• Don’t want any administrative burden at all in managing their structured data
• Want a service that scales automatically up or down in response to demand, without user intervention
• Require the highest availability and can’t tolerate downtime for data backup or software maintenance

More Information

Visit the Running Databases on AWS page for more detailed information on the various database alternatives for your applications.

---

Intended Usage and Restrictions

Your use of this service is subject to the Amazon Web Services Customer Agreement.