AWS Database Blog

Category: Database

Calculate Amazon DynamoDB reserved capacity recommendations to optimize costs

This post is co-written with Sanjna Srivatsa, Data Scientist at VMware. Amazon DynamoDB provides discounts ranging from 50 percent to 77 percent to customers who commit to paying for a minimum usage level, called reserved capacity. In this post, you learn how to use historical DynamoDB usage data to make your first DynamoDB reserved capacity […]

Deploy an Amazon RDS for PostgreSQL and MySQL Multi-AZ DB cluster using Terraform modules

Selecting the right cloud management tool is extremely important for many enterprises. In the post 5 Tips for Keeping Pace with AWS’s Innovation, we briefly discussed the high-level strategies to overcome the challenges of continuous improvement and drive innovations in your organization. In this post, we show how infrastructure as code (IaC) solutions built with […]

Read Scalability with Amazon Aurora Serverless v2

Amazon Aurora Serverless is an on-demand, auto scaling configuration for Aurora. It scales the capacity up or down based on your application’s needs. It enables you to run your database in the cloud without managing any database capacity. Aurora Serverless v2 supports Amazon Aurora Global Database , Multi AZ, AWS Identity and Access Management (IAM) […]

How Wiz used Amazon ElastiCache to improve performance and reduce costs

This is a guest post by Sagi Tsofan, Senior Software Engineer at Wiz in partnership with AWS. At Wiz, it’s all about scale. Our platform ingests metadata and telemetry for tens of billions of cloud resources every day. Our agentless scanner collects massive amounts of data that needs to be processed very efficiently. As our […]

Improve application availability on Amazon Aurora

An Online Transaction Processing (OLTP) database is a key building block of a highly available application. Business-critical workloads can leverage Amazon Aurora database clusters in Multi-AZ configuration to help improve their overall uptime, and reduce the impact of availability-related events such as Multi-AZ failovers. In this post, we discuss aspects of Amazon Aurora related to […]

Use point-in-time recovery to restore an Amazon DynamoDB table managed by AWS CDK

Point-in-time recovery (PITR) in Amazon DynamoDB is a fully managed capability that creates continuous backups of your DynamoDB table data. Continuous backups are important to ensure business continuity and compliance with regulations, and to protect against human errors, such as unintended writes or deletes. When PITR is enabled for a DynamoDB table, DynamoDB automatically backs […]

Choose shard keys to optimize Amazon DocumentDB Elastic Clusters

As applications grow, data grows as well, so it’s imperative for a modern cloud-based application to have a database that can automatically scale. Amazon DocumentDB (with MongoDB compatibility) is a fully managed, native JSON database built with a flexible schema for enterprise applications that decouples storage and compute, improving scalability and reducing time-consuming administrative tasks. […]

Monitor SQL Login creation on Amazon RDS for SQL server

Maintaining database security is indispensable for the success of any organization. Implementing database user authentication and authorization is an important step in securing a database system. Conventional database authentication is based on a username-password mechanism. This process requires constant time and effort from both DBAs and end users to manage the credentials. In contrast, incorporating […]

Data modelling for an internet-scale online transactional system using Amazon DynamoDB

Relational database management system (RDBMS) technology was the preferred choice for data storage for decades. In recent years, the rise of internet-scale applications and exponential data growth have challenged the way industries have designed their database strategies. Organizations are seeing clear benefits in scalability and performance by migrating mission-critical online transactional systems built on RDBMS […]

Configure Kerberos authentication for Amazon RDS for PostgreSQL without joining an Active Directory domain

Organizations that adopt centralized authentication mechanisms gain the following benefits: Enhanced security posture: Centralized authentication enables quick addition or removal of user access throughout the network, giving organizations improved security and the ability to respond quickly to security threats. Scalability: By controlling access through a centralized database, organizations can scale their network and minimize performance […]