AWS Database Blog

Currently, even though the actual chain of API calls is still necessary, the AWS API automates this workflow for you.

Managing Amazon RDS databases in multi-account environments with the AWS CLI

AWS provides AWS organizations and AWS Landing Zone solutions to manage and automate new account creation. This helps you to create multiple AWS accounts separated based on applications, development, production, or organizations within a company. This approach helps with resource isolation and separating development from production, but makes it complex for some of the teams […]

Read More
Image

Creating a REST API for Amazon DocumentDB (with MongoDB compatibility) with Amazon API Gateway and AWS Lambda

Representational state transfer (REST) APIs are a common architectural style for distributed systems. They benefit from being stateless and therefore enable efficient scaling as workloads increase. These convenient—yet still powerful—APIs are often paired with database systems to give programmatic access to data managed in a database. One request that customers have expressed is to have […]

Read More
Image

Ensuring consistent performance after major version upgrades with Amazon Aurora PostgreSQL Query Plan Management

Keeping your database version up to date provides benefits like improved performance and security, access to new features, fixes to known issues, compliance with regulatory requirements, and more. However, there is also a risk of some queries experiencing performance regression following a database upgrade. This risk is higher with major version upgrades because they can […]

Read More
When you’re finished, your dashboard should look similar to the following screenshot.

Monitoring metrics and setting up alarms on your Amazon DocumentDB (with MongoDB compatibility) clusters

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. You can use the same MongoDB 4.0 application code, drivers, and tools to run, manage, and scale workloads on Amazon DocumentDB without having to worry about managing the underlying infrastructure. As a document database, […]

Read More
The following diagram illustrates this architecture.

Best practices for using a MySQL read replica to upgrade an Amazon RDS for MySQL database

The following common technique is used to perform maintenance on a MySQL database: Create a read replica of the database. Perform maintenance on the read replica. Promote the read replica to replace the original database. This post walks you through some best practices for performing a major version upgrade on an Amazon RDS for MySQL […]

Read More
Image

2020: The year in review for Amazon DynamoDB

2020 has been another busy year for Amazon DynamoDB. We released new and updated features that focus on making your experience with the service better than ever in terms of reliability, encryption, speed, scale, and flexibility. The following 2020 releases are organized alphabetically by category and then by dated releases, with the most recent release […]

Read More
Image

Migrating an on-premises SQL Server database to Amazon RDS on VMware using SQL Server native backup and restore

Amazon RDS on VMware delivers managed SQL Server databases in on-premises VMware environments. Managing SQL Server can be complex and time-consuming, but RDS on VMware makes it easy to provision, scale, and operate SQL Server in VMware vSphere clusters. You can migrate your existing on-premises SQL Server databases to RDS on VMware to benefit from […]

Read More
Image

Federated query support for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL

PostgreSQL is one of the most widely used database engines and is supported by a very large and active community. It’s a viable open-source option to use compared to many commercial databases, which require heavy license costs. Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL are AWS managed offerings that take away the heavy lifting […]

Read More
Database reset in Neptune is a two-step process.

Resetting your graph data in Amazon Neptune in seconds

As an enterprise application developer building graph applications with Amazon Neptune, you may want to delete and reload your graph data on a regular basis to make sure you’re working with the latest changes in your data, such as new relationships between nodes, or to replace test data with production data. In the past, you […]

Read More