DevOps Stack Exchange
DevOps Stack Exchange

Questions tagged [amazon-rds]

Use this tag if a question is about amazon-rds

26 questions
11
votes
2 answers

Can I rename an RDS instance?

I have inherited a collection of RDS MySQL instances with random (useless) DB Instance names. I often have to dig into the tags section to find out which project they belong to. One of the settings I can modify in an RDS is the DB Instance…
Danny Schoemann
  • 451
  • 5
  • 19
6
votes
3 answers

DynamoDB vs RDS for a counter store?

I have multiple lambda functions, which a file passes through for processing, and I want to store the status of each computation in a counter, for better logging and monitoring. Current plan is to log it like this: file-name Lambda1 Lambda2…
Dawny33
  • 2,816
  • 3
  • 24
  • 62
4
votes
1 answer

Trade offs of putting an international master database in us-west-2

I'm hoping this isn't so open ended that it veers towards a "discussion" more than an "answerable" question. I need to place an RDS Postgres instance in an AWS region that will act as the master DB for writes from all other regions. Those regions…
Chris
  • 151
  • 2
4
votes
1 answer

What are the real world benefits of RDS instance (at rest) encryption?

AWS offers at rest encryption for its RDS instances. I think this sounds nice, and it's something that comes up regularly on security reviews but I'm not sure what the real benefit is. The most likely way someone will get access to my database is…
MrDuk
  • 295
  • 2
  • 8
3
votes
1 answer

Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?

For example, if I have a SQL Server instance in RDS, and I have only a connection string to connect to the server, is there a sproc or some pre-configured tables I can access via SQL on the instance that would report the instance size string?…
Triynko
  • 131
  • 1
3
votes
2 answers

List encrypted RDS snapshots using CLI

I have automated the RDS snapshot copy across the region, but the Snapshot which is encrypted gets fail to copy. I have figured a way to copy an encrypted snapshot using $ aws rds copy-db-snapshot --source-db-snapshot-identifier…
Nirbhay Singh
  • 131
  • 2
2
votes
2 answers

Ansible: Test if multiple RDS instances are all stopped

With Ansible, I'm stopping several RDS (it could be EC2) instances. Then I want continue only when all of them are in the state stopped. I use the following task: - name: Wait for RDS modify to finish rds_instance_facts: aws_access_key: "{{…
jmary
  • 171
  • 5
2
votes
0 answers

How to manage the database in an environment per branch, creating a new instance per branch is the best approach?

I'm trying to create an environment per branch using Git lab CI, until here we're good. But my concern right now is how to manage the Database? I thought of using RDS and terraform, but what I'm doing is basically creating and destroying an RDS…
Diego
  • 121
  • 3
2
votes
2 answers

How to handle AWS Offsite or cross-account RDS (mysql) backups?

AWS Provides a great solution to provide point-in-time recovery backups within RDS. However, while we take every measure to protect the root account, I'm paranoid that if someone were to gain access they can wipe the entire AWS account including all…
Brad
  • 179
  • 1
  • 3
2
votes
1 answer

Cross Region Copy of Aurora Snapshots

current_date = str(dt.now().strftime('%Y-%m-%d')) target_cluster_snapshot_arn= current_date+'_Development_Aurora' response = TARGET_CLIENT.copy_db_cluster_snapshot( SourceDBClusterSnapshotIdentifier=source_cluster_snapshot_arn, …
Prashast
  • 67
  • 1
  • 8
2
votes
3 answers

Export AWS RDS mysql Database to S3 Bucket using xtrabackup or any other method

I have an AWS RDS MySQL Database. The size of the Database is around of 1.5 GB. We are using MySQL 5.7.32. We tried with SQL dump but in dump data is missing in Dump. We found out that we can use xtrabackup. We are using xtrabackup version 2.4.21…
Hiren Namera
  • 123
  • 1
  • 4
1
vote
1 answer

AWS RDS- Determine what Database Tables aren't interacted with?

Is it possible to have AWS-RDS (or another aws service) generate a report on databases that haven't been interacted with (write/read) after a certain period of time? My background is in QA and I'm relatively new to the DevOps game, sorry if this is…
TinCan
  • 43
  • 3
1
vote
1 answer

How to share RDS snapshots across account roles?

I'm using an AWS account which has different roles for the different environments we use. For example, we have a Development role for our development environment and a Production role for our production environment. At any point of time, we switch…
xenon
  • 111
  • 2
1
vote
1 answer

How do I use only an encrypted version of my AWS RDS password in my terraform code?

Is there a way to only have an encrypted version of my RDS password in my Terraform code and for AWS to decrypt it for RDS so you use the decrypted password to login to the RDS? So set my rds password variable value to the encrypted password and…
doug
  • 523
  • 2
  • 6
  • 15
1
vote
1 answer

RDS IOPS utilizing fully

I have upgraded RDS mysql to 1000 IOPS from 120 IOPS, But same database operations utilizing more than 1000 IOPS now. Is there any way to implement RDS cluster or Is it possible to make use of lambda to reduce the usage of IOPS and load? Newbie…
pbms
  • 121
  • 4
1
2