AWS Database Blog

Backup strategies for Amazon DynamoDB

One of the most important questions when discussing databases is “How will we backup and restore our data?” Backups are a central component of any disaster recovery strategy and are primarily governed by your Recovery Point Objective (RPO) and Recovery Time Objective (RTO). You want to make sure your backup strategy supports your needs with […]

How Broadridge used Amazon Managed Blockchain to build a private equity lifecycle management solution

Broadridge Financial Solutions (NYSE: BR), a global Fintech leader with more than $5 billion in revenues, provides the critical infrastructure that powers investing, corporate governance, and communications to enable better financial lives. We deliver technology-driven solutions that drive digital transformation for banks, broker-dealers, asset and wealth managers and public companies. Broadridge’s infrastructure serves as a […]

How Deliveroo migrated their Dispatcher service to Amazon DynamoDB

Deliveroo operates a hyperlocal, three-sided marketplace, connecting local consumers, restaurants and grocers, and riders to fulfil purchases in under 30 minutes. By offering fast and reliable delivery that consumers can track online, Deliveroo has grown rapidly. It operates in several markets worldwide, working with thousands of restaurants, grocers, and riders, and serving millions of consumers. […]

Automate the configuration of Amazon RDS Custom for SQL Server using AWS Systems Manager

In our previous post Use a self-hosted Active Directory with Amazon RDS Custom for SQL Server, we explained the manual steps to join Amazon Relational Database Service (Amazon RDS) Custom for SQL Server to a self-hosted Active Directory. We highlighted the importance of using repeatable, idempotent scripts because changes would be lost on new instances, […]

Migrate generated columns to PostgreSQL using AWS Database Migration Service

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. In this post, we share Amazon DMA’s approach to migrate generated columns to PostgreSQL implementations, such as Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible […]

Motivations for migration to Amazon DynamoDB

Amazon DynamoDB is a fully managed, serverless, key-value NoSQL database for single-digit millisecond performance at any scale. DynamoDB offers built-in security, continuous backups, automated multi-Region replication, 99.999% availability SLA, and data import and export tools. DynamoDB was built working backward from the needs of external customers and internally at Amazon.com to overcome the scale and […]

Understand Amazon Aurora high availability and disaster recovery from an Oracle perspective

In this post, we compare the high availability (HA) and disaster recovery (DR) features of Amazon Aurora to Oracle, with a focus of the Aurora disk subsystem and how this key innovation allows Amazon Aurora Global Database to deliver performance and availability. Data today is increasingly seen as a corporate asset, and safeguarding this asset is a key focus for many businesses. When that data exists in a database, the vendors of these systems produce methods […]

Handle IDENTITY columns in AWS DMS: Part 2

In Part 1 of this series, we discussed how the IDENTITY column is used in different relational database management systems. In this post, we focus on how AWS Database Migration Service (AWS DMS) handles tables with IDENTITY column. For the source database, AWS DMS captures the IDENTITY column as a regular column. For the target […]

Handle IDENTITY columns in AWS DMS: Part 1

In relational database management systems, an IDENTITY column is a column in a table that is made up of values generated automatically by the database at the time of data insertion. Although different systems handle the implementation of IDENTITY columns differently, they share some common characteristics. In most cases, the value of the IDENTITY column […]

a-tune accelerates their AWS migrations using migration strategy and implementation plans from Amazon Database Migration Accelerator

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. In this post, we share how the Amazon DMA team helped a-tune accelerate their migrations to AWS Databases and Analytics services. a-tune offers data and […]