Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Amazon RDS (Relational Database Service) is a distributed relational database service based on popular variants, running in the cloud. Currently supported are:

  • MySQL
  • Oracle
  • SQL Server
  • PostgreSQL

Additional Documentation:

528 questions
76
votes
8 answers

AWS RDS connection limits

RDS server come up with 40 connection max, as in the following documentation I am using Magento 1.9, and at some points, i reach the max number then website is out of service. Do you have any recommended way to solve this issue? From my…
Alaa Badran
  • 873
  • 1
  • 7
  • 7
52
votes
9 answers

How do you recover you RDS master user username?

Resetting the RDS master user's password is simple enough, but how do you find your master users username?
mkirk
  • 643
  • 1
  • 5
  • 7
50
votes
4 answers

What is "freeable memory"?

Amazon RDS has a metric for 'freeable memory'. It appears to go up & down in a sawtooth pattern. This leads me to believe that it's memory that is being used by MySQL for caching and that when the cache expires, more freeable memory appears. Any…
Adam Nelson
  • 1,557
  • 3
  • 13
  • 12
49
votes
4 answers

unable to connect to public postgresql rds instance

I created a basic test PostgreSQL RDS instance in a VPC that has a single public subnet and that should be available to connect over the public internet. It uses the default security group, which is open for port 5432. When I try to connect, it…
Edward Q. Bridges
  • 1,201
  • 1
  • 9
  • 9
48
votes
8 answers

Why can't I connect to Amazon RDS after setting it up?

So, I just created the Amazon RDS account. And I started an instance of database. The "endpoint" is: abcw3n-prod.cbmbuiv8aakk.us-east-1.rds.amazonaws.com Great! Now I try to connect to it from one of my other EC2 instances. mysql -uUSER -pPASS…
Alex
  • 8,111
  • 24
  • 71
  • 99
30
votes
3 answers

Why can't I create a superuser in AWS Postgresql instance?

I have an AWS EC2 instance connecting to an RDS instance (Postgresql). When I created the RDS instance, I told it the DB root's username was: my_user1 and the password was password1. Now I'm attempting to create a role and a super-user. But it…
Saqib Ali
  • 529
  • 1
  • 8
  • 18
30
votes
2 answers

Downtime for increasing AWS RDS storage?

I am looking to increase storage of two RDS instances (just the storage space allocated, not the instance type or other parameters). The documentation at…
Andy Shinn
  • 4,131
  • 8
  • 38
  • 55
29
votes
6 answers

How to associate an existing RDS instance to an Elastic Beanstalk environment?

I have created my RDS instance before creating my Elastic Beanstalk environment. The two are working together with no problem, but I'd like them to be linked together, and have the RDS parameters accessible via the RDS_* environment variables. The…
BenMorel
  • 4,215
  • 10
  • 53
  • 81
28
votes
1 answer

What is the rdsadmin user and should I care?

I've inherited control of an AWS MySQL RDS instance. I'm curious to know what the 'rdsadmin' user is and whether I should know the password for this or whether this is purely for use by the Amazon Web Console.
codecowboy
  • 1,287
  • 5
  • 17
  • 31
22
votes
7 answers

"Update Your Amazon RDS SSL/TLS Certificates by October 31, 2019"

I, like a lot of people, received an email saying to update my RDS instance to use the new rds-ca-2019 certificate for SSL connections (previous being rds-ca-2015 which expires March 5, 2020). Their documentation about the process is a little…
Tim Tisdall
  • 623
  • 1
  • 5
  • 17
20
votes
3 answers

Highest value of max_connections in AWS RDS micro instance

Currently, the value for the max_connections parameter in a MySQL RDS t1.micro server model is {DBInstanceClassMemory/12582880} is 32. Since my server does not allowing any more connections after 32, what is the Maximum safe value for…
Straw Hat
  • 345
  • 1
  • 3
  • 12
20
votes
2 answers

In AWS, does an hour of usage get charged just for an instance being in the "running" state?

When AWS documentation and pricing refer to "usage" does this simply mean "if the instance is on" instead of "if the instance is on and doing work". E.g., if I had an EC2 instance running but it was idle (CPU=0%), I assume I still get charged for…
Josh M.
  • 667
  • 8
  • 21
20
votes
3 answers

Is it possible to force Re-creation of EC2::Instance or RDS::DBInstance in amazon cloudformation?

It's possible to force the re-creation of a EC2 or RDS instance using cloudformation stacks? My stack goes stuck in a point where simply destroying and creating the resource will fix it, instead of that I had to delete entire stack to continue…
theist
  • 1,199
  • 2
  • 9
  • 24
17
votes
3 answers

Can't find the private IP address for my Amazon-RDS instance

I moved my Master/slave database architecture to Amazon RDS and everything works fine. But I have a slave out of the RDS service which should keep sync with the new Master server, to do so I have to point my DB domain name master-db.myawsserver.com…
Imad Touil
  • 273
  • 1
  • 2
  • 5
16
votes
3 answers

Why is my "volume bytes used" always increasing on my Amazon Aurora cluster?

I have an Amazon (AWS) Aurora DB cluster, and every day, its [Billed] Volume Bytes Used is increasing. I have checked the size of all my tables (in all my databases on that cluster) using the INFORMATION_SCHEMA.TABLES table: SELECT…
Guillaume Boudreau
  • 634
  • 1
  • 5
  • 13
1
2 3
…
35 36