Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

2
votes
1answer
300 views

Scaling by moving Database to Amazon RDS

We have a situation with an Application which is hosted on a dedicated server where we are anticipating a potential surge in traffic. The major bottleneck on the app is MySQL which is heavy on read ...
0
votes
1answer
214 views

Amazon RDS instance stopped responding

We've been running a large RDS instance in production for over year without a single moment of downtime. Recently, with a bigger budget and higher stakes, we decided to convert it to a multi-AZ ...
-1
votes
1answer
509 views

How to store WHM data on remote MySQL without ssh

Is it possible to connect WHM to remote MySQL server without ssh? Thing is I am hosting WHM on Amazon EC2 and want to move all MySQL databases to Amazon RDS, but WHM by default supports connection via ...
0
votes
1answer
1k views

Update RDS db via mysqlbinlog: “you need (at least one of) the SUPER privilege(s)”

We are moving a production site to EC2/RDS Followed these instructions: http://geehwan.posterous.com/moving-a-production-mysql-database-to-amazon I have set up row-based binary logging on the ...
1
vote
2answers
503 views

RDS, scalr with EC2 or xeround for a 40GB database

We are currently preparing for a move of a reasonably high traffic web site to the cloud. We are thinking of using scalr to help us manage the whole setup especially since we dont have experience ...
2
votes
1answer
230 views

amazon RDS Security Groups Issue

We had a odd issue today related to the security groups in our RDS. All the sudden, without any changes from our end, our RDS instance's security group stopped working. No server was able to connect ...
6
votes
1answer
2k 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?
1
vote
1answer
1k views

How to Sync data from one amazon RDS to another?

Hi i am pretty new to Amazon RDS.my question how to Sync data from one amazon RDS machine to another? like taking a mysql Dump or something like that, and is it possible to Sync over multiple regions ...
1
vote
1answer
118 views

Amazon RDS: Is it possible to have more than 5 read replicas?

The FAQ seems to suggest that you can't have more than 5 replicas. Is there any workaround?
9
votes
3answers
6k 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 ...
1
vote
1answer
298 views

Setup game server using amazon web service?

I am relative new to amazon web services (aws). I would like to setup a game server for my next coming project. Basically, I just need a database(mysql) and php to connect to the database, nothing ...
0
votes
2answers
373 views

Hosting a MySQL server on Amazon Web Services

We are evaluating hosting our application on Amazon EC2 service. While I am confident that a Small instance (1.7GB RAM) will be sufficient for our web server (at this point), I am not sure about ...
0
votes
2answers
429 views

How to architect my application on AWS cloud?

I am plannig to port an e-exam app on the aws cloud. I have decided to use a ELB, EC2 instances. But i am confused on wether to use a MYSQL DB server on amazon instance or to go for amazon RDS? Also ...
3
votes
1answer
2k views

Public Amazon RDS database?

Is there anyway 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 it ...
1
vote
5answers
3k views

Can't authorize a server for Amazon RDS

We are attempting to slowly migrate a website over to AWS among other things. We decided the first thing to move was the database. We have some dedicated server with a different hosting provider. We ...
4
votes
2answers
4k 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 ...
6
votes
1answer
2k 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?
9
votes
1answer
5k views

What is “freeable memory”?

Amazon RDS has a metric for 'freeable memory'. It appears to go down in a sawtooth pattern: https://skitch.com/adamnelson/rnhpu/aws-management-console This leads me to believe that it's memory that ...
2
votes
2answers
752 views

How different is an Amazon EC2 RDS DB Instance different from the normal EC2 Instance?

How different is the Amazons RDS DB Instance different from The normal EC2 Instance other than the fact that RDS DB Instance has a Database server running on it? When an EC2 Instance goes down all ...