Questions tagged [amazon-rds]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
36 views

Why am I experiencing delays in RDS vs EC2 local MySQL

I am trying to test a single tier software separated into 2 tiers on AWS. Before, the MySQl was local, now I am trying remote on RDS. The problem is I am seeing execution time differences on large ...
1
vote
1answer
10 views

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 ...
1
vote
1answer
6 views

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 ...
2
votes
2answers
24 views

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 ...
1
vote
1answer
67 views

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 ...
0
votes
1answer
18 views

Connect to RDS Private Instance from Docker Container

I am running a docker swarm cluster and I was trying to connect to a private RDS instance within the same VPC from a docker container which is running in an EC2 within the same VPC but I get an error ...
2
votes
0answers
16 views

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 ...
3
votes
1answer
37 views

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 ...
1
vote
2answers
39 views

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 ...
1
vote
1answer
28 views

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 ...
3
votes
0answers
49 views

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 ...
-2
votes
1answer
33 views

Python Dictionary [closed]

I am getting the output from my previous executions something like this: [{u'Value': '2018-06-21', u'Key': 'Deletion_Date'}] I want to get only 2018-06-21 saved in a variable. I tried this ...
2
votes
1answer
50 views

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( ...
3
votes
2answers
900 views

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 ...
11
votes
2answers
1k views

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 ...
6
votes
3answers
660 views

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 ...