We changed our privacy policy. Read more.

Questions tagged [amazon-rds]

Use this tag if a question is about amazon-rds

Filter by
Sorted by
Tagged with
11
votes
2answers
3k 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
817 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 ...
4
votes
1answer
64 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 ...
3
votes
2answers
1k 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 ...
3
votes
1answer
67 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 ...
2
votes
2answers
89 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 ...
2
votes
2answers
277 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 ...
2
votes
1answer
160 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( ...
2
votes
3answers
38 views

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

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

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 ...
1
vote
1answer
311 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 ...
1
vote
2answers
114 views

Question about the new AWS RDS CA

When updating the database to use the new CA, you get this popup: Before scheduling the CA certificate rotation, update client applications that connect to your database to use the new CA ...
1
vote
1answer
34 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 ...
1
vote
1answer
22 views

AWS: Restoring database snapshot to different environment

I've a webapp hosted on AWS. This has Electric Beanstalk, with EC2 and then a RDS Postgres database at the bottom. There's prod, UAT and staging environments and databases. I want to take a recent ...
1
vote
1answer
12 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
45 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 ...
0
votes
1answer
26 views

Is it possible to deploy RDS in multiple region in AWS with read and write replica

I have an application that I need to make it accessible across 4 regions, I saw blogs and other posts in the internet that speaks about the read replica of AWS RDS MySQL Server, is it possible to ...
0
votes
1answer
29 views

Keeping AWS RDS Instances up to date

We are running databases in AWS RDS (MySQL Databases), EC2 instances etc. We keep the EC2 instances up-to-date with the latest AMI based on the latest security patches etc, we do this through ...
0
votes
1answer
68 views

Does a DB connection prevent AWS Aurora Serverless from pausing its compute capacity?

I want to host an application that connects to a DB and makes queries to it. The application holds onto the connection indefinitely but only makes queries to the DB when the user interacts with the ...
0
votes
1answer
38 views

Secure RDS (private endpoint) and allow connecting from local machine for specific predefined users

I'm looking for some way to allow access to RDS (Private endpoint) instances from local machine for a specific set of people (for the internal team.) ways I know: Create Bastion EC2 and through SSH ...
0
votes
2answers
965 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
1answer
35 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 ...