AWS Database Blog

In this post, we discuss configurations in AWS DMS endpoints and AWS DMS tasks to migrate spatial columns from Oracle to Aurora PostgreSQL-Compatible efficiently.

Vacasa is North America’s leading vacation rental management platform, revolutionizing the rental experience with advanced technology and expert teams. In the competitive short-term vacation property management industry, efficient systems are critical. To maintain its edge and continue providing top-notch service, Vacasa needed to modernize its primary transactional database to improve performance, provide high availability, and reduce costs. In this post, we share Vacasa’s journey from HAQM Relational Database Service (HAQM RDS) for MariaDB to HAQM RDS for MySQL, and finally to HAQM Aurora, highlighting the technical steps taken and the outcomes achieved.

HAQM DynamoDB enables you to back up your table data continuously by using point-in-time recovery (PITR). When you enable PITR, DynamoDB backs up your table data automatically with per-second granularity. PITR helps protect you against accidental writes and deletes. For example, if a test script accidentally writes to a production DynamoDB table, or someone mistakenly […]

In this post, we discuss integer sequence overflow, its causes, and—most importantly—how to efficiently set up alerts using HAQM SNS and use AWS Lambda to resolve such issues in HAQM Aurora PostgreSQL-Compatible Edition and HAQM RDS for PostgreSQL.

In this post, we focus on working with the features of mysql_fdw PostgreSQL extension on HAQM RDS for PostgreSQL to help manage a large set of data that on an external database scenarios. It enables you to interact with your MySQL database for importing individual/large/selectively number of objects at the schema level and simplifying how we get information about the MySQL/MariaDB schema, to make it easier to ultimately read/write data. We will also provide an introduction to understand query performance on foreign tables.

There are a variety of different techniques available to support data masking in databases, each with their trade-offs. In this post, we explore dynamic data masking, a technique that returns anonymized data from a query without modifying the underlying data. In this post, we discuss a dynamic data masking technique based on dynamic masking views. These views mask personally identifiable information (PII) columns for unauthorized users. This post discusses how to implement this technique in HAQM RDS for PostgreSQL and HAQM Aurora PostgreSQL including Babelfish for Aurora PostgreSQL.

In this post, we show how to implement automatic conflict detection and resolution (Auto-CDR) for Oracle GoldenGate bi-directional replication between HAQM RDS for Oracle databases.

In this post, we walk you through how to make your HAQM Timestream for InfluxDB deployments more secure by offering a mechanism to automatically rotate long-lived credentials. We use AWS Secrets Manager to store your tokens and user credentials as secrets and rotate the secrets using the included AWS Lambda functions.

In this post, we provide details on two PostgreSQL plugins available for use by AWS DMS. We compare these plugin options and share test results to help database administrators understand the best practices and benefits of each plugin when working on migrations.

In the world of air travel, baggage handling isn’t just about keeping track of baggage, but a seamless orchestration of different processes to improve the passenger baggage experience. A key component to make this happen is a strong database management strategy. In this post, we discuss how AWS Partner IBM Consulting developed an initiative to modernize a traditional baggage database architecture using HAQM DynamoDB and other HAQM Web Services (AWS) managed services, addressing the evolving needs of the airline industry.