AWS Database Blog

Key considerations while migrating bulk operations from Oracle to PostgreSQL

AWS launched Amazon Database Migration Accelerator (Amazon DMA) to accelerate your journey to AWS databases and analytics services and achieve cloud adoption benefits such as cost savings and performance improvements. Amazon DMA has assisted thousands of customers globally to migrate their workloads (database and application) to AWS databases and analytics services. In this post, we […]

Use Amazon DynamoDB global tables in DynamoDB Shell

Global tables build on the global Amazon DynamoDB footprint to provide you with a fully managed, multi-Region, multi-active database that delivers fast, local, read and write performance for massively scaled, global applications. Global tables replicate your DynamoDB tables automatically across your choice of AWS Regions. DynamoDB Shell is an interactive command line interface for DynamoDB. […]

Multitenant best practices for Amazon RDS Custom for Oracle

Amazon Relational Database Service (Amazon RDS) Custom for Oracle is a managed database service for legacy, custom, and packaged applications that require access to the underlying operating system and database environment. Amazon RDS Custom now supports the Oracle Multitenant option on Oracle Database version 19c using Enterprise Edition. With this release, an RDS Custom for […]

Automate creation of multiple AWS DMS endpoints and replication tasks using the AWS CLI

July 2023: This post was reviewed for accuracy. AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps move your database and analytics workloads to AWS quickly, securely, and with minimal downtime and zero data loss. AWS DMS can migrate your data from AWS DMS supported sources to AWS DMS […]

Securely generate Ethereum validator keys at low cost using a serverless architecture on AWS

The new proof-of-stake consensus mechanism on Ethereum blockchain network allows network participants to earn rewards without spending a lot of computational power for playing a part in securing the network. Unlike miners, validators don’t need to spend many CPU cycles to produce new blocks. They stake 32 ETH (the native cryptocurrency on Ethereum) to be […]

Migrate Oracle bulk binds to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL

To migrate an Oracle database to Amazon Aurora PostgreSQL-Compatible Edition, you usually need to perform both automated and manual tasks. The automated tasks include schema conversion and data migration, which can be handled with the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS), respectively. The manual tasks involve post-schema AWS […]

Understanding Amazon DynamoDB latency

Amazon DynamoDB uses horizontal scaling to support tables of virtually any size. In addition to horizontal scaling, DynamoDB provides single-digit millisecond performance for workloads of all sizes. Retail sites like Amazon.com use DynamoDB for their shopping carts and workflow engines. A slow response while processing an order can not only be frustrating to customers, but […]

How to use CloudWatch Logs Insights on Amazon RDS for Oracle log files for real-time analysis

Most database engines log error messages, warnings, traces, and audit statements. Database observability and monitoring are achieved by tracking this log information and taking proactive and reactive actions, such as allocating space when it is low, or stopping sessions causing exclusive locks or connection storms. In Amazon Relational Database Service (Amazon RDS) for Oracle, alert […]

Deploy an Ethereum development environment using Amazon EC2 and Amazon Managed Blockchain

In this post, you learn how to deploy a cloud-based development environment with which to build, test, and deploy smart contracts on the public Ethereum Goerli testnet via a dedicated Ethereum full node managed using Amazon Managed Blockchain. You can also use the steps outlined in this post to create a development environment on the […]

Introducing Optimized Reads for Amazon RDS for PostgreSQL

In March 2022, we introduced a new Multi-AZ deployment option for Amazon Relational Database Service (Amazon RDS) for PostgreSQL, called Multi-AZ DB clusters. This deployment option increases read capacity with two readable standby instances, and improves write transaction latency and failover times. The optimization of transaction latency uses local storage on purpose-built Amazon Elastic Compute […]