# Amazon RDS

Amazon Relational Database Service (Amazon RDS) is a managed relational database service that automates tasks such as provisioning, configuring, backing up, and patching.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Fix circular role dependencies before upgrading Amazon RDS and Amazon Aurora PostgreSQL

DevFeed: [Fix circular role dependencies before upgrading Amazon RDS and Amazon Aurora PostgreSQL](<https://devfeed.tech/articles/fix-circular-role-dependencies-before-upgrading-amazon-rds-and-amazon-aurora-postgresql-4708.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/resolve-circular-role-dependencies-during-upgrades-of-amazon-rds-for-postgresql-and-amazon-aurora/>)

Author: Ravi Teja Adabala

Published: 2026-08-31T23:42:55Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>), [Graphs](<https://devfeed.tech/topics/graphs.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [database](<https://devfeed.tech/tags/database.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This article explains how circular PostgreSQL role dependencies can cause major version upgrades of Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL to stall or roll back when upgrading from PostgreSQL 14 or earlier to PostgreSQL 15 or later. It describes a diagnostic query and steps to resolve the dependencies before the upgrade.

### Source excerpt

Circular role dependencies can stall or roll back a major version upgrade of Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL when you move from PostgreSQL 14 or earlier to 15 or later. Learn why this happens, how to detect it with a single pre-upgrade query, and how to clear it before you upgrade.

## Cross-database access using module signing on Amazon RDS for SQL Server

DevFeed: [Cross-database access using module signing on Amazon RDS for SQL Server](<https://devfeed.tech/articles/cross-database-access-using-module-signing-on-amazon-rds-for-sql-server-4698.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/cross-database-access-using-module-signing-on-amazon-rds-for-sql-server/>)

Author: Nirupam Datta

Published: 2026-08-24T18:07:08Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [RDS for SQL Server](<https://devfeed.tech/topics/rds-for-sql-server.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Security](<https://devfeed.tech/topics/security.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [migration](<https://devfeed.tech/topics/migration.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [migration](<https://devfeed.tech/tags/migration.md>), [post](<https://devfeed.tech/tags/post.md>), [rds-for-sql-server](<https://devfeed.tech/tags/rds-for-sql-server.md>), [security](<https://devfeed.tech/tags/security.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This post explains how to enable secure cross-database access on fully managed Amazon RDS for SQL Server using certificate-based module signing. It presents module signing as an RDS-compatible alternative to TRUSTWORTHY, with permissions limited to specific stored procedures and aligned with least privilege.

### Source excerpt

If you need cross-database access on Amazon RDS for SQL Server but cannot enable TRUSTWORTHY, module signing with certificates is the secure, RDS-compatible alternative. This post shows how to grant cross-database permissions to specific stored procedures without TRUSTWORTHY and with a stronger, least-privilege security posture.

## Migrate multilingual full-text search from SQL Server to PostgreSQL

DevFeed: [Migrate multilingual full-text search from SQL Server to PostgreSQL](<https://devfeed.tech/articles/migrate-multilingual-full-text-search-from-sql-server-to-postgresql-4704.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/migrate-multilingual-full-text-search-from-sql-server-to-postgresql/>)

Author: Ken Zhang

Published: 2026-08-20T20:34:44Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [tokenization](<https://devfeed.tech/topics/tokenization.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [blog](<https://devfeed.tech/tags/blog.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [tokenization](<https://devfeed.tech/tags/tokenization.md>)

### AI overview

This tutorial explains how to migrate multilingual full-text search from SQL Server to PostgreSQL while preserving comparable behavior. It covers collations, text search configurations, language-specific tokenization, accent-insensitive search, synonym expansion, and validation testing on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL.

### Source excerpt

Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to reproduce SQL Server full-text search on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL, covering collation, tokenization, accent-insensitive search, and synonyms.

## Breaking the Loop: How we migrated our backup catalog for 250+ MySQL clusters to AWS

DevFeed: [Breaking the Loop: How we migrated our backup catalog for 250+ MySQL clusters to AWS](<https://devfeed.tech/articles/breaking-the-loop-how-we-migrated-our-backup-catalog-for-250-mysql-clusters-to-aws-23721.md>)

Original publisher: [Read original article](<https://medium.com/booking-com-development/breaking-the-loop-how-we-migrated-our-backup-catalog-for-250-mysql-clusters-to-aws-6f5a53a519b9?source=rss----1c36c35f9c76---4>)

Author: Ioannis Androulidakis

Published: 2026-02-19T14:19:52Z

Content type: article

Language: en

Sources: [Booking.com Development - Medium](<https://devfeed.tech/sources/booking-com-development-medium.md>)

Topics: [migration](<https://devfeed.tech/topics/migration.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [on-prem](<https://devfeed.tech/topics/on-prem.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [backup](<https://devfeed.tech/tags/backup.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-migration](<https://devfeed.tech/tags/cloud-migration.md>), [data-backup](<https://devfeed.tech/tags/data-backup.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [on-prem](<https://devfeed.tech/tags/on-prem.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [reliability-engineering](<https://devfeed.tech/tags/reliability-engineering.md>)

### AI overview

Booking.com's Database Engineering team describes migrating the backup catalog orchestrator's backend for more than 250 production MySQL clusters from a self-managed on-premises MySQL database to managed Amazon RDS for MySQL in AWS. The article discusses the migration's challenges, implemented solutions, and lessons learned.

### Source excerpt

This post was originally published internally on May 9, 2025 and has been reworked for a public audience. Authors: Ioannis Androulidakis, Mohammed Gaafar Intro The Database Engineering team at Booking.com is constantly looking for ways to improve database reliability and support scaling our business. In 2025 we completed a major milestone in our effort to modernize our infrastructure: we seamlessly migrated the backend of the orchestrator that schedules and manages the daily backups of 250+ production MySQL clusters. More specifically, we moved from a self-managed MySQL database running on premises to a managed Amazon RDS MySQL database running in the cloud. This blog post delves into the challenges we faced, the solutions we implemented, and some key lessons we learned along the way. We are moving to the cloud (gradually) Cloud adoption is a journey, not a switch. Over the past few years the adoption of AWS solutions at Booking.com has been growing rapidly across different business units, allowing teams to be more autonomous, run their databases in the cloud and solve known issues with their old on-premise setup. Like customer teams, we are running our own databases to power the core services that we offer and manage databases efficiently at scale. To name a few: automatic failover of writable primaries, auto-scaling of read-only replicas, service discovery, capacity planning, online schema changes, user access management, volume backups, etc. Traditionally, the Database Engineering team has been running databases on-premises. In the emerging era of cloud databases, we wanted to compare our in-house offerings with existing cloud databases and bridge the gap between the two. Knowing that we lacked deep, hands-on experience with the operational realities of running critical infrastructure on AWS, we saw this as a unique opportunity to learn more about cloud databases while also improving the reliability of our systems. Long story short, we decided to prioritize the m

## Inside Laravel Nightwatch's Observability Pipeline: Real-Time Event Processing with Amazon MSK and ClickHouse Cloud

DevFeed: [Inside Laravel Nightwatch's Observability Pipeline: Real-Time Event Processing with Amazon MSK and ClickHouse Cloud](<https://devfeed.tech/articles/inside-laravel-nightwatch-s-observability-pipeline-real-time-event-processing-with-amazon-msk-and-clickhouse-cloud-5377.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/laravel-nighwatch-clickhouse>)

Author: AWS; Laravel; ClickHouse

Published: 2025-10-08T15:36:20Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Laravel](<https://devfeed.tech/topics/laravel.md>), [observability](<https://devfeed.tech/topics/observability.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Kafka](<https://devfeed.tech/topics/kafka.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>), [AWS Lambda](<https://devfeed.tech/topics/aws-lambda.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon API Gateway](<https://devfeed.tech/topics/amazon-api-gateway.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Grafana Cloud Metrics](<https://devfeed.tech/topics/grafana-cloud-metrics.md>)

Tags: [amazon-api-gateway](<https://devfeed.tech/tags/amazon-api-gateway.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [apache-kafka](<https://devfeed.tech/tags/apache-kafka.md>), [api](<https://devfeed.tech/tags/api.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [json](<https://devfeed.tech/tags/json.md>), [laravel](<https://devfeed.tech/tags/laravel.md>), [low-latency](<https://devfeed.tech/tags/low-latency.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [observability](<https://devfeed.tech/tags/observability.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [traces](<https://devfeed.tech/tags/traces.md>)

### AI overview

This article explains how Laravel Nightwatch processes more than one billion observability events per day using AWS managed services and ClickHouse Cloud. Its streaming-first architecture combines Amazon MSK, AWS Lambda, Amazon API Gateway, Amazon RDS for PostgreSQL, and ClickHouse Cloud to provide scalable ingestion, real-time dashboards, and sub-second analytical queries.

### Source excerpt

Learn how Laravel Nightwatch platform process billions of observability events in real time while keeping query latency under a second.

## How We Migrated Millions of UGC Records to Aurora MySQL

DevFeed: [How We Migrated Millions of UGC Records to Aurora MySQL](<https://devfeed.tech/articles/how-we-migrated-millions-of-ugc-records-to-aurora-mysql-38727.md>)

Original publisher: [Read original article](<https://blog.developer.bazaarvoice.com/2025/08/25/how-we-migrated-millions-of-ugc-records-to-aurora-mysql/>)

Author: Kovi

Published: 2025-08-25T10:42:12Z

Content type: article

Language: en

Sources: [Bazaarvoice](<https://devfeed.tech/sources/bazaarvoice.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [reliability](<https://devfeed.tech/topics/reliability.md>), [resiliency](<https://devfeed.tech/topics/resiliency.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cost](<https://devfeed.tech/tags/cost.md>), [database](<https://devfeed.tech/tags/database.md>), [devops](<https://devfeed.tech/tags/devops.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [performance](<https://devfeed.tech/tags/performance.md>), [reliability](<https://devfeed.tech/tags/reliability.md>)

### AI overview

Bazaarvoice describes migrating millions of user-generated content records from Amazon RDS for MySQL to Amazon Aurora MySQL. The article explains the operational limits, performance and scaling challenges, and a two-phase modernization that first standardized on MySQL 8.0 before the Aurora migration.

### Source excerpt

Discover how Bazaarvoice migrated millions of UGC records from RDS MySQL to AWS Aurora - at scale and with minimal user impact. Learn about the technical challenges, strategies, and outcomes that enabled this ambitious transformation in reliability, performance, and cost efficiency Bazaarvoice ingests and serves millions of user-generated content (UGC) items--reviews, ratings, questions, answers, and [...]

## Why traconiq Migrated Their Multi-TB Telemetry Dataset to Neon

DevFeed: [Why traconiq Migrated Their Multi-TB Telemetry Dataset to Neon](<https://devfeed.tech/articles/why-traconiq-migrated-their-multi-tb-telemetry-dataset-to-neon-5862.md>)

Original publisher: [Read original article](<https://neon.com/blog/why-traconiq-migrated-from-aws-rds-to-neon>)

Author: Carlota Soto

Published: 2025-07-01T16:21:46Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [dataset](<https://devfeed.tech/topics/dataset.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [autoscaling](<https://devfeed.tech/topics/autoscaling.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [backup](<https://devfeed.tech/tags/backup.md>), [case-studies](<https://devfeed.tech/tags/case-studies.md>), [cost](<https://devfeed.tech/tags/cost.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [s3](<https://devfeed.tech/tags/s3.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [snapshots](<https://devfeed.tech/tags/snapshots.md>), [storage](<https://devfeed.tech/tags/storage.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>)

### AI overview

This article explains why traconiq migrated its multi-terabyte telemetry dataset from Amazon RDS to Neon. It describes rising costs from multiple regions and environments, fixed peak-capacity provisioning despite cyclical load, storage volumes that could not shrink after data was moved to Amazon S3, and the limitations and expense of snapshots for backups. Neon is presented as enabling more efficient scaling through branching and autoscaling.

### Source excerpt

"Our workload ingests hundreds of data points per second and our RDS costs were increasing, especially since we had multiple regions and environments. With Neon, we found a way to scale our setup more efficiently, using branching instead of duplicating instances and autoscaling t...

## Partitioning a large table in PostgreSQL with Rails

DevFeed: [Partitioning a large table in PostgreSQL with Rails](<https://devfeed.tech/articles/partitioning-a-large-table-in-postgresql-with-rails-33527.md>)

Original publisher: [Read original article](<https://www.aha.io/engineering/articles/partitioning-a-large-table-in-postgresql-with-rails>)

Published: 2025-04-28T00:00:00Z

Content type: tutorial

Language: en

Sources: [Aha! Engineering Blog](<https://devfeed.tech/sources/aha-engineering-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Rails](<https://devfeed.tech/topics/rails.md>), [Database](<https://devfeed.tech/topics/database.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [etl](<https://devfeed.tech/topics/etl.md>), [Disaster Recovery](<https://devfeed.tech/topics/disaster-recovery.md>), [datadog](<https://devfeed.tech/topics/datadog.md>)

Tags: [active-record](<https://devfeed.tech/tags/active-record.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [backups](<https://devfeed.tech/tags/backups.md>), [datadog](<https://devfeed.tech/tags/datadog.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [etl](<https://devfeed.tech/tags/etl.md>), [latency](<https://devfeed.tech/tags/latency.md>), [migration](<https://devfeed.tech/tags/migration.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rails](<https://devfeed.tech/tags/rails.md>)

### AI overview

This article explains how Aha! partitioned a very large PostgreSQL audit table used with Rails. It covers the migration strategy, operational and performance problems caused by billions of rows, and an archival process that moves audits older than 12 months to Amazon S3.

### Source excerpt

Keeping a reliable history of changes is essential for our users. They need to know when a record was updated, who made the change, and why. They could be anxiously awaiting a notification about a dependency that is blocking their work. Maybe they w

## Failover in Amazon RDS Multi-AZ Architectures

DevFeed: [Failover in Amazon RDS Multi-AZ Architectures](<https://devfeed.tech/articles/failover-in-amazon-rds-multi-az-architectures-18013.md>)

Original publisher: [Read original article](<https://blog.guilleojeda.com/failover-in-amazon-rds-multi-az-architectures>)

Author: Guillermo Ojeda

Published: 2024-12-18T23:22:08Z

Content type: tutorial

Language: en

Sources: [Guille Ojeda](<https://devfeed.tech/sources/guille-ojeda.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Cloud Architecture](<https://devfeed.tech/topics/cloud-architecture.md>), [distributed-systems](<https://devfeed.tech/topics/distributed-systems.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Database](<https://devfeed.tech/topics/database.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [VPC](<https://devfeed.tech/topics/vpc.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [amazon-web-services](<https://devfeed.tech/tags/amazon-web-services.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [databases](<https://devfeed.tech/tags/databases.md>), [distributed-systems](<https://devfeed.tech/tags/distributed-systems.md>), [ec2](<https://devfeed.tech/tags/ec2.md>), [failover](<https://devfeed.tech/tags/failover.md>), [replication](<https://devfeed.tech/tags/replication.md>), [vpc](<https://devfeed.tech/tags/vpc.md>)

### AI overview

This tutorial explains how Amazon RDS Multi-AZ deployments handle database failures and failover. It examines RDS architecture, including EC2 compute, EBS storage, VPC connectivity, the control plane, storage-level replication, and Availability Zone isolation.

### Source excerpt

Database failures are inevitable. Even with the most reliable hardware and software, something will eventually break. AWS RDS Multi-AZ deployments promise to handle these failures gracefully, automatically failing over to a standby database when prob...

## Shell Spell: Extracting and Propagating Multiple Values With jq

DevFeed: [Shell Spell: Extracting and Propagating Multiple Values With jq](<https://devfeed.tech/articles/shell-spell-extracting-and-propagating-multiple-values-with-jq-18815.md>)

Original publisher: [Read original article](<https://www.morling.dev/blog/extracting-and-propagating-multiple-values-with-jq/>)

Published: 2024-07-06T09:20:00Z

Content type: tutorial

Language: en

Sources: [Gunnar Morling](<https://devfeed.tech/sources/gunnar-morling.md>)

Topics: [Terraform](<https://devfeed.tech/topics/terraform.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [Bash](<https://devfeed.tech/topics/bash.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [cli](<https://devfeed.tech/tags/cli.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [commands](<https://devfeed.tech/tags/commands.md>), [json](<https://devfeed.tech/tags/json.md>), [password](<https://devfeed.tech/tags/password.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

A hands-on tutorial showing how to use shell pipelines and jq with Terraform state to retrieve a dynamically generated database password and host from an Amazon RDS-backed Postgres setup, then pass both values to psql.

### Source excerpt

In my day job at Decodable, I am currently working with Terraform to provision some cloud infrastructure for an upcoming hands-on lab. Part of this set-up is a Postgres database on Amazon RDS, which I am creating using the Terraform AWS modules. Now, once my database was up and running, I wanted to extract two dynamically generated values from Terraform: the random password created for the root user, and the database host URL. On my way down the rabbit hole for finding a CLI command for doing this efficiently, I learned a few interesting shell details which I'd like to share.

## How to reduce Postgres compute costs as you scale

DevFeed: [How to reduce Postgres compute costs as you scale](<https://devfeed.tech/articles/how-to-reduce-postgres-compute-costs-as-you-scale-5399.md>)

Original publisher: [Read original article](<https://neon.com/blog/how-to-reduce-postgres-compute-costs-as-you-scale>)

Author: Carlota Soto

Published: 2024-04-29T15:31:21Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [autoscaling](<https://devfeed.tech/topics/autoscaling.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [article](<https://devfeed.tech/tags/article.md>), [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [availability](<https://devfeed.tech/tags/availability.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cost](<https://devfeed.tech/tags/cost.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [infra](<https://devfeed.tech/tags/infra.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [pricing](<https://devfeed.tech/tags/pricing.md>)

### AI overview

The article explains how to reduce Postgres compute costs as database demand grows. It focuses primarily on Amazon RDS, describing how instance size, on-demand versus reserved pricing, and single-AZ versus multi-AZ deployments affect compute bills. It also presents Neon's scale-to-zero and autoscaling capabilities as ways to pay for the compute resources actually used.

### Source excerpt

Reducing cloud costs is on everyone's mind. While storage prices continue to drop, fewer innovations have been made to reduce compute costs, even though compute typically consumes a larger chunk of the bill. That's why we've built Neon with scale to zero and autoscaling, so that...

## Rising costs of running legacy Amazon RDS systems

DevFeed: [Rising costs of running legacy Amazon RDS systems](<https://devfeed.tech/articles/rising-costs-of-running-legacy-amazon-rds-systems-27711.md>)

Original publisher: [Read original article](<https://gagor.pro/2024/04/rising-costs-of-running-legacy-amazon-rds-systems/>)

Author: Tom

Published: 2024-04-27T00:00:00Z

Content type: opinion

Language: en

Sources: [Tomasz Gągor](<https://devfeed.tech/sources/tomasz-gagor.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [legacy](<https://devfeed.tech/topics/legacy.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-rds-extended-support](<https://devfeed.tech/tags/aws-rds-extended-support.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-database-costs](<https://devfeed.tech/tags/cloud-database-costs.md>), [legacy](<https://devfeed.tech/tags/legacy.md>), [legacy-rds-costs](<https://devfeed.tech/tags/legacy-rds-costs.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [mysql-5-7-support](<https://devfeed.tech/tags/mysql-5-7-support.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-10-support](<https://devfeed.tech/tags/postgresql-10-support.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>)

### AI overview

The article examines the rising cost of maintaining legacy Amazon RDS instances running MySQL 5.7 and PostgreSQL 10 or earlier. It explains how RDS Extended Support lets customers continue using outdated versions with critical updates, while adding region- and resource-dependent charges and allowing up to three years to upgrade.

### Source excerpt

Understand the rising costs of maintaining legacy Amazon RDS systems and explore the new RDS Extended Support option for MySQL and PostgreSQL.

## How OpusFlow achieves tenant isolation in Postgres without managing servers

DevFeed: [How OpusFlow achieves tenant isolation in Postgres without managing servers](<https://devfeed.tech/articles/how-opusflow-achieves-tenant-isolation-in-postgres-without-managing-servers-5355.md>)

Original publisher: [Read original article](<https://neon.com/blog/how-opusflow-achieves-tenant-isolation-in-postgres-without-managing-servers>)

Author: Carlota Soto

Published: 2024-02-22T17:28:50Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Per-user Database](<https://devfeed.tech/topics/per-user-database.md>), [tenant data protection](<https://devfeed.tech/topics/tenant-data-protection.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Multitenancy](<https://devfeed.tech/topics/multitenancy.md>), [Encryption](<https://devfeed.tech/topics/encryption.md>), [DevOps](<https://devfeed.tech/topics/devops.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [business](<https://devfeed.tech/tags/business.md>), [case-studies](<https://devfeed.tech/tags/case-studies.md>), [customers](<https://devfeed.tech/tags/customers.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [devops](<https://devfeed.tech/tags/devops.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [energy](<https://devfeed.tech/tags/energy.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

The article describes how OpusFlow, an ERP tool for sustainable energy installers, addresses sensitive European customer data through a one-database-per-customer architecture in Postgres. It explains that this design improves tenant isolation, supports separate encryption keys, independent scaling, customer-specific restores, and separate upgrade schedules. The article contrasts this approach with Amazon RDS deployments, which either allow resource contention in a shared instance or create substantial operational and cost overhead when each database uses a separate instance.

### Source excerpt

"Our customers require their data to live in an isolated database, but implementing this in RDS was cumbersome and expensive. We switched over to Neon to reduce costs and operational overhead" Joey Teunissen, CTO at OpusFlow The demand for solar panels and sustainable energy inst...

## Why Topo.io Switched From Amazon RDS to Neon

DevFeed: [Why Topo.io Switched From Amazon RDS to Neon](<https://devfeed.tech/articles/why-topo-io-switched-from-amazon-rds-to-neon-5861.md>)

Original publisher: [Read original article](<https://neon.com/blog/why-topo-io-switched-from-amazon-rds-to-neon>)

Author: Carlota Soto

Published: 2024-02-01T17:57:54Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Development](<https://devfeed.tech/topics/development.md>), [debugging](<https://devfeed.tech/topics/debugging.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [case-studies](<https://devfeed.tech/tags/case-studies.md>), [database](<https://devfeed.tech/tags/database.md>), [debugging](<https://devfeed.tech/tags/debugging.md>), [development](<https://devfeed.tech/tags/development.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [postgres](<https://devfeed.tech/tags/postgres.md>)

### AI overview

Topo.io switched from Amazon RDS to Neon after encountering difficulties maintaining consistent environments across developers and production and reproducing production issues in development. The article highlights Neon branching as a way to support fast iteration and engineering velocity while building an AI-powered sales assistant.

### Source excerpt

The killer feature that convinced us to use Neon was branching: it keeps our engineering velocity high. Léonard Henriquez, co-founder and CTO, Topo.io The team at Topo.io is building the next generation of AI-powered sales assistant, so you can let the virtual SDR find you the ri...

## The growing pains of database architecture

DevFeed: [The growing pains of database architecture](<https://devfeed.tech/articles/the-growing-pains-of-database-architecture-9764.md>)

Original publisher: [Read original article](<https://www.figma.com/blog/how-figma-scaled-to-multiple-databases/>)

Author: Tim Liang

Published: 2023-04-04T00:00:00Z

Content type: article

Language: en

Sources: [Figma Blog](<https://devfeed.tech/sources/figma-blog.md>)

Topics: [Figma](<https://devfeed.tech/topics/figma.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [databases](<https://devfeed.tech/tags/databases.md>), [figma](<https://devfeed.tech/tags/figma.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [performance](<https://devfeed.tech/tags/performance.md>), [scalability](<https://devfeed.tech/tags/scalability.md>)

### AI overview

Figma's infrastructure team describes how database growth created scalability and reliability risks as traffic increased. The team addressed the limits of a single Amazon RDS database through larger instances, read replicas, additional databases for new use cases, and PgBouncer connection pooling, while laying the groundwork for future growth.

### Source excerpt

How the Figma infrastructure team reduced potential instability by scaling to multiple databases.

## Investigating WAL Growth from an Inactive Postgres Replication Slot on Amazon RDS

DevFeed: [Investigating WAL Growth from an Inactive Postgres Replication Slot on Amazon RDS](<https://devfeed.tech/articles/the-insatiable-postgres-replication-slot-18834.md>)

Original publisher: [Read original article](<https://www.morling.dev/blog/insatiable-postgres-replication-slot/>)

Published: 2022-11-30T13:00:00Z

Content type: article

Language: en

Sources: [Gunnar Morling](<https://devfeed.tech/sources/gunnar-morling.md>)

Topics: [Replication](<https://devfeed.tech/topics/replication.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [apache-flink](<https://devfeed.tech/topics/apache-flink.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [apache-flink](<https://devfeed.tech/tags/apache-flink.md>), [database](<https://devfeed.tech/tags/database.md>), [debezium](<https://devfeed.tech/tags/debezium.md>), [disk-space](<https://devfeed.tech/tags/disk-space.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [replication](<https://devfeed.tech/tags/replication.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

This article investigates how an inactive Postgres replication slot on Amazon RDS can retain WAL segments and consume disk space even when the database appears idle. It reproduces the behavior and compares replication-slot LSN differences with RDS storage and transaction-log metrics.

### Source excerpt

Table of Contents The Observation The Solution Take Away While working on a demo for processing change events from Postgres with Apache Flink, I noticed an interesting phenomenon: A Postgres database which I had set up for that demo on Amazon RDS, ran out of disk space. The machine had a disk size of 200 GiB which was fully used up in the course of less than two weeks. Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments after the latest log sequence number (LSN) which was confirmed for that slot. Indeed I had set up a replication slot (via the Decodable CDC source connector for Postgres, which is based on Debezium). I then had stopped that connector, causing the slot to become inactive. The problem was though that I was really sure that there was no traffic in that database whatsoever! What could cause a WAL growth of ~18 GB/day then?

## Security Auditing Amazon RDS Database Activity with Teleport

DevFeed: [Security Auditing Amazon RDS Database Activity with Teleport](<https://devfeed.tech/articles/security-auditing-amazon-rds-database-activity-with-teleport-29566.md>)

Original publisher: [Read original article](<https://goteleport.com/blog/amazon-rds-security-activity-audit/>)

Author: info@goteleport.com (Janakiram MSV)

Published: 2022-06-08T00:00:00Z

Content type: tutorial

Language: en

Sources: [Teleport](<https://devfeed.tech/sources/teleport.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [audit](<https://devfeed.tech/topics/audit.md>), [Security](<https://devfeed.tech/topics/security.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon DynamoDB](<https://devfeed.tech/topics/amazon-dynamodb.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [VPC](<https://devfeed.tech/topics/vpc.md>)

Tags: [amazon-dynamodb](<https://devfeed.tech/tags/amazon-dynamodb.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [audit](<https://devfeed.tech/tags/audit.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bastion-host](<https://devfeed.tech/tags/bastion-host.md>), [cloudtrail](<https://devfeed.tech/tags/cloudtrail.md>), [security](<https://devfeed.tech/tags/security.md>), [vpc](<https://devfeed.tech/tags/vpc.md>)

### AI overview

This tutorial explains how to use Teleport to record and audit Amazon RDS database access events, including live session monitoring, audit logs for DDL and DML queries, and event storage in Amazon DynamoDB.

### Source excerpt

This blog post explains how to record and audit Amazon RDS Database activities with Teleport.

## Configuring Just-in-Time Access to Amazon RDS with Teleport and Slack

DevFeed: [Configuring Just-in-Time Access to Amazon RDS with Teleport and Slack](<https://devfeed.tech/articles/configuring-just-in-time-access-to-amazon-rds-with-teleport-and-slack-29565.md>)

Original publisher: [Read original article](<https://goteleport.com/blog/amazon-rds-jit-access/>)

Author: info@goteleport.com (Janakiram MSV)

Published: 2022-06-03T00:00:00Z

Content type: tutorial

Language: en

Sources: [Teleport](<https://devfeed.tech/sources/teleport.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [JIT](<https://devfeed.tech/topics/jit.md>), [Slack](<https://devfeed.tech/topics/slack.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [DevOps](<https://devfeed.tech/topics/devops.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [blog-post](<https://devfeed.tech/tags/blog-post.md>), [database](<https://devfeed.tech/tags/database.md>), [devops](<https://devfeed.tech/tags/devops.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [jit](<https://devfeed.tech/tags/jit.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [rds](<https://devfeed.tech/tags/rds.md>), [slack](<https://devfeed.tech/tags/slack.md>)

### AI overview

This tutorial explains how to configure just-in-time privilege escalation for Amazon RDS using Teleport and Slack. It describes time-limited access requests, approval workflows, and a scenario involving third-party DevOps and database operations.

### Source excerpt

This blog post explains how to configure Just-in-time (JIT) Access to Amazon RDS with Teleport and Slack.

## How to Configure SSO for Amazon RDS Authentication and Authorization

DevFeed: [How to Configure SSO for Amazon RDS Authentication and Authorization](<https://devfeed.tech/articles/how-to-configure-sso-for-amazon-rds-authentication-and-authorization-29880.md>)

Original publisher: [Read original article](<https://goteleport.com/blog/sso-for-amazon-rds/>)

Author: info@goteleport.com (Janakiram MSV)

Published: 2022-05-13T00:00:00Z

Content type: tutorial

Language: en

Sources: [Teleport](<https://devfeed.tech/sources/teleport.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Single sign-on (SSO)](<https://devfeed.tech/topics/sso.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [okta](<https://devfeed.tech/topics/okta.md>), [saml](<https://devfeed.tech/topics/saml.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [authorization](<https://devfeed.tech/tags/authorization.md>), [aws](<https://devfeed.tech/tags/aws.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [okta](<https://devfeed.tech/tags/okta.md>), [policies](<https://devfeed.tech/tags/policies.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [saml](<https://devfeed.tech/tags/saml.md>), [security](<https://devfeed.tech/tags/security.md>), [sso](<https://devfeed.tech/tags/sso.md>), [tutorial](<https://devfeed.tech/tags/tutorial.md>)

### AI overview

A tutorial explains how to configure single sign-on for Amazon RDS using Okta, SAML, and Teleport. It shows how to map Okta groups to Teleport roles and use role-based access control to restrict access to specific databases, including a sensitive forecast database.

### Source excerpt

This post is a tutorial to set up single sign-on (SSO) for Amazon RDS access

## How to Secure AWS RDS Access with an Identity-Aware Access Proxy

DevFeed: [How to Secure AWS RDS Access with an Identity-Aware Access Proxy](<https://devfeed.tech/articles/how-to-secure-aws-rds-access-with-an-identity-aware-access-proxy-29689.md>)

Original publisher: [Read original article](<https://goteleport.com/blog/how-to-secure-amazon-rds-access-with-identity-aware-access-proxy/>)

Author: info@goteleport.com (Janakiram MSV)

Published: 2022-05-05T00:00:00Z

Content type: tutorial

Language: en

Sources: [Teleport](<https://devfeed.tech/sources/teleport.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [VPC](<https://devfeed.tech/topics/vpc.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [MFA](<https://devfeed.tech/topics/mfa.md>), [audit](<https://devfeed.tech/topics/audit.md>), [certificates](<https://devfeed.tech/topics/certificates.md>)

Tags: [access-control](<https://devfeed.tech/tags/access-control.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [audit](<https://devfeed.tech/tags/audit.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [authorization](<https://devfeed.tech/tags/authorization.md>), [aws](<https://devfeed.tech/tags/aws.md>), [certificates](<https://devfeed.tech/tags/certificates.md>), [cli](<https://devfeed.tech/tags/cli.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [ec2](<https://devfeed.tech/tags/ec2.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [services](<https://devfeed.tech/tags/services.md>), [vpc](<https://devfeed.tech/tags/vpc.md>)

### AI overview

This tutorial explains how to configure Teleport as an identity-aware access proxy for Amazon RDS databases. It covers placing RDS in a private Amazon VPC subnet and configuring the Teleport proxy/auth server, database agent host, and RDS instance. The approach uses identity-based SSO, short-lived certificates, multi-factor authentication, role-based access control, access requests, and auditing.

### Source excerpt

This post explains how to configure Teleport identity-aware access proxy for Amazon RDS access.

## Tutorial: Set up an Identity-Aware Access Proxy as a Bastion Host in AWS

DevFeed: [Tutorial: Set up an Identity-Aware Access Proxy as a Bastion Host in AWS](<https://devfeed.tech/articles/tutorial-set-up-an-identity-aware-access-proxy-as-a-bastion-host-in-aws-29693.md>)

Original publisher: [Read original article](<https://goteleport.com/blog/how-to-setup-aws-bastion/>)

Author: info@goteleport.com (Janakiram MSV)

Published: 2022-03-10T00:00:00Z

Content type: tutorial

Language: en

Sources: [Teleport](<https://devfeed.tech/sources/teleport.md>)

Topics: [Tutorial](<https://devfeed.tech/topics/tutorial.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Zero Trust](<https://devfeed.tech/topics/zero-trust.md>), [Security](<https://devfeed.tech/topics/security.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [VPC](<https://devfeed.tech/topics/vpc.md>), [Amazon Elastic Kubernetes Service](<https://devfeed.tech/topics/amazon-elastic-kubernetes-service.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [DevOps](<https://devfeed.tech/topics/devops.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [amazon-eks](<https://devfeed.tech/tags/amazon-eks.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [amazon-web-services](<https://devfeed.tech/tags/amazon-web-services.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bastion](<https://devfeed.tech/tags/bastion.md>), [bastion-host](<https://devfeed.tech/tags/bastion-host.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [devops](<https://devfeed.tech/tags/devops.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [let](<https://devfeed.tech/tags/let.md>), [oidc](<https://devfeed.tech/tags/oidc.md>), [saml](<https://devfeed.tech/tags/saml.md>), [security](<https://devfeed.tech/tags/security.md>), [tutorial](<https://devfeed.tech/tags/tutorial.md>), [vpc](<https://devfeed.tech/tags/vpc.md>)

### AI overview

This tutorial explains how to use Teleport, an open-source identity-aware access proxy, as a bastion host for securing AWS infrastructure. It focuses on replacing a traditional bastion host with a Teleport proxy and authentication server for SSH access to EC2 instances, while also describing access to services such as RDS and EKS.

### Source excerpt

This post explains how to set-up AWS bastion host based on Teleport identity-aware access proxy.

## The Two AWS RDS Postgres Errors I Always Make

DevFeed: [The Two AWS RDS Postgres Errors I Always Make](<https://devfeed.tech/articles/the-two-aws-rds-postgres-errors-i-always-make-28125.md>)

Original publisher: [Read original article](<http://fuzzyblog.io/blog/aws/2020/04/08/the-two-aws-rds-postgres-errors-i-always-make.html>)

Author: Fuzzygroup

Published: 2020-04-08T00:00:00Z

Content type: tutorial

Language: en

Sources: [Scott Johnson](<https://devfeed.tech/sources/scott-johnson.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon VPC](<https://devfeed.tech/topics/amazon-vpc.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Security](<https://devfeed.tech/topics/security.md>), [ui](<https://devfeed.tech/topics/ui.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [database](<https://devfeed.tech/tags/database.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [rds](<https://devfeed.tech/tags/rds.md>), [security](<https://devfeed.tech/tags/security.md>), [user-interface](<https://devfeed.tech/tags/user-interface.md>), [vpc](<https://devfeed.tech/tags/vpc.md>)

### AI overview

A personal guide to three recurring mistakes when creating Amazon RDS PostgreSQL instances: failing to specify an initial database name, placing the database server in the wrong VPC, and using the wrong security group.

### Source excerpt

You know that awful feeling of personal stupidity when you consistently make the same mistake time after time? Well my approach to addressing that is to document said mistakes, here, each time I make them. Sometimes I take the approach of admitting to them and sometimes I take the approach of just writing them as a blog post. There are two errors, nay three, I make almost every single time I create an RDS postgres instance and I thought "maybe it is time to write them down and (hopefully) curse less" the next time. Note: I wrote this as a text post with pictures below so that the quick answers appear first before a whole bunch of screenshots. Error 1: Not Creating the Database When you Create the Database Server When you create a "database" on RDS you are actually creating a database server on which you then create the database itself. Now the core issue here is that AWS makes it very hard, at least when you are making a Postgres database to create that database later. I'm sure there is a way but, yesterday, in a few hours of messing with this, I never found it. What I had to do was drop my database server and walk through the creation process again, finally finding it nested away in an expandable section of the user interface. When you are walking through the "Create Database" form, there is a final section called "Additional Configuration". If you expand this then the very first option is "Initial Database Name" along with the helpful message: If you do not specify a database name, Amazon RDS does not create a database. Groan. Keep in mind that this whole feature starts on a web page titled "Create Database" (but the default is to NOT create a database). Error 2: Not Putting the Database Server in the Same VPC Generally speaking most of us tend to use a single VPC (virtual private cloud) for our AWS boxes. Despite this it is not guaranteed that your database server ends up in the same VPC as your other boxes unless you explicitly specify this. Error 3: Not Putting

## Vapor: Rotating Your RDS SSL/TLS Certificates

DevFeed: [Vapor: Rotating Your RDS SSL/TLS Certificates](<https://devfeed.tech/articles/vapor-rotating-your-rds-ssl-tls-certificates-3974.md>)

Original publisher: [Read original article](<https://laravel.com/blog/vapor-rotating-your-rds-ssltls-certificates>)

Author: Mohamed Said

Published: 2020-01-10T17:57:00Z

Content type: article

Language: en

Sources: [Laravel Blog](<https://devfeed.tech/sources/laravel-blog.md>)

Topics: [Vapor](<https://devfeed.tech/topics/swift-vapor.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [SSL](<https://devfeed.tech/topics/ssl.md>), [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [net](<https://devfeed.tech/tags/net.md>), [ssl](<https://devfeed.tech/tags/ssl.md>), [tls](<https://devfeed.tech/tags/tls.md>)

### AI overview

Amazon RDS is rotating the SSL/TLS certificates used to connect to RDS databases. Vapor users must update affected instances before the current certificates expire on March 5, 2020, and ensure their Vapor projects use the latest package versions.

### Source excerpt

Amazon RDS has published new SSL/TLS certificates for connecting to your RDS databases. The current certificates will expire on March 5th, 2020. All Vapor users using RDS databases in their projects...

## Amazon RDS Proxy makes it easier to use SQL in Serverless

DevFeed: [Amazon RDS Proxy makes it easier to use SQL in Serverless](<https://devfeed.tech/articles/amazon-rds-proxy-makes-it-easier-to-use-sql-in-serverless-14059.md>)

Original publisher: [Read original article](<https://www.serverless.com/blog/amazon-rds-proxy>)

Author: Alex DeBrie

Published: 2019-12-03T00:00:00Z

Content type: article

Language: en

Sources: [Serverless Blog](<https://devfeed.tech/sources/serverless-blog.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [applications](<https://devfeed.tech/tags/applications.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [cloud-computing](<https://devfeed.tech/tags/cloud-computing.md>), [faas](<https://devfeed.tech/tags/faas.md>), [function-as-a-service](<https://devfeed.tech/tags/function-as-a-service.md>), [infrastructure-as-code](<https://devfeed.tech/tags/infrastructure-as-code.md>), [news](<https://devfeed.tech/tags/news.md>), [post](<https://devfeed.tech/tags/post.md>), [proxy](<https://devfeed.tech/tags/proxy.md>), [re](<https://devfeed.tech/tags/re.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [release](<https://devfeed.tech/tags/release.md>), [serverless](<https://devfeed.tech/tags/serverless.md>), [serverless-architecture](<https://devfeed.tech/tags/serverless-architecture.md>), [serverless-framework](<https://devfeed.tech/tags/serverless-framework.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

Amazon RDS Proxy is presented as addressing a major objection to using relational databases in serverless applications by making SQL easier to use in serverless environments.

### Source excerpt

The release of the Amazon RDS Proxy at re:Invent removes one of the main objections to using relational databases in serverless applications. Read this post to understand why.

[Next page](<https://devfeed.tech/topics/amazon-rds.md?cursor=WyIyMDE5LTEyLTAzVDAwOjAwOjAwKzAwOjAwIiwgIjliNWZkMTZhLWZhYzMtNDAzMy1hNjM2LWIyYjMyYTEzOGE2ZiJd>)