AWS Database Blog

Category: Technical How-to

Migrate Amazon Aurora and Amazon RDS to a new AWS Region

At times you may need to migrate your workloads from one AWS Region to another Region. In this post, we highlight best practices for cross-Region migration of Amazon Relational Database Service (Amazon RDS) and Amazon Aurora . We provide prescriptive guidance on migration of various components related to the RDS databases. We also discuss the […]

Migrate ROW CHANGE TIMESTAMP from IBM Db2 for z/OS to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition

Customers migrate their mission-critical legacy on-premises databases based on IBM Db2 for z/OS to Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition for its scalability, performance, agility and availability. In heterogeneous database migrations, not all features in the source database are supported or available in the target database. One such […]

Enable Kerberos authentication with Amazon RDS Custom for Oracle – Part 1

Amazon Relational Database Service (Amazon RDS) Custom for Oracle allows you the flexibility to configure the database authentication method that can help you meet your security needs. A common and traditional method is to use database authentication via user names and passwords, but this method requires more effort from both administrators and users to manage, […]

Support JSON data using Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL and Java Spring Boot on AWS

Many customers choose Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition to store JSON business objects along with relational transactional data. You can also use the Spring Boot Java framework to implement microservice applications. The Spring Boot framework provides rich features, including auto configuration, dependency injection, metrics measurement, health checks, […]

Amazon DynamoDB schema from the prism of SQL

A database is one of the main components of software system design. RDBMS has been a cornerstone of application development for decades, making SQL the language of choice for most developers. As application requirements for scalability and availability are changing rapidly, Amazon DynamoDB—a serverless, NoSQL key-value database that delivers single-digit millisecond performance at any scale […]

Enable change data capture on Amazon RDS for MySQL applications that are using XA transactions

XA transactions are not a very familiar concept to lots of people and therefore hardly used. An XA transaction is a two-phase commit protocol that supports distributed transactions that updates multiple relational databases. It involves a transaction manager that monitors this global transaction. XA makes sure that transactional updates are committed in all of the […]

Build resilient applications with Amazon DynamoDB global tables: Part 4

In the first three posts of this four-part series, you learned how the choice of zonal or Regional services impacts availability, and some important characteristics of Amazon DynamoDB when used in a multi-Region context with global tables. Part 1 also covered the motivation for using multiple Regions. Part 2 discussed some important characteristics of DynamoDB. […]

Build resilient applications with Amazon DynamoDB global tables: Part 3

In the first two posts of this four-part series, you learned how the choice of zonal or Regional services impacts availability and some important characteristics of Amazon DynamoDB when used in a multi-Region context with global tables. Part 1 also covered the motivation for using multiple AWS Regions. Part 2 discussed some important characteristics of […]

Build resilient applications with Amazon DynamoDB global tables: Part 2

In the first post of this series, you learned about the differences between zonal, Regional, and global services, and how they affect theoretical application availability. In this post, you’ll learn more about some important Amazon DynamoDB characteristics and how they impact multi-Region design. Properties of DynamoDB tables in a single Region DynamoDB is a NoSQL […]

Build resilient applications with Amazon DynamoDB global tables: Part 1

Customers that need to build resilient applications with the lowest possible recovery time objective (RTO) and recovery point objective (RPO) want to make the best use of AWS global infrastructure to support their resilience goals. Building an application using multiple Availability Zones in a single AWS Region can provide high levels of availability, but you […]