Hot answers tagged

113 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,298
62 votes
Accepted

unable to connect to public postgresql rds instance

The issue was that the inbound rule in the Security Group specified a security group as the source. Changing it to a CIDR that included my IP address fixed the issue. Open the database security ...
53 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 ...
  • 531
42 votes

How do you recover you RDS master user username?

The master username is now listed in the RDS Dashboard. Select the "Instances" listing and expand the DB instance. Press the looking glass tab on the left. The master username is listed in the left ...
  • 521
34 votes
Accepted

AWS can not change DB Subnet Group for AWS RDS

I had this same question a few months back, and ended up contacting AWS (I have Enterprise support). This was the result: Unfortunately, moving DB instance subnet group to another subnet group ...
  • 1,110
25 votes
Accepted

How do I link a security group to my AWS RDS instance

When your RDS instance is not in a VPC, then your RDS instance is associated with an RDS security group. Those security groups are controlled by the "Security Groups" section in the RDS console. From ...
  • 9,864
20 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.
  • 309
18 votes

unable to connect to public postgresql rds instance

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: Have to set the IP range to ...
14 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 ...
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 ...
11 votes
Accepted

How to connect to an AWS RDS database (deployed in VPC) with an SQL client?

One solution (but not the only solution!) is to use what's called a Bastion Host. A Bastion Host is an ultra-low-powered server that sits in your public subnet and is the only server that allows ...
11 votes

Is RDS really *the* one stop shop solution?

Note: this became kind of a long answer, so I tried to structure it so you could just read the bold text and still come away with the most important points. It's about cost. It's always about cost. ...
  • 12.9k
11 votes

What is the latency threshold for running a Terminal Server (RDS) over the WAN?

I feel like this is sort of subjective, as some users won't be happy unless the latency is just like a local desktop experience, and other users will be happy and not complain even if latency is 300ms....
  • 55.2k
11 votes
Accepted

What is the latency threshold for running a Terminal Server (RDS) over the WAN?

I have several thousand folks around the globe that connect and use accounting / office software daily. As long as their response times are under 300ms we don't get complaints but ymmv. As proof of ...
  • 15.5k
11 votes
Accepted

AWS RDS MySQL Slowing down over time

T2 and T3 instances (incl db.t2 db.t3 instances) use CPU Credit system. When the instance is idle it accumulates CPU Credits that it can then use to run faster for short periods of time - Burst ...
  • 24.2k
10 votes

AWS RDS MySQL Slowing down over time

Single-row INSERTs are 10 times as slow as 100-row INSERTs or LOAD DATA. UUIDs are slow, especially when the table gets large. UNIQUE indexes need to be checked before finishing an iNSERT. Non-...
  • 2,183
9 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 ...
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';
7 votes

Installing RDS on Windows Server 2012 without AD

Actually, one can install RDSH on Windows Server 2012 in a Workgroup environment. This configuration is appropriate when there is only one server on the network and it will provide desktop sessions ...
7 votes

How do you recover you RDS master user username?

Here is the command that you can use to get the master username of your RDS: aws --profile=prod rds describe-db-instances --region us-east-1 --db-instance-identifier YOUR-RDS-IDENTIFIER-HERE ...
7 votes

unable to connect to public postgresql rds instance

I had similar issue while connecting to postgres . Even though i had publically access true , i was not able to connect. I added one rule inbound rule in security group and now it is working ...
7 votes
Accepted

Can't add RDS database to Elastic Beanstalk environment

I'm new to AWS and had the same problem when trying to create and add a new database from the Elastic Bean Management Console. It was fixed after adding the AWSServiceRoleForRDS - role in IAM. Go to ...
  • 86
7 votes

AWS RDS MySQL Slowing down over time

Each time you commit a transaction index(es) need to be updated. The complexity of updating an index is related to the number of rows in the table, so as the number of rows increases, the index ...
  • 1,405
6 votes

Prevent local admins from shutting down RDS server

You can't effectively deny rights to local administrators, since regardless of what GPO you apply, they can always override it at least temporarily by editing the registry. They can also remove the ...
  • 25.1k
6 votes
Accepted

Track what is causing AWS RDS to use insanely high bandwidth

You should always use the private IP addresses to communicate between your various infrastructure components (RDS, ElastiCache, whatever). If you use the public IP address, then you will be billed for ...
6 votes
Accepted

How to improve AWS RDS Performance - Heavy read write updates

I'm going to turn my comments above into an answer. T2 instances only get a fraction of a CPU - 10% for a t2.micro, 40% for a t2.medium. You get CPU credits that build up, but once you use them you ...
  • 31.1k
6 votes
Accepted

High Postgres-RDS CPU usage after migration

We fixed this ourselves: The problem was, we didn't shut down our background service, which made several transactions while updating our software and the db. These transactions polluted the database. ...
  • 688
6 votes
Accepted

Can I add database to AWS RDS MySQL without creating new instance?

Sure, login with the master user / password credentials that you used when creating the instance and then create the database: $ mysql -u{MasterUser} -p{MasterPassword} -hmysql–instance1.123456789012....
  • 24.2k
6 votes
Accepted

AWS: Website with multiple DB instances

With more information about what you're trying to achieve and why we might be able to help more. Read Replicas You can create multiple RDS Read Replicas, then offload some of the database traffic to ...
  • 31.1k
5 votes
Accepted

Windows 2012 RDS Server asking for Licensing Mode when it's already set?

I have actually ran into this on a couple of servers running 2012 R2 recently and this solved it. Must be a 'feature'. http://www.tbngconsulting.com/blog/bid/404182/Licensing-mode-for-the-Remote-...

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