Stack Overflow
Stack Overflow

Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
42
votes
4 answers

Amazon RDS - Online only when needed?

I had a question about Amazon RDS. I only need the database online for about 2 hours a day but I am dealing with quite a large database at around 1gb. I have two main questions: Can I automate bringing my RDS database online and offline via…
Jimmy
  • 12,087
  • 28
  • 102
  • 192
40
votes
4 answers

Static outgoing IP in Kubernetes

I run a k8s cluster in google cloud (GKE) and a MySQL server in aws (RDS). Pods need to connect to RDS which only allows connections from certain IP. How can I configure outgoing traffic to have a static IP?
Shouichi
  • 1,090
  • 1
  • 10
  • 25
40
votes
4 answers

AWS Elastic Beanstalk change RDS Endpoint

How do I change the configured RDS endpoint of an AWS Elastic Beanstalk environment? E.g. after the RDS database was deleted or should be replaced with a new RDS database.
tholu
  • 1,150
  • 2
  • 10
  • 24
40
votes
6 answers

how to 'load data infile' on amazon RDS?

not sure if this is a question better suited for serverfault but I've been messing with amazon RDS lately and was having trouble getting 'file' privileges to my web host mysql user. I'd assume that a simple: grant file on *.* to 'webuser@'%'; would…
eyberg
  • 3,160
  • 5
  • 27
  • 43
38
votes
12 answers

No module named 'psycopg2._psycopg': ModuleNotFoundError in AWS Lambda

I have created a deployment package for AWS Lambda with my python file and the dependencies including sqlalchemy and psycopg2. The code works perfectly in accessing the DB locally. But when I imported this zip file, I am getting the following error.…
Kathiravan Natarajan
  • 3,158
  • 6
  • 22
  • 45
38
votes
1 answer

Amazon RDS stop instance

I am working on Amazon RDS, but I don't need instances to run all the day 24/7, as I'm only developing right now. Is there any way to stop an RDS instance when I don't need it? I don't want to pay what I don't use!
bukk530
  • 1,858
  • 2
  • 20
  • 30
37
votes
1 answer

Is multi-AZ RDS really worth it?

Looking at the prices for RDS instances, the multi-AZ instances cost double. Having a production environment in mind, does it worth it? What uptime should I expect from a single-AZ instance, as opposed to a multi-AZ one? Has anyone had experience…
UriP
  • 526
  • 1
  • 5
  • 8
36
votes
6 answers

AWS Postgres DB "does not exist" when connecting with PG

I can't seem to connect to my DB instance in AWS. I'm using the pg package and following the examples from the website is not working. A search for "aws postgres database does not exist" really isn't returning anything helpful. Going through the…
Brandon Benefield
  • 1,504
  • 1
  • 21
  • 36
36
votes
3 answers

When should I use a t2.medium vs. a m3.medium instance type within AWS?

They appear to be approximately the same in terms of performance. Model vCPU Mem (GiB) SSD Storage (GB) m3.medium 1 3.75 1 x 4 Model vCPU CPU Credits / hour Mem (GiB) Storage t2.medium 2 24 4 EBS-Only t2.medium allows…
Charles Sounder
  • 591
  • 2
  • 5
  • 16
35
votes
5 answers

Minimal KMS permissions to copy a database snapshot

I am trying to setup minimal permissions for doing aws rds copy-db-snapshot with a KMS encryption key: $ aws rds copy-db-snapshot --source-db-snapshot-identifier rds-backup-share- mysql --target-db-snapshot-identifier…
svenwltr
  • 17,002
  • 12
  • 56
  • 68
35
votes
5 answers

Rename the Amazon RDS master username

Changing the password is easily done through the console. Is there any way to change the master username after creation on RDS for PostgreSQL? If so, how?
Laura
  • 469
  • 1
  • 6
  • 12
35
votes
8 answers

Amazon RDS MySQL instance performs very slow

I have published my website on Amazon EC2 (Singapore region) and I have used MySQL RDS instance for the data storage. Everything is working very fine except performance. I seems that, my all queries, especially the select statement, is performing…
Manish Sapkal
  • 5,591
  • 8
  • 45
  • 74
34
votes
0 answers

AWS Aurora: What is 'delayed send/commit ok done' process state

What do the following process states mean in AWS Aurora (MYSQL-Compatible) delayed send ok done delayed commit ok done Noticing many sleeping processes with the above state. These seem to Aurora-specific. Are these states any indicators of…
Nikhil Gaur
  • 1,280
  • 3
  • 19
  • 40
33
votes
6 answers

AWS RDS public access

I am stumped with AWS configuration. My goal is to create a database that's accessible from inside and outside the network. Here is what I have. RDS instance runs postgresql. Connections from inside the VPC work correctly. The endpoint is set up to…
KateYoak
  • 1,591
  • 3
  • 18
  • 34
32
votes
7 answers

Migrate to Amazon SQL Server RDS

I have been attempting to move from a regular SQL Server on a Win2008 Server to the SQL Server on Amazon AWS RDS. I thought an simple backup and restore would work. Though AWS RDS doesn't seem to have access to a file system so the sql scripts all…
tourdownunder
  • 1,779
  • 4
  • 22
  • 34
1 2
3
…
99 100