AWS Database Blog

Category: Database

How to use IAM multifactor authentication with Amazon RDS

A common request that we get from customers is how to protect their resources from an accidental or malicious deletion, such as instances, snapshots, clusters, and so on. Doing this is especially important when you are using a common AWS account for multiple users or teams. Although you want the flexibility to innovate within the […]

Read More

How to encrypt database columns with no impact on your application using AWS DMS and Baffle

AWS offers a wealth of security features to protect its infrastructure and services, such as AWS Identity and Access Management (IAM) and AWS Key Management Service (AWS KMS). AWS Data Migration Service (AWS DMS) provides users a simple automated way of migrating data from their existing databases to Amazon RDS. As part of this, AWS […]

Read More

How to set up a single pgpool endpoint for reads and writes with Amazon Aurora PostgreSQL

Amazon Aurora provides endpoints for the primary DB instance (the cluster endpoint) and for Read Replicas (the reader endpoint). Aurora updates the cluster endpoint automatically so that it always points to the primary instance. The reader endpoint load balances read operations across all available Read Replicas. Amazon Aurora Replicas typically have less than 100 ms […]

Read More

Migrate to the MySQL-compatible edition of Amazon Aurora while protecting personal data using encryption

Security is a top priority at AWS, and the same is true for our customers. We spend a significant amount of resources protecting personal data and are constantly enhancing our capabilities to make data protection easier for our customers. All AWS services including the MySQL-compatible edition of Amazon Aurora comply with the European Union’s General […]

Read More

A serverless solution to monitor the storage of your Amazon DynamoDB tables

If you use Amazon DynamoDB as your application’s NoSQL database service, you might want to track how much storage your DynamoDB tables are using. DynamoDB publishes its service metrics to Amazon CloudWatch. CloudWatch helps you monitor and analyze those metrics, set alarms, and react automatically to changes in your AWS resources. Currently, DynamoDB sends many […]

Read More

Using AWS Cost Management products to help save costs on Amazon RDS Reserved Instances

Using Amazon RDS, you can quickly and easily set up, operate, and scale your relational databases in the cloud. Amazon RDS Reserved Instances (RIs) give you the option to reserve a database instance for a one- or three- year term. This option can translate into significant discounts (up to 69%) compared to On-Demand prices. In […]

Read More

How to perform advanced analytics and build visualizations of your Amazon DynamoDB data by using Amazon Athena

You can reap huge analytical value from billions of items and millions of requests per second in your Amazon DynamoDB service. However, you need to export your data in order to get that analytical value. Copying the data from a DynamoDB table to an analytics platform allows you to extract rich insights. In order to […]

Read More

How to migrate to Amazon RDS for SQL Server using transactional replication

You can migrate your databases into Amazon RDS for Microsoft SQL Server in multiple ways. Typically, you perform a simple backup and restore of the databases (along with scripting system objects such as logins). If you want a higher availability or lower downtime option, you might use the AWS Database Migration Service (AWS DMS). In […]

Read More

Get started with Amazon Elasticsearch Service: Use Amazon Cognito for Kibana access control

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future blog posts, we provide the basic information that you need to get started with Elasticsearch on AWS. Introduction On April 2, 2018, we released integration between Amazon Elasticsearch Service and Amazon Cognito. You can now provide and manage […]

Read More