All AWS database engines are purpose-built, meaning they address specific needs. Your use cases drive your database strategy to solve specific business challenges and application needs.
What Kind of AWS Database Services are Available?
From relational databases to key-value ones to everything in between, AWS addresses varied needs with solutions for every application and use case.
This cloud-native relational database engine is MySQL- and PostgreSQL-compatible but costs less to manage. AWS reports it’s five times faster than standard MySQL standard databases and three times faster than PostgreSQL.
A fault-tolerant, distributed and self-healing storage system auto-scales up to 64TB per database instance. Amazon Aurora continuously backups to Amazon S3 (Simplified Storage Service) and replicates across three availability zones. Amazon Aurora is fully managed by the Amazon Relational Database Service (RDS) and can be used for software-as-a-service (SaaS) apps, web and mobile gaming and many enterprise applications.
Amazon RDS is the key to automating time-consuming administration tasks like hardware provisioning, database setup, patching, and backups, simplifying your database experience in the cloud. It’s available on several instance types and gives users the choice of six different database engines.
- Amazon Aurora
- Oracle Database
- SQL Server
This fast cloud-based data warehouse powers analytical workloads that run on structured and semi-structured data. Query across your data warehouse, operational database and data lake using SQL. It is so named because it is intended to replace an organization’s Oracle database warehouse — organizations are then making the shift from Oracle (whose logo is red).
A NoSQL key-value and document database, Amazon DynamoDB can handle more than 10 trillion queries a day with single-digit millisecond performance. It can support peaks of more than 20 million requests per second, demonstrating its powerful performance at scale. It’s great for serverless web apps, microservices, mobile backends, IoT and more.
This web service simplifies the process of deploying, operating and scaling an in-memory cache in the cloud. Because you can quickly retrieve information from these managed caches rather than relying on slower, disk-based databases, you can improve web app performance. Amazon Elasticache supports both Redis and Mecached open-source, memory-caching engines.
A non-relational, fully managed, document database service, Amazon DocumentDB is built to provide high performance and availability for operating mission-critical MongoDB workloads at scale. It facilitates simple storage, queries and indexing of JSON data, offering 99.99% availability and replicating six copies of data across three availability zones.
Amazon KeySpaces is a highly available, scalable and managed serverless database that’s compatible with Apache Cassandra and is ideal for low-latency and open-source apps.
If you need a graph database that runs highly connected datasets, give Amazon Neptune a try. This database is optimized for storing billions of relationships and can query graphs in seconds. It supports such graph models as PropertyGraph and WC3’s RDF and their query languages, Apache TinkerPop Gremlin and SPARQL, respectively. Amazon Neptune powers a variety of graph use cases, including fraud detection, recommendation engines, knowledge graphs and more.
Amazon Quantum Ledger Database (QLDB)
A new class of database, Amazon QLDB is a fully managed ledger database that eliminates the need for you to build your own ledger-like applications. It delivers an immutable change history, using verifiable cryptography, tracking changes over time.
Designed for IoT and operational applications, Amazon Timestream makes it easy to store and analyze trillions of events each day. It processes these events using time intervals. This serverless database allows you to easily store and log data for such things as DevOps, IoT app sensors and industrial telemetry. Amazon Timestream automates rollups, retention, tiering and data compression.
Streamlining Database Migration
To migrate or replicate your existing databases to any AWS database service, use the AWS Database Migration service. This service keeps your source database fully operational during the migration to mitigate critical app downtime.
Using the resilient, self-healing AWS Database Migration service, you can easily and securely migrate your data to and from popular commercial and open-source databases. The service supports homogeneous migrations within the same platform or heterogeneous ones between platforms, such as moving from an Oracle Database to Amazon Aurora, for example.
You can quickly set up your migration tasks in AWS Management Console to define the parameters to execute the migration, including setting up the source and target databases and determining the replication instances. This tool provides constant monitoring during migration. If interrupted, it automatically restarts the process from where it was halted.
Once the migration is complete, your target database will remain synchronized to the source until you are ready to complete the final switchover.
Purpose-built databases, such as these available in the Amazon cloud, have much to offer and can help you target maximum performance of your applications, whether they are internet-scale or realtime, open-source or enterprise.
We want to be sure you understand all that Amazon Web Services has to offer, so be sure to check out other blogs in our AWS 101 series. You'll learn more about Amazon S3, deploying AWS Lambda to run code and using Auto Scaling to manage your infrastructure, among other topics. Take a look: