AWS Database Blog

Implement Linked Servers with Amazon RDS for Microsoft SQL Server

Richard Waymire is a principal database specialist solutions architect for Amazon Web Services Linked servers allow Microsoft SQL Server to run SQL Server statements on other instances of database servers. In this blog post, we will focus on connectivity either to other instances of SQL Server in Amazon RDS or to SQL Server instances hosted […]

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

Josh Kahn is a Solutions Architect at Amazon Web Services. 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 […]

Read More

Get Started with Amazon Elasticsearch Service: How Many Shards Do I Need?

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future blog posts, we provide the basic information that you need to get started with Elasticsearch on AWS. How many shards? Elasticsearch can take in large amounts of data, split it into smaller units, called shards, and distribute those […]

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

Set Access Control for Amazon Elasticsearch Service

Securing your Amazon Elasticsearch Service (Amazon ES) domain helps ensure your data cannot be accessed or altered by unauthorized users. Most customers want the security of IP address- or identity-based access policies, but choose open access out of convenience. Because a domain with open access will accept requests to create, view, modify, and delete data […]

Read More

Choosing the Right DynamoDB Partition Key

Gowri Balasubramanian is a solutions architect at Amazon Web Services This blog post will cover important considerations and strategies for choosing the right partition key while migrating from a relational database to DynamoDB. This is an important step in the design  and building of scalable and reliable applications on top of DynamoDB. What is a […]

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