AWS Database Blog

Category: Database

Amazon Aurora Under the Hood: Fast DDL

Anurag Gupta runs a number of AWS database services, including Amazon Aurora, which he helped design. In the Under the Hood series, Anurag discusses the design considerations and technology underpinning Aurora. Amazon Aurora is a MySQL-compatible database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. […]

Read More

Testing Automatic Failover to a Read Replica on Amazon ElastiCache for Redis

Darin Briskman is a developer evangelist at Amazon Web Services. You can reach him @briskmad “Trust, but verify.” — U. S. President Ronald Reagan, 1987 In this comment, President Reagan quoted a Russian proverb to describe his philosophy for nuclear disarmament treaties. But the same philosophy also applies well to DevOps! Amazon ElastiCache for Redis […]

Read More

Implement Linked Servers with Amazon RDS for Microsoft SQL Server

Linked servers allow Microsoft SQL Server to run SQL Server statements on other instances of database servers. In this blog post, we focus on connectivity to other instances of SQL Server in Amazon RDS, hosted in Amazon EC2, or available from your data centers via a VPN or direct connect. We examine two connectivity scenarios: […]

Read More

ElastiCache for Redis Backup and Restore with Cluster Resizing

Clusters provide a lot of capabilities in Amazon ElastiCache for Redis. Using autosharding to distribute data across the shards of a cluster enables high performance (over 4.5m writes/sec and 20m reads/sec, with each operation typically under 500µs) and high capacity (up to 3.5TiB of data) with high reliability and with recovery of failed nodes usually […]

Read More

Amazon ElastiCache: Utilizing Redis Geospatial Capabilities

Amazon ElastiCache makes it easy to deploy and manage a highly available and scalable in-memory data store in the cloud. Among the open source in-memory engines available to you for use with ElastiCache is Redis, which added powerful geospatial capabilities in version 3.2. This post explores using these capabilities to build an app that locates […]

Read More

Reduce Resource Consumption by Consolidating Your Sharded System into Aurora

Ed Murray is a manager at Amazon Web Services. When faced with the prospect of scaling your relational workload, you have generally had two options available: scale up or scale out. Scaling up is easy—just buy a bigger database host. Scaling out is more difficult. It requires you to shard your database into several physically […]

Read More

Choosing the Right DynamoDB Partition Key

This blog post covers important considerations and strategies for choosing the right partition key for designing a schema that uses Amazon DynamoDB. Choosing the right partition key is an important step in the design and building of scalable and reliable applications on top of DynamoDB. What is a partition key? DynamoDB supports two types of […]

Read More

How to Migrate Your Oracle Database to Amazon Aurora

Ed Murray is a manager at Amazon Web Services. This blog post gives you a quick overview of how you can use the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) to facilitate and simplify migrating your commercial database to Amazon Aurora. In this case, we focus on migrating from […]

Read More

Performing Parallel Queries and Phrase Searching with Amazon RDS for PostgreSQL 9.6.1

Jeff Levine is a solutions architect for Amazon Web Services. As a solutions architect for Amazon Web Services, one of my responsibilities is to help our customers to learn about new features and capabilities of our services. Amazon RDS makes it possible to set up, operate, and scale relational databases in the cloud without having […]

Read More

Streaming Changes in a Database with Amazon Kinesis

Emmanuel Espina is a software development engineer at Amazon Web Services. In this blog post, I will discuss how to integrate a central relational database with other systems by streaming its modifications through Amazon Kinesis. The following diagram shows a common architectural design in distributed systems. It includes a central storage referred to as a […]

Read More