115 votes
Accepted

AWS RDS connection limits

AWS RDS max_connections limit variable is based on Instance type, so you can upgrade your RDS or make more replica. The RDS types with max_connections limit: t2.micro 66 t2.small 150 m3.medium 296 ...
Nick Tsai's user avatar
  • 1,328
54 votes

AWS RDS connection limits

You can change the max_connections value by either updating the default parameter policy or create a new one - I'd suggest going with the latter. Go to RDS Parameter Groups Create a new Parameter ...
David's user avatar
  • 541
34 votes

What is "freeable memory"?

It is basically available RAM. See answer from AWS here https://forums.aws.amazon.com/thread.jspa?threadID=209720 and the official documentation is here http://docs.aws.amazon.com/AmazonRDS/latest/...
AstroTom's user avatar
  • 687
26 votes
Accepted

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

There are multiple things at play here... Each table is stored in its own tablespace By default, the parameter group for Aurora clusters (named default.aurora5.6) defines innodb_file_per_table = ON. ...
Guillaume Boudreau's user avatar
21 votes

How do you recover you RDS master user username?

It is 2019 now. It is 'Databases' on the sidebar, 'Configuration' on the navigation bar. And look for username.
kklw's user avatar
  • 319
18 votes

Unable to connect to public PostgreSQL RDS instance

I was facing similar issue, and this is how I resolved it: Click on the security group for the RDS instance and check the inbound rules. You might see something like this: You have to set the IP ...
Miguel Mota's user avatar
17 votes

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

You can find a required info in the EC2 console. Go to RDS Console Select Databases and find required DB Instance. Open it and find details Go to Connectivity & security and find VPC ...
Alexey Parshikov's user avatar
16 votes
Accepted

How to Rename a Database on a SQL Server Amazon RDS Instance?

RDS has recently added a stored procedure to accomplish this: EXEC rdsadmin.dbo.rds_modify_db_name N'<OldName>', N'<NewName>' Source: https://docs.aws.amazon.com/AmazonRDS/latest/...
patadactyl's user avatar
15 votes
Accepted

Reset slow_log tables in RDS of AWS

I got a solution Amazon RDS will not give you SSH access to its database server. That means you don’t have the opportunity to view any of the log files, even the slow query log, for the database. But ...
suresh's user avatar
  • 301
15 votes

AWS RDS connection limits

Actual info for Postgresql t3-instances (default.postgres10 parameter group): db.t3.micro - 112 max_connections db.t3.small - 225 max_connections db.t3.medium - 450 max_connections db.t3.large - 901 ...
anton.uspehov's user avatar
14 votes
Accepted

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

The default sslmode for PostgreSQL is prefer which means it will encrypt the connection with the certificate provided by the server but will not verify it. If I were to change the sslmode setting to ...
Tim Tisdall's user avatar
14 votes
Accepted

Can't upgrade RDS instance from MySQL 5.7.x to 8.0.x

Under Logs & events, open PrePatchCompatibility.log. Scroll to the very bottom where it lists the error count. You'll likely see that there were errors. Scroll back up until you find the error(s)....
Zenexer's user avatar
  • 571
13 votes
Accepted

How to check via aws cli if a specific rds instance exists?

Notice the constraint in the docs when using --db-instance-indentifier: --db-instance-identifier (string) The user-supplied instance identifier. If this parameter is specified, information from ...
slm's user avatar
  • 7,715
13 votes
Accepted

Does RDS in private subnet inside AWS VPC need a NAT instance/gateway?

General Rule NAT provides outgoing internet access, and does not allow incoming connections. Note that NAT gateway is a managed service, and is generally preferred over a NAT instance. RDS does not ...
Tim's user avatar
  • 32.6k
13 votes
Accepted

How to see what is my Amazon rds password

With a standard RDS, you can't. For security reasons they set it up so that, if you lose the password, the only way to recover is to either guess what it was or to reset it. If this is done properly ...
Michael's user avatar
  • 956
12 votes

How to move RDS database to different VPC

Amazon has recently issued a press release announcing that you can now change the VPC for existing RDS instances: You can now easily change the Amazon Virtual Private Cloud (Amazon VPC) used by your ...
Siddharth Sharma's user avatar
10 votes

How do you recover you RDS master user username?

With the new updated RDS UI, the username is present in the Details section of the Instance Information screen. From the List of your running Instances, click an instance name to see information ...
Sai Phaninder Reddy J's user avatar
10 votes
Accepted

Any drawback in using AWS RDS "dev/test" instance for production?

There is no persistent difference between choosing the Development and Production options in the new RDS instance wizard. Selecting the options simply chooses different defaults on the following pages:...
Matt Houser's user avatar
  • 10.2k
10 votes

Diagnosing low disk space error from PostgreSQL despite low disk usage

You are getting this error because PostgreSQL is running out of space to write a temporary file. You have at least one query that causes the database to occasionally write out a temporary table that ...
Larry's user avatar
  • 286
10 votes
Accepted

AWS CIDR is not within the CIDR ranges of VPC

AWS is correct. 10.0.0.0/24 is 10.0.0.0 to 10.0.0.255. You're trying to add something outside this range, 10.0.1.x You probably meant to create your VPC as 10.0.0.0/16.
Tim's user avatar
  • 32.6k
10 votes

RDS snapshot: how long does I/O suspension occur?

The answer comes from understanding how snapshotting works. At the start of a snapshot, a message (command) is sent to all applications to come to a consistent state and flush necessary data to disk. ...
John Hanley's user avatar
  • 4,904
10 votes
Accepted

Unknown Database when trying to connect to an AWS RDS instance

When you create you create your RDS instance, there is an “Additional configuration” section, in which you can specify the database name, and it warns you that if no name is provided, no database will ...
Rob's user avatar
  • 216
9 votes

What is "freeable memory"?

From this Q&A on the AWS Forum: The freeable memory includes the amount of physical memory left unused by the system plus the total amount of buffer or page cache memory that are free and ...
dr_'s user avatar
  • 1,105
9 votes

AWS Security Group for RDS - Outbound rules

Is this a security risk? Theoretically, yes. In practicality, there's almost certainly no significant risk, but anything allowed that isn't needed is arguably a "risk." What should be the ideal ...
Michael - sqlbot's user avatar
9 votes
Accepted

Amazon AWS RDS Burst Balance vs CPU Credit Balance

CPUCreditBalance and BurstBalance are two unrelated metrics. On T type instances, you have a CPUCreditBalance. If you have sustained CPU usage you will deplete your credit balance and the machine will ...
Appleoddity's user avatar
  • 3,753
8 votes

Unable to connect to public PostgreSQL RDS instance

I had a similar issue while connecting to PostgreSQL. Even though i had publically access true, i was not able to connect. I added one rule inbound rule in the security group and now it is working ...
Abhash Kumar's user avatar
8 votes

AWS RDS connection limits

Login to your RDS instance (using a MySQL client) and run the following query: SHOW VARIABLES LIKE 'max_connections';
Shammi Shailaj's user avatar
8 votes

Unknown Database when trying to connect to an AWS RDS instance

The name that you circled in the second screenshot is not a mysql database name, it's merely an identifier how your database instance is known as in AWS, i.e. endpoint name. These may be different! ...
MLu's user avatar
  • 25.3k
8 votes
Accepted

What is the "Automated backups" tab in AWS RDS console on Aurora engines?

I'm using Aurora as my engine. I got a response from AWS support that explains why this tab is empty for Aurora DBs: Aurora Cluster stores its data in a cluster volume and you cannot disable ...
Charlie Schliesser's user avatar
8 votes
Accepted

How do I specify an option group when upgrading RDS database?

Databases can only be upgraded in the RDS Console if they use a default option group. (Presumably all databases created in the RDS Console also use the default option group.) In my case, the database ...
Nic's user avatar
  • 13.5k

Only top scored, non community-wiki answers of a minimum length are eligible