116
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
...
- 1,338
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 ...
- 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/...
- 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. ...
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.
- 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 ...
- 351
18
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 ...
- 181
17
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/...
- 186
16
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)....
- 601
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 ...
- 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 ...
- 251
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 ...
- 633
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 ...
- 7,760
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 ...
- 32.9k
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 ...
- 966
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 ...
- 231
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 ...
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:...
- 10.3k
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 ...
- 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.
- 32.9k
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. ...
- 4,924
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 ...
- 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 ...
- 1,105
9
votes
AWS Security Group for RDS - Outbound rules
Is this a security risk?
Potentially, yes. Some configurations, such as Postgres foreign data wrappers could allow your RDS instance to establish outbound connections, and anything you allow that ...
- 23k
9
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 ...
- 13.5k
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 ...
- 3,860
9
votes
Accepted
Understanding EBSByteBalance% in AWS RDS gp3 volumes
Okay, I followed @Tim's advice and contacted AWS support. They clarified the following:
Kindy be informed the metrics 'EBSIOBalance%' and 'EBSByteBalance%' are instance class metrics. Please note ...
- 573
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 ...
- 181
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';
- 181
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!
...
- 25.5k
Only top scored, non community-wiki answers of a minimum length are eligible