7,807 questions
Best practices
0
votes
2
replies
85
views
I want to know about the Read/Write replica RDS connectivity for springboot. If any existing git link is there regarding this, it will be helpful
What is a safe migration strategy for introducing AWS RDS Read Replicas into an existing Spring Boot application that currently uses a single MySQL datasource?
Goals:
• Minimal downtime
• Ability to ...
- reputation score 1
Best practices
1
vote
1
replies
56
views
AWS Snowball vs AWS DMS
I am preparing for AWS Solutions Architect Professional using kasam.app
I am stuck with this question:
https://learn.kasam.app/sap_c02/858ae4c5-b71e-4acc-9818-484c281240a2
Kasam says option B.
For ...
- reputation score 2243
Advice
0
votes
4
replies
206
views
AWS IAM Authentication on DB level
I have an Intance with multiple DB's in it and I would like to provide access to DB's using the IAM but I am not sure if that is possible with AWS IAM on a DB level. I am pretty sure I can do it on ...
- reputation score 1673
0
votes
1
answer
85
views
Alembic Multitenant Aws
I'm building a multi-tenant SaaS with multiple databases, one per tenant in the AWS environment. I'm facing the issue of how to manage migration versioning so that all tenants have the same schema.
...
- reputation score 1
0
votes
0
answers
31
views
Project can't connect to AWS RDS after upgrade - SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client [duplicate]
Alright, so I have a database (and a read replica) on AWS RDS, and I have been getting the nag warning about how the MySQL version it's on (8.0.34) needs to be updated before July, so I thought I ...
- reputation score 1176
0
votes
0
answers
91
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 ...
- reputation score 1448
0
votes
1
answer
92
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,
...
- reputation score 3757
Best practices
0
votes
1
replies
89
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 ...
- reputation score 1708
1
vote
1
answer
201
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 ...
- reputation score 13
Advice
1
vote
3
replies
101
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 ...
- reputation score 7587
2
votes
0
answers
52
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 ...
- reputation score 21
Advice
1
vote
2
replies
122
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 ...
- reputation score 29
0
votes
0
answers
70
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 ...
- reputation score 1
0
votes
1
answer
123
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.
...
- reputation score 1
0
votes
0
answers
268
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 ...
- reputation score 13
