AWS Database Blog

Category: Learning Levels

Fast switchovers with PgBouncer on Amazon RDS Multi-AZ deployments with two readable standbys for PostgreSQL

Amazon RDS Multi-AZ deployments with two readable standbys (Amazon RDS Multi-AZ DB cluster) for PostgreSQL now supports typically 35 seconds or less of write downtime for minor version upgrades and system maintenance updates. By using patches for PgBouncer from AWS, you can further reduce this write downtime to typically one second or less. This greatly […]

Achieve one second or less downtime with the Advanced JDBC Wrapper Driver when upgrading Amazon RDS Multi-AZ DB Clusters

When upgrading minor versions of RDS Multi-AZ clusters the connections are switched from the current writer to a newly upgraded reader. Clients have the option to connect to either the cluster writer endpoint or the cluster reader endpoint. Normally, they would connect to the writer endpoint. This endpoint is directed to the current writer instance. […]

Perform minor version upgrades with a downtime of 1 second or less with Amazon RDS Proxy and Amazon RDS Multi-AZ deployments with two readable standbys

Amazon RDS Multi-AZ deployments with two readable standbys now supports minor version upgrades and system maintenance updates with typically 1 second or less of downtime when used with Amazon RDS Proxy. In this post, we discuss this new feature, its benefits, and the steps to set it up. Amazon RDS Multi-AZ deployments with two readable […]

Amazon RDS for SQL Server now supports SQL Server 2022

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports Microsoft SQL Server 2022 for Express, Web, Standard, and Enterprise Editions. You can use SQL Server 2022 features such as accelerated database recovery, intelligent query processing, intelligent performance, monitoring improvements, and resumable online index creations. In this post, we summarize the new features on […]

Announcing frozen collections for Amazon Keyspaces

Amazon Keyspaces (for Apache Cassandra) is a scalable, highly available, and managed Apache Cassandra-compatible database service. With Amazon Keyspaces, you can run your Cassandra workloads on AWS using the same Cassandra application code and developer tools that you’re currently using.

Today, we are introducing support for frozen collections in Amazon Keyspaces. With this launch, you can use the frozen keyword and store collection data types (like lists, sets, and maps) as a single, immutable value. In this post, we discuss the benefits and use cases of this new feature, and demonstrate how to create and use frozen collections in Amazon Keyspaces.

Achieve over 500 million requests per second per cluster with Amazon ElastiCache for Redis 7.1

Amazon ElastiCache for Redis is a fully managed service compatible with the Redis API. ElastiCache is a fast in-memory data store, and many customers choose it to power some of their most performance-sensitive, real-time applications. Today, we are excited to share that you can now effectively maximize your performance by upgrading from ElastiCache for Redis […]

Plan an Oracle migration to Amazon RDS for Oracle using Oracle Data Pump and AWS DMS

Migrating self-managed Oracle databases running on-premises or on Amazon Elastic Compute Cloud (Amazon EC2) to Amazon Relational Database Service (Amazon RDS) for Oracle is a common migration path for customers looking to adopt a managed database solution from AWS. This managed service appeals to customers who are looking to reduce the cost and overhead of […]

Schedule scaling for Amazon Aurora replicas using AWS Application Auto Scaling

In this post, we demonstrate how to modify the Amazon Aurora reader auto scaling configuration on a schedule using AWS Application Auto Scaling, on top of the existing auto scaling policies. When your application grows, the load on your database will most likely grow as your application saves larger amounts of data. Whether it’s the […]

Secure your data at rest on Amazon RDS Custom for SQL Server using transparent data encryption (TDE) or column-level encryption (CLE)

Customers in industries such as healthcare and financial services take full advantage of the built-in security features of SQL Server to meet their regulatory and compliance requirements. When migrating their database to the AWS Cloud, we often see customers asking for SQL Server security feature support such as TDE, column-level encryption on Amazon Relational Database […]

Configure Linked Servers on Amazon RDS Custom for SQL Server

Amazon Relational Database Service (Amazon RDS) Custom is a managed database service that automates the setup, operation, and scaling of databases in the cloud while granting you access to the underlying operating system and database environment. You can provision a Multi-AZ Amazon RDS Custom for SQL Server instance for a highly available environment with automatic […]