All Questions
Tagged with rds or amazon-rds
7,832 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
16
views
Safe way to perform major version migrations between unsupported RDS versions when deployed with aws-cdk [migrated]
I have an EC2 instance running Amazon Linux 2023 with a Python application running on it connected to PostgreSQL
Currently PostgreSQL is running inside RDS with major version 14.x
The entire setup has ...
0
votes
0
answers
37
views
POSTGRES_HOST needed in user data to launch EC2 but postgres needs to be deployed in RDS to create POSTGRES_HOST, how to break this loop in cdk? [closed]
I am using aws-cdk to create an EC2 instance running Amazon Linux 2023 and an RDS instance running PostgreSQL 18.1
My EC2 instance will run a python application inside docker
This python application ...
0
votes
0
answers
13
views
How to increase undo tablespaces on aws rds mysql innodb_undo_tablespaces [migrated]
I have the issue that my undo history keeps growing and purging does not catch up.
This number constantly increases:
SELECT count FROM information_schema.innodb_metrics WHERE name = '...
0
votes
0
answers
69
views
AWS RDS MariaDB query surprisingly slow on single value result
I have the following tables:
create table account_transactions
(
id int auto_increment primary key,
account_id int not null,
amount ...
0
votes
1
answer
65
views
Connection to AWS RDS with Secret manager creds from python SQL Alchemy failed with no pg_hba.conf entry for host ... no encryption
I created an AWS RDS in CDK using secret manager credentials:
rds.DatabaseInstance(
self,
id=resource_name,
instance_identifier=resource_name,
...
Best practices
0
votes
1
replies
62
views
Doing password rotation with spring-boot
I'm a DevOps engineer trying to implement password rotation for multiple services, some are Python, some Node but most are Kotlin and are using spring-boot, Our passwords are encrypted outside AWS and ...
1
vote
1
answer
140
views
Exporting Incremental RDS Snapshot into an S3 Bucket
I would like to ask two questions;
1- if RDS snapshots are incremental when we exported the incremental snapshot in to s3 via ExportTask will it be the only partial data or full data.
2- When data is ...
Advice
1
vote
3
replies
51
views
Safe to run "VACUUM FREEZE" on template1 or template0 databases in postgres?
I run periodic VACUUM FREEZE on my main database to avoid aggressive vacuuming during busy times, wondering if it's safe to run freeze on template databases too before they reach the threshold (200M ...
1
vote
0
answers
24
views
How to capture IAM user identity in Aurora MySQL audit logs when connecting through AWS TEAM elevated access?
I’m using TEAM elevated access for AWS in my organization to temporarily access an Aurora MySQL cluster.
TEAM provides database access through a tunneled MySQL session using a generic database ...
Advice
1
vote
2
replies
78
views
AWS How to identify/recommend the instance type for an RDS?
I am currently working on recommendation for aws rds instance type recommendation. We have identified the instances which are underutilised.
I want to know how to recommend a better version of rds ...
0
votes
0
answers
55
views
Application running in Docker containers the application restarted using Amazon RDS Aurora MySQL for the database and experiencing out-of-memory issue
UncaughtException: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap ...
0
votes
2
answers
92
views
AWS Lambda inside VPC cannot connect to RDS MySQL (timeout)
Background
I'm building a Lambda function (Node.js 20 runtime) that connects to an Amazon RDS MySQL database within the same VPC.
Both the Lambda and the RDS instance are deployed in private subnets.
...
0
votes
0
answers
148
views
Sudden CPU spike on AWS RDS (PostgreSQL) after running fine for the entire last month
I encountered an issue where our AWS RDS (PostgreSQL) instance suddenly experienced a high CPU spike, even though it had been running normally for the entire previous month.
Currently, the system is ...
1
vote
1
answer
79
views
PSQLException: ERROR: buffer is pinned in InvalidateBuffer on CREATE DATABASE command
Working with Amazon RDS - PostgreSQL 16, my Java application started receiving the following error when trying to run the CREATE DATABASE command
Caused by: org.postgresql.util.PSQLException: ERROR: ...
0
votes
1
answer
55
views
npm drizzle-kit and AWS RDS: Error: getaddrinfo EAI_AGAIN
I don't seem to be able to push my configuration to RDS
// package.json
"drizzle-kit": "^0.31.5",
// drizzle.config.ts
import { defineConfig, Config } from 'drizzle-kit';
const ...