AWS Database Blog

Category: Advanced (300)

Introducing Amazon RDS for MariaDB 10.11 for up to 40% higher transaction throughput

MariaDB is a popular open-source high performance database. Amazon Relational Database Service (Amazon RDS) for MariaDB supports multiple major engine versions including 10.4, 10.5, 10.6. Today, Amazon RDS has announced support for MariaDB major version 10.11, which is the latest long-term supported major version from the MariaDB community. When compared to previous versions, Amazon RDS for MariaDB […]

Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime

When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having to worry about paying for idle compute, and without having a poor user experience due to periods of high load with insufficient capacity, was game-changing, and many AWS […]

IPFS on AWS, Part 2: Deploy a production IPFS cluster on Amazon EKS

This series of posts provides a comprehensive introduction to running IPFS (InterPlanetary File System) on AWS: In Part 1, we introduce the IPFS concepts and test IPFS features on an Amazon Elastic Compute Cloud (Amazon EC2) instance In Part 2, we propose a reference architecture and build an IPFS cluster on Amazon Elastic Kubernetes Service […]

Deploy multi-Region Amazon RDS for SQL Server using cross-Region read replicas with a disaster recovery blueprint – Part 2

In our previous post, we deployed multi-Region disaster recovery blueprint using Amazon Route 53, Amazon Relational Database Service (Amazon RDS) for SQL Server and Amazon Simple Storage Service (Amazon S3). In this post we walk you through the process of promoting RDS for SQL Server in the AWS secondary Region and performing a cross-Region failover […]

Deploy multi-Region Amazon RDS for SQL Server using cross-Region read replicas with a disaster recovery blueprint – Part 1

Disaster recovery and high availability planning play a critical role in ensuring the resilience and continuity of business operations. When considering disaster recovery strategies on AWS, there are two primary options: in-Region disaster recovery and cross-Region disaster recovery. The choice between in-Region and cross-Region disaster recovery depends on various factors, including the criticality of the […]

Data consolidation for analytical applications using logical replication for Amazon RDS Multi-AZ clusters

Amazon Relational Database Service (Amazon RDS) Multi-AZ deployments provide enhanced availability and durability for your RDS database instances. You can deploy highly available, durable PostgreSQL databases in three Availability Zones using Amazon RDS Multi-AZ DB cluster deployments with two readable standby DB instances. With a Multi-AZ DB cluster, applications gain automatic failovers in typically under […]

Manage case-insensitive data in PostgreSQL

It’s important to be aware of the case sensitivity of text data in PostgreSQL when performing queries or comparisons to ensure that the results match your intended expectations. Case also affects how the database performs sorting operations. By default, PostgreSQL is case sensitive when sorting or comparing string values. For example, PostgreSQL considers “amazon” and […]

Amazon Aurora PostgreSQL: cross-account synchronization using logical replication

In this post, we show you how to set up cross-account logical replication using Amazon Aurora PostgreSQL-Compatible Edition. By leveraging Aurora’s cross-account clone and PostgreSQL logical replication, you can achieve near real-time synchronization between a source and a target database in different AWS accounts. You can customize the solution to meet specific requirements, including selective […]

Remove temporal tables and history objects while migrating to Amazon DynamoDB using Amazon DynamoDB Streams

Customers at times use proprietary database features like Microsoft SQL Server temporal tables or Oracle Flashback to store and query historical data from important tables or to record a change trail of contents. Temporal tables are a database feature that brings built-in support for providing information about data stored in the table at any point […]

Best strategies for achieving high performance and high availability on Amazon RDS for MySQL with Multi-AZ DB Clusters

In Amazon Relational Database Service (Amazon RDS), Multi-AZ deployments can have one or two standby DB instances. A Multi-AZ DB instance deployment has a single standby DB instance that provides failover support, but doesn’t serve read traffic. When the deployment has two readable standby DB instances, it’s called a Multi-AZ DB cluster deployment. A Multi-AZ […]