AWS Database Blog

Migrating to Amazon Aurora MySQL with fallback option using GTID-based replication

When migrating production applications, it is often important to have a fallback option. This blog post demonstrates how to use global transaction identifier (GTID)-based replication to migrate Amazon RDS MySQL workloads to Amazon Aurora MySQL. We also discuss how to use a fallback mechanism in case you encounter any issues. For more information about GTID-based […]

Read More

Aurora PostgreSQL Disaster Recovery solutions using Amazon Aurora Global Database

Amazon Aurora with PostgreSQL compatibility combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Aurora provides this by scaling storage across three Availability Zones in the same Region, and supports up to 15 read replica instances for scaling out read workloads and high availability within a […]

Read More

Ramping up on Amazon DocumentDB (with MongoDB compatibility)

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. As a document database, Amazon DocumentDB makes it easy to store, query, and index JSON data. Amazon DocumentDB is compatible with MongoDB 3.6 drivers and tools. A vast majority of the applications, drivers, and […]

Read More

Migrating legacy PostgreSQL databases to Amazon RDS or Aurora PostgreSQL using Bucardo

If you are using PostgreSQL earlier than 9.4, you are using an unsupported version of PostgreSQL, and may have limited options to migrate or replicate your databases in Amazon RDS or Amazon Aurora PostgreSQL. This is primarily because PostgreSQL versions older than 9.4 can’t perform logical replication. Bucardo is an open-source utility that can replicate […]

Read More

Validate your expertise in AWS purpose-built databases with new AWS Certification

Today, we are announcing the new AWS Certified Database – Specialty certification, which validates an individual’s expertise in recommending, designing, and maintaining the optimal AWS database solution to improve performance, reduce costs, and enable innovation. This certification is the first to validate technical skill in AWS purpose-built databases. To create new AWS Certifications, we work […]

Read More

Configuring SSL encryption on Oracle and PostgreSQL endpoints in AWS DMS

AWS Database Migration Service (DMS) helps you migrate databases to AWS securely. It supports homogeneous and heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora. AWS DMS supports continuous data replication while maintaining high availability and has been widely adopted for database migrations because it is easy to configure. For more information, […]

Read More

Using IAM authentication to connect with pgAdmin Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL

Amazon Relational Database Service (RDS) enables you to use AWS Identity and Access Management (IAM) to manage database access for Amazon RDS for PostgreSQL database instances and Amazon Aurora PostgreSQL clusters. Database administrators can associate database users with IAM users and roles. With IAM database authentication, you don’t need to use a password when you connect to a database cluster. Instead, you […]

Read More

Running spiky workloads and optimizing costs by more than 90% using Amazon DynamoDB on-demand capacity mode

This is a guest post by Keisuke Utsumi, a Software Engineer with TVer Technologies Inc. In their own words, “TVer Technologies Inc. offers interactive entertainment services to users using a synchronized website with a TV broadcast.” TVer Technologies Inc. provides website and app-based interactive content for TV viewers in Japan. Many of our applications use […]

Read More

Migrating Oracle databases with near-zero downtime using AWS DMS

Do you have critical Oracle OLTP databases in your organization that can’t afford downtime? Do you want to migrate your Oracle databases to AWS with minimal or no downtime? In today’s fast-paced world with 24/7 application and database availability, some of your applications may not be able to afford significant downtime while migrating on-premises databases […]

Read More

Improving Oracle backup and recovery performance with Amazon EBS multi-volume crash-consistent snapshots

Amazon Elastic Block Store (EBS) snapshots offer the ability to back up the data on your EBS volumes to Amazon S3 by taking point-in-time snapshots. If you run your Oracle Databases on Amazon EC2 and use EBS volumes, you may be using EBS snapshots to meet your backup requirements. Prior to May 2019, you had […]

Read More