AWS Database Blog

Replicate data between partitioned and non-partitioned tables using trigger functions in Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL

In this post, we show you how to replicate data between partitioned and non-partitioned tables using trigger functions in Amazon Aurora PostgreSQL-Compatible Edition. The solution also works with Amazon Relational Database Service (Amazon RDS) for PostgreSQL. Customers often decide to migrate partial applications and their associated database objects to AWS, which requires synchronizing data from […]

Accelerate your database migration journey using AWS DMS Schema Conversion

AWS Database Migration Service (AWS DMS) helps you accelerate your database migrations to AWS. It supports both homogeneous and heterogeneous migrations. Previously, you had to download the AWS Schema Conversion Tool (AWS SCT) to assess and convert your schema and code objects. Now, with AWS DMS Schema Conversion (DMS SC), you can assess, convert, and […]

Update your Amazon DocumentDB TLS certificates: Expiring in 2024

You may have seen the recent notifications to rotate your SSL/TLS certificates in Amazon RDS and Amazon Aurora, or you may have already received notification from AWS about updating your Amazon DocumentDB TLS certificates before they update starting in August 2024. If you are using Amazon DocumentDB (with MongoDB compatibility) clusters with Transport Layer Security […]

Amazon Robotics achieves worldwide scale and improves engineering efficiency by 35% with Amazon DynamoDB

Amazon Robotics (AR) designs advanced robotic solutions so the Amazon fulfillment network can meet delivery promises for millions of customers every day. AR builds critical software that controls over a half a million mobile robots used in hundreds of Amazon sites spanning North America, Europe, Asia, and Australia. With a focus on engineering efficiency, the […]

Achieve continuous delivery with blue/green deployments using Amazon DocumentDB database cloning and AWS DMS

In the fast-paced realm of digital transformation, organizations are navigating a landscape of unprecedented change and opportunity. As businesses evolve to meet the demands of modern consumers and markets, the need for agile delivery of enhancements to existing applications is becoming more and more essential. Zero downtime during application deployment is one of the key […]

Orchestrate an AWS DMS Serverless replication task using AWS CLI

Database migration is a critical aspect of modern IT operations, especially when you need to switch database systems while ensuring minimal downtime and data loss. AWS DMS Serverless is a feature of AWS Database Migration Service (AWS DMS) that provides automatic provisioning, scaling, built-in high availability, and a reduced billing model based on workload changes […]

Identify PostgreSQL semantic issues with the plpgsql_check extension

One critical aspect during the migration process from Oracle to PostgreSQL is identifying any semantic issues that may arise when translating Oracle-specific code to PostgreSQL. Although Oracle performs both semantic and syntax checks during code compilation, PostgreSQL focuses solely on syntax checks during code compilation, leaving room for potential semantic discrepancies in the converted code […]

Run a WAX Blockchain node using AWS CDK

WAX is a blockchain-based system designed for the unique demands of the gaming industry. It provides high transaction throughput and near-instant block finality. With WAX, game developers can decouple in-game digital assets from a single in-game world and let gamers use them in new contexts such as building walls of fame, creating personal online trophy […]

Amazon RDS Multi-AZ DB Clusters support new storage configurations

Amazon Relational Database Service (Amazon RDS) Multi-AZ DB Clusters are a great way to improve the performance and reduce the cost of demanding database workloads. Since RDS Multi-AZ DB Clusters were launched in March 2022, they have become an increasingly popular option for workloads that need more performance than a single RDS instance can support. […]

Run a serverless Arbitrum full node on AWS

Over the last 2 years, layer 2 technologies have gained traction and are solving the scaling constraints of Ethereum. L2beat provides a consolidated view of the different layer 2 projects. At the time of writing, Arbitrum represents approximatively half of the market value of layer 2 solutions. AWS offers a variety of services to help […]