AWS Database Blog

Category: Advanced (300)

Upgrade Amazon DocumentDB 3.6 to 5.0 with near-zero downtime

Amazon DocumentDB (with MongoDB compatibility) is a fully managed native JSON database designed for scaling enterprise workloads. You can use the same MongoDB API 3.6, 4.0, and 5.0 application code, drivers, and tools to run, manage, and scale workloads on Amazon DocumentDB without worrying about managing the underlying infrastructure. As a document database, Amazon DocumentDB makes it simple to store, query, and index JSON data. With Amazon DocumentDB version 5.0, you can now perform a major version upgrade of your Amazon DocumentDB clusters from version 3.6 and 4.0 to 5.0 in order to unlock latest features including support for vector search, I/O-optimized storage, document compression, text search, partial index and more. In this post, we explore how to perform an upgrade with near-zero downtime from Amazon DocumentDB 3.6 to 5.0 by using an in-place major version upgrade and Amazon DocumentDB volume cloning.

Automate SQL Server discovery and assessment to accelerate migration to AWS

Adopting lift and shift or rehost migration approach can be a viable option for time-sensitive scenarios, particularly when transitioning from an on-premises data center environment. However, it’s crucial to ensure that the chosen migration strategy aligns with your organization’s overall cloud adoption strategy to realize the long-term benefits of cloud-native architectures. For many applications, a […]

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 […]

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 […]

Demystifying AWS Backup for Amazon RDS for Oracle

Customers prefer to host their relational database workloads in a managed service such as Amazon Relational Database Service (Amazon RDS) because of the benefits offered by managed services. Although Amazon RDS offers automatic backups as a native feature, your data retention policies may require longer retention periods than the retention policy supported by Amazon RDS. […]

Simplify cross-account access control with Amazon DynamoDB using resource-based policies

Amazon DynamoDB is a serverless, NoSQL, fully-managed database service that delivers single-digit millisecond latency at any scale. Customers increasingly use workload isolation strategies to minimize security threats and to ease the complexity of compliance demands for their DynamoDB-backed workloads. Implementing workload isolation strategies often requires cross-account and cross-Region access to DynamoDB resources using IAM identity-based policies, which […]

Unlocking efficiency: Integrate AWS Lambda with Amazon RDS for Oracle to automate custom script operations

Amazon Relational Database Service (Amazon RDS) makes it straightforward to set up, operate, and scale a relational database in the AWS Cloud. When monitoring Amazon RDS, you can use Amazon CloudWatch metrics for basic monitoring, Amazon RDS Performance Insights for database and query performance analysis, and Enhanced Monitoring for OS-level metrics. These tools provide valuable […]

Bulk update Amazon DynamoDB tables with AWS Step Functions

Developers want to perform bulk updates to modify items in their Amazon DynamoDB tables. Reasons for performing bulk updates can include: Adding or updating attributes – backfilling a Time to Live (TTL) value or populating an attribute to support a new access pattern or global secondary index (GSI). For example, enriching existing data with new […]