AWS Database Blog
Category: Technical How-to
Implement active-active replication with RDS Custom for Oracle: Part 1 – High Availability
Amazon Relational Database Service (Amazon RDS) Custom is a managed database service for legacy, custom, and packaged applications that require access to the underlying OS and DB environment. With RDS Custom for Oracle, you can now access and customize your database server host and operating system, for example by applying special patches and changing the […]
Use guardrails to protect DynamoDB tables
Access control to AWS services and resources should be governed by the security principles of zero trust and least-privilege. Zero trust requires that users are strongly authenticated and fine-grained authorization is enforced before gaining access to resources. Least-privilege is a principle of granting only the permissions required to complete a task. Least-privilege is also an AWS Well-Architected best […]
VPC endpoint considerations for upgrading or creating AWS DMS version 3.4.7 or higher
AWS Database Migration Service (AWS DMS) version 3.4.7 and above includes support for Amazon Virtual Private Cloud (Amazon VPC) VPC endpoints and makes it easier to maintain end-to-end network configuration within the same AWS region for replication tasks. To learn more about VPC endpoints, refer to Connect your VPC to services using AWS PrivateLink. In […]
Migrate Oracle database to Amazon RDS for Oracle over a database link for space savings and reclamation
Amazon Relational Database Service (Amazon RDS) for Oracle is a fully managed commercial database that makes it easy to set up, operate, and scale an Oracle database in the cloud. One of its features is storage auto scaling, which allows the database storage to grow automatically, as needed, up to the maximum capacity (64 TiB) […]
Enforce configuration policies for your Amazon RDS databases using AWS Config
In today’s cloud-enabled enterprise, multiple teams take on the responsibility of creating and managing databases. The challenge that you may face is the enforcement of your company’s standard configuration policies—how do you make sure that all databases are following the database configuration standards consistently? This is where AWS Config can help. In this post, I […]
Implement serverless FIFO queues with filtering capabilities using Amazon DynamoDB transactions
Message queues allow different parts of a system to communicate and process operations asynchronously. Amazon Simple Queue Service (Amazon SQS) is a fully managed message queueing service that offers two types of message queues: standard queues and first-in-first-out (FIFO) queues. For some applications, such as a call center application, you need message filtering along with […]
Managed database backup and recovery in a multi-tenant SaaS application
Exporting data or restoring to an earlier point in time are core capabilities that customers look for in a software as a service (SaaS) product. Database backup and recovery is vital to business continuity and regulatory compliance. You should understand how your multi-tenant data partitioning model will affect the backup and restore capabilities of your […]
Load RDF data into Amazon Neptune with AWS Glue
In this post, we present a design for a common technical requirement: ingest data from multiple sources to a target Resource Description Framework (RDF) graph database. Our target is Amazon Neptune, a managed graph database service. RDF is one of two graph models supported by Neptune. The other is Labeled Property Graph (LPG). Each graph […]
Optimize the storage costs of your workloads with Amazon DynamoDB Standard-IA table class
You can use Amazon DynamoDB to build internet-scale applications that support user-content metadata and caches that require high concurrency and connections for millions of users and millions of requests per second using the default DynamoDB Standard table class. For example, Amazon.com uses DynamoDB to deliver consistently low latency for mission critical and extreme-scale events such […]
Federated query support between SQL Server and Amazon Aurora PostgreSQL
When you have a business need to integrate the data between Microsoft SQL Server and Amazon Aurora PostgreSQL-Compatible Edition, you can use the open-source TDS_FDW PostgreSQL extension to create federation between these two databases. With TDS_FDW with Aurora PostgreSQL-Compatible, you can modernize and extend the functionality of your existing applications to meet changing business needs. […]