AWS Database Blog

Category: Advanced (300)

Configure Multi-AZ with Amazon RDS Custom for SQL Server

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server now supports high availability by using block-level replication in a Multi-AZ environment. Previously, to enable high availability on the instance, you had to configure an Always On Availability Group (AG) between two instances. Setting up and configuring Always On requires planning and expertise. With the […]

How to use Amazon CloudWatch to monitor Amazon DynamoDB table size and item count metrics

Amazon DynamoDB sends metrics about its operations to Amazon CloudWatch. At the time of this writing, the list includes 33 metrics including: throughput consumed and provisioned, account and table limits, request latencies, system errors, and user errors. Two metrics not included are the DynamoDB table size and item count. These values can be observed in […]

Integrate Amazon RDS for Oracle with Amazon EFS – Part 2 – Strengthen Access using EFS file system policy and Enforce in-transit encryption

With the announcement that Amazon Relational Database Service (Amazon RDS) for Oracle now supports integration with Amazon Elastic File System (Amazon EFS), you can keep temporary files like Oracle Data Pump export, import files on Amazon EFS file system, and directly access from it. Furthermore, you can leverage Amazon EFS integration for sharing a file system between […]

Amazon Aurora PostgreSQL database authorization using role-based access control

Many customers are using Amazon Aurora PostgreSQL-Compatible Edition for running their business-critical database workloads in AWS. Aurora PostgreSQL is a fully managed, PostgreSQL-compatible, and ACID-compliant relational database engine that combines the speed, reliability, and manageability of Amazon Aurora with the simplicity and cost-effectiveness of open-source databases. In this post, we present a database authorization solution […]

Migrate Oracle Databases to AWS using transportable tablespace

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Friend microservices using Amazon DynamoDB and event filtering

The gaming industry has evolved significantly over the past few years. A feature that has become essential to that evolution is to be friends with other players and play together in the same game. From the players’ point of view, the process to become friends is straightforward. A player sends a friend request to another, […]

Improve query performance using Optimized Reads on Amazon RDS for MySQL and Amazon RDS for MariaDB

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale MySQL and MariaDB deployments in the cloud. Developers are often required to run complex queries in MySQL and MariaDB environments to create a dashboard or run simple ad hoc reports. Furthermore, application developers use complex stored procedures with user-created temporary […]

Use Region pinning to set a home Region for items in an Amazon DynamoDB global table

Amazon DynamoDB global tables provide a fully managed, scalable solution for deploying a multi-Region, multi-active database that’s replicated across multiple AWS Regions. Global tables allow applications to read and write data to a table, with the data automatically replicated across all Regions that are associated with that table. Global tables are ideal for applications that […]

Migrate an internet-scale online transactional system to Amazon DynamoDB using AWS DMS

Database migration is a complex process that usually involves capacity planning, data migration and cutover strategies, hardware and software procurement, and a lengthy debugging and testing schedule. The common challenge in migrating from a relational database to a non-relational database is selecting the appropriate modeling technique and migration technologies. This is the second part of […]

How Skai performed database modernization and migration with AWS DMS

This is a guest post by Niv Gelbermann Shkolnik , Software Engineer at Skai co-authored with Eran Balan, Senior Solutions Architect at AWS. Skai is the leading omnichannel platform that helps performance marketers plan, activate, and measure programs across digital media for informed decisions, high efficiency and optimal return. In this post, we discuss how […]