Questions tagged [amazon-rds]
Use this tag if a question is about amazon-rds
28
questions
0
votes
0
answers
14
views
Assigning new role to already existing user in RDS
"We have an RDS instance hosted for Aurora PostgreSQL, specifically using the 'db.r5.xlarge' instance type. When we initially set up the RDS instance, a default user named 'rdsadmin' was ...
0
votes
0
answers
64
views
Cannot install packages with apt in docker image
I'm trying to create my own postgres image that is supposed to connect to a postgreSQL database hosted on AWS RDS, however, I'm having trouble connecting to that database as well as trouble installing ...
- 1
0
votes
0
answers
221
views
How to edit a GitLab managed Terraform state file?
I seem to have encountered a long-standing Terraform issue, where I have attempted to create an AWS RDS Cluster without having specified skip_final_snapshot = true,
however any attempt to extricate ...
- 101
0
votes
0
answers
521
views
How can I view data exported from AWS RDS Performance Insights locally?
We use Performance Insights in RDS to discover and troubleshoot DB query issues. It is very useful to be able to look at a timeline with the dev team and point out the effect of badly formed queries ...
0
votes
1
answer
547
views
aws_availability_zones returns an availability zone ap-southeast-2c that is not available
I'm attempting to create an AWS RDS Serverless v2 cluster in region ap-southeast-2 (Sydney) using the following Terraform configuration:
provider "aws" {
region = "ap-southeast-2"...
- 101
4
votes
1
answer
163
views
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 ...
- 295
2
votes
3
answers
2k
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 ...
- 123
1
vote
1
answer
764
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 ...
- 111
0
votes
1
answer
135
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 ...
- 113
1
vote
1
answer
484
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 ...
- 113
0
votes
1
answer
206
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 ...
- 116
0
votes
1
answer
66
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 ...
1
vote
2
answers
344
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
...
- 111
1
vote
1
answer
21
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 ...
- 43
1
vote
1
answer
66
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 ...
- 111
2
votes
2
answers
250
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 ...
- 171
1
vote
1
answer
399
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 ...
- 513
0
votes
2
answers
2k
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 ...
- 23
2
votes
0
answers
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 ...
- 121
3
votes
1
answer
266
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 ...
- 131
2
votes
2
answers
428
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 ...
- 151
1
vote
1
answer
38
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 ...
- 121
4
votes
1
answer
68
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 ...
- 151
-2
votes
1
answer
38
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
...
- 77
2
votes
1
answer
254
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(
...
- 77
3
votes
2
answers
2k
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 ...
- 131
11
votes
2
answers
5k
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 ...
- 441
6
votes
3
answers
1k
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 ...
- 2,826