AWS Database Blog

Category: Intermediate (200)

Writing results from an Athena query to Amazon DynamoDB

Many industries are taking advantage of the Internet of Things (IoT) to track information from and about connected devices. One example is the energy industry, which is using smart electricity meters to collect energy consumption from customers for analytics and control purposes. Vector, a New Zealand energy company, combines its energy knowledge with Amazon Web […]

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

Reduce network transfer time with connection compression in Amazon RDS for MySQL and Amazon RDS for MariaDB

Our customers have seen many cases where network bandwidth between the MySQL client and database becomes the source of bottleneck. This leads to increase in the query latencies causing performance impact. This is especially seen for workloads which have high network bandwidth requirement. MySQL and MariaDB solve this problem by allowing you to compress traffic […]

Column-level encryption on Amazon RDS for SQL Server

Amazon Relational Database Service (Amazon RDS) for SQL Server supports column-level data encryption. Column-level encryption provides encryption at a more granular level of data that can be applied on all or selected columns. With column-level encryption, you can define different encryption keys for each different column. You can use encryption in SQL Server for connections, […]

Troubleshoot network connectivity to Amazon RDS databases using VPC Reachability Analyzer

Amazon Virtual Private Cloud (Amazon VPC) enables you to provision a logically isolated section of theAWS Cloud where AWS resources such as Amazon Relational Database Service (Amazon RDS) DB instances can be launched in a virtual network you define. When creating an Amazon RDS DB instance, you have the option to create a new VPC […]

How Amazon Finance Technologies simplified global payments by creating a payments repository using Amazon DocumentDB

Amazon Finance Technologies (FinTech) Payments systems disburse Accounts Payable (AP) payments to Amazon’s suppliers and service providers. In 2021, FinTech AP systems disbursed millions of payments in over 150 countries and in more than 50 currencies through various payment options. In this post, we show you how we built an extensible payments metadata repository solution […]

Achieve transaction consistency on your target database when using multiple tasks with AWS DMS replication

AWS Database Migration Service (AWS DMS) is used for multiple reasons, including migrating from on premises to AWS, migrating from Amazon Elastic Compute Cloud (Amazon EC2) to Amazon Relational Database Service (Amazon RDS), continuous replication from Amazon RDS to Amazon RDS, and continuous replication from Amazon RDS to Amazon Simple Storage Service (Amazon S3). When […]

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