Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

25
votes
4answers
25k views

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 ...
19
votes
2answers
1k views

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 ...
16
votes
1answer
10k views

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 ...
12
votes
3answers
6k views

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 ...
11
votes
3answers
21k views

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, ...
11
votes
2answers
3k views

Access Amazon EC2 RDS instance from inside VPC

I have an Amazon RDS instance set up in the 'classic' EC2 (no VPC.) I also have a VPC set up that holds our newer, migrated applications and such. However, it would seem that there is no way to ...
9
votes
3answers
10k views

AWS RDS connection count

I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that ...
9
votes
2answers
2k views

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 ...
8
votes
2answers
8k views

First attempt to migrate EC2 MySQL to Amazon RDS no going well - SUPER privileges

I've been trying to move an existing db from MySQL running on EC2 to a new Amazon RDS instance (an experiment to see if we can move across). So far, it's not going well. I'm stuck at the initial ...
7
votes
2answers
6k views

Downtime for increasing 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 http://docs.aws.amazon.com/AmazonRDS/latest/...
7
votes
4answers
4k views

Ways to auto scale MySQL servers?

I run a site which has high traffic surges and because of that auto scaling solutions is very profitable for this case. Currently the web server is able to horizontally auto scale but the bottleneck ...
7
votes
5answers
7k views

AWS: Multi-region setup using single RDS instance

I'm trying to scale our web application (PHP, MySQL, memcache) in a multi-region scheme. Currently we are using a setup with two EC2 instances behind an ELB and an RDS instance, all of them in US-EAST ...
7
votes
2answers
4k views

RDS Replication across regions

We are using Amazon AWS for our web services but given the recent instabilities in their infrastructure, we are trying to figure out how to run our application across multiple regions for additional ...
6
votes
2answers
8k views

Amazon RDS Instances: db.m1.large vs db.m3.large

Recently, Amazon announced new instance types for RDS. Currently, we are running db.m1.large, and it looks like the new db.m3.large is comparable but cheaper. Before moving these over, I wanted to ...
6
votes
2answers
651 views

Does Amazon EC2 and RDS have ECC memory?

I know that Amazon's Cluster GPU Instances have ECC memory as mentioned on their blog but there's no mention of other instance types. There's a forum post from back in 2007 that went unanswered. Does ...
6
votes
1answer
3k views

Unable to connect to RDS instance from outside VPC (ERROR 2003 (HY000) Can't connect to MySQL Server)

I've created a VPC, and inside it an RDS instance. The RDS instance is publicly accessible and its settings are as follows: RDS settings The security group attached to the RDS instance accepts all ...
6
votes
2answers
8k views

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?
6
votes
2answers
6k views

AWS RDS MySQL / Slow Query Log

I'm trying to analyze slow queries on my system and I read that I should enable the "Slow Query Log'. I curious how I can I view this log when I'm using an instance of MySQL hosted on Amazon Web ...
6
votes
2answers
3k views

Amazon RDS: What are IO Requests?

I have an RDS instance that is costing me a lot of money. From my account activity on amazon I see that the instance has had about 800,000,000 IO requests over the past 7 days. To give you a little ...
6
votes
1answer
9k views

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 ...
6
votes
1answer
3k views

Does Amazon RDS support multiple databases per instance?

Title says it all... does it support multiple databases, or do I have to create a new instance for each database?
6
votes
2answers
3k views

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

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
6
votes
2answers
677 views

Strategy for maintaining Amazon RDS instance on prod vs development

How do you folks manage your Amazon RDS instances? In production I obviously want to use Amazon RDS with a master-slave replication setup going. Unfortunately this incurs substantial costs to bring ...
5
votes
1answer
2k views

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 ...
5
votes
1answer
1k views

On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?

I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
5
votes
2answers
11k views

How to create a local backup of a remote Amazon RDS MySQL database?

How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be ...
5
votes
3answers
3k views

How do a I edit .conf file for a postgres AWS RDS?

I would like to alter pg_hba.conf in my postgres RDS instance so that I can use cert authentication. I have found the Parameters Group manager in the RDS which allows me to alter parameters but it ...
5
votes
1answer
2k views

AWS RDS MySQL remote connection extremely slow

I have a site hosted on AWS EC2 (Elastic Beanstalk), with a MySQL database hosted on AWS RDS. Everything works fine on the production server, fast and all. However when I try to connect remotely from ...
5
votes
1answer
606 views

MySQL transaction issue with Django and Amazon RDS

I'm having a problem with a MySQL 5.5 database instance running on Amazon RDS. Periodically (once every couple of days) a transaction will fail to complete and appears to leave the tables locked. ...
5
votes
3answers
6k views

How do you transfer AWS RDS snap shot to a different AWS account

I have an RDS database that I need to transfer a snapshot of to another AWS account. I understand there are issues being able to do this between availability zones so I'm really unsure if this is ...
4
votes
1answer
6k views

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 ...
4
votes
1answer
6k views

Amazon AWS EC2 and RDS: How To Increase MySQL Query Cache?

I tried to find information about this, but can't find anywhere. The only one that I could find was http://survivalguides.wordpress.com/2012/07/11/change-the-query-cache-size-amazon-aws-rds/ but it ...
4
votes
1answer
3k views

How to move RDS database to different VPC

I didn't select a VPC when creating a MySQL RDS database, so it created it inside an auto-generated "default" VPC. I'm now unable to add it to any of my pre-defined security groups, or access it from ...
4
votes
1answer
1k views

How do I access and use an AWS RDS reserved instance?

I've set up several AWS RDS on-demand instances. Each time, the process was the same, and it included selecting instance type, capacity, storage, etc. When I'm done, and click on the instance icon, I ...
4
votes
1answer
706 views

Amazon AWS VPC Performance Advantages

We have a simple setup that consists of... 1 EC Instance for HTTP/PHP requests 1 RDS Instance for our Database requests Currently our two servers do not use VPC to communicate. I was wondering if ...
4
votes
2answers
5k views

AWS EC2 dns resolution diagnostic

I am using EC2 instances with amazon linux installed (with amazon dns server settings, which comes from DHCP), as well as an RDS database. The EC2 instances are behind ELB and get high traffic. The ...
4
votes
1answer
138 views

AWS RDS keeps backing up my server on creation

I am using Amazon CloudFormation to create a Stack with EC2 and RDS (Postgres 9.4.4, 5gb, db.m1.small). The RDS instance initiates a backup as soon as it starts. How can I stop RDS from backing it up ...
4
votes
2answers
389 views

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our ...
4
votes
1answer
9k views

Amazon: How do I know if I need Provisioned IOPS?

We recently moved to Amazon Web Servers and are still learning our way around. Our EC2 Web instance and our RDS MySQL instance (right now we only have 1 of each) seem to be chugging along okay. But I ...
4
votes
1answer
168 views

AWS ELB Latency issue

I have two c3.2xlarge EC2 machines with Ubuntu environment both in us-west-2a AZ. Both contains same code with mySQL database from AWS RDS (db.r3.2xlarge). Both instances are added to an ELB. Both has ...
4
votes
1answer
968 views

What is the best JDBC connection URI for AWS RDS instances?

When using an Amazon Web Services RDS instance from a Java application, what is the best JDBC connection string? It should tolerate the instance falling over to the standby. AWS handles flipping the ...
4
votes
3answers
2k views

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure ...
4
votes
1answer
165 views

If you can't change the RDS endpoint of an AWS Beanstalk instance, how do you do a blue/green deployment?

From what I can tell, one can't change the Amazon RDS (RDS) endpoint of an existing Elastic Beanstalk (EB) instance? If that is the case, than you can't have your code deployed to a stage server, ...
4
votes
0answers
411 views

TCP congestion collapse

I am experiencing suboptimal performance on an EC2 instance connecting to an RDS instance. This particular instance was built before VPC's existed, so all the traffic is flowing through a single ...
4
votes
1answer
317 views

EC2 cannot connect to RDS on VPC. Subnet issues?

I was able to deploy our .NET app using the AWS toolkit for Visual Studio. I set up the RDS database manually (MySQL) and deployed the app using elastic beanstalk (set up on VPC). The issue was that ...
4
votes
0answers
253 views

Bugzilla extremely slow on EC2, RDS PostgreSQL

The Problem I have installed Bugzilla on an EC2 instance, using PostgreSQL RDS as my database. After entering a few dozen bugs, Bugzilla became unbelievable slow, and I get a lot of timeouts. ...
3
votes
1answer
3k views

Public Amazon RDS database?

Is there any way to add a wildcard security group to Amazon RDS? I'm trying to connect from an EC2 under the same account, but had no luck with the security groups. So I'm resorting to just opening ...
3
votes
1answer
3k views

What happens when RDS freeable memory runs out?

We have a rather large mysql instance on RDS and the freeable memory is starting to get low (<1GB) in the last 24 hours. What will happen if we reach 0 freeable memory? Does that mean all memory ...
3
votes
2answers
4k views

How can I setup a VPN for remote users to connect to a AWS RDS server?

I have remote developers that travel and have constantly changing IP addresses. I would like them to be able to connect to a VPN running on a instance on EC2. Once they are connected to the VPN with a ...
3
votes
3answers
1k views

I/O intensive MySql server on Amazon AWS

We recently moved from a traditional Data Center to cloud computing on AWS. We are developing a product in partnership with another company, and we need to create a database server for the product we'...