AWS Database Blog

A best practice for the deployment of AWS resources is to use a configuration system that treats your infrastructure as code. Infrastructure as code is a key enabler of DevOps practices, which bring developers and operations together to collaborate on automating application delivery at scale. By modeling your entire infrastructure as code in AWS CloudFormation […]

The AWS Schema Conversion Tool (AWS SCT) helps convert your existing database schema from one database engine to another. You can convert from a relational OLTP schema or any supported data warehouse OLAP schema to Amazon RDS (for example, Amazon Aurora MySQL or Amazon Aurora PostgreSQL, among others). You can also convert from a relational […]

January 2023: This post was reviewed and updated for accuracy. To leverage high availability, scalability and cost optimization, often times, Developers and Database administrators want to access their databases from a Serverless Application. An application that can automatically scale, inherently highly available and run without provisioning or managing an EC2 host is known as a […]

The Amazon DynamoDB Developer Guide provides an overview of concepts and detailed instructions for using the various features of Amazon DynamoDB. The following list contains the 20 most visited pages in the guide during the first two months of 2018. We’ve included a brief description with each link to explain what each page covers. Use […]

September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. To ensure high fidelity parsing and matching for Korean text, Amazon Elasticsearch Service (Amazon ES) now supports the Seunjeon plugin. Using this plugin, you can create a custom analyzer that gives your users better results. Processing Asian languages for search […]

A challenge that some organizations face when moving to the cloud is how best to migrate or integrate old legacy infrastructure with restrictive licensing to an environment that offers a breadth of functionality and pay-as-you-go pricing. AWS provides many options to help customers in their analysis and planning. One common approach is to establish a […]

Migrating monolithic mission-critical Microsoft SQL Server databases from on-premises to AWS (that is, to SQL Server based on Amazon EC2) is often a challenging task. The challenge comes mostly from the following: A prolonged downtime window during cutovers that can have an adverse impact on the business Challenges involved in keeping the databases (both on-premises […]

November 2022: This post was reviewed and updated for accuracy. AWS recently announced general availability of Amazon Aurora with PostgreSQL compatibility. With this release, AWS has also included the first release of a useful feature in Amazon Relational Database Service (Amazon RDS) called Performance Insights. Using a dashboard that visualizes database load—along with which SQL […]

September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. Some of our customers have asked for guidance on analyzing Amazon Elasticsearch Service (Amazon ES) slow logs efficiently. Here is what one of these customers said: “We want to identify, understand, and troubleshoot any slow-running queries in our Amazon Elasticsearch […]

With a microservices architecture, distributed teams often need a central operational excellence team to make sure that the rest of the organization is following operational best practices. For example, you might want to know if you configured lifecycle policy, versioning, and access policies properly for objects in an Amazon S3 bucket. Proper configurations ensure that […]