Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

3
votes
1answer
276 views

Is it possible to backup an Amazon RDS database to another service?

I moved my site's database to RDS a few months ago. At the time, I finally decided I was ready to have a dedicated database server, and during the process of setting one up on EC2, I discovered RDS. ...
0
votes
2answers
2k views

Easy GUI way to auto scale EC2 and RDS: aws console, scalr, ylastic…?

I am managing all my instances with the AWS Management Console (the GUI web console) but now I want to use Auto Scale and it seems that this can not be done with that console. Yes, there is CloudWatch ...
0
votes
1answer
322 views

Open source alternatives to Amazon RDS for the data center?

I'm looking to for a technology that is similar to Amazon RDS, where the engine (ie: WS management, setting up, operating, HA, backups, point in time recovery, scale, etc.) can be deployed in your own ...
6
votes
2answers
388 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 ...
0
votes
1answer
301 views

Show warnings from mysqlimport

I'm running a job from a Linux box to an Amazon RDS (MySQL) that pumps in about 1GB of data via mysqlimport. It runs flawlessly, however, when I attempt the exact same command with windows I get ...
4
votes
2answers
3k 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 ...
2
votes
2answers
3k 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 ...
2
votes
1answer
304 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
234 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
545 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
507 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
240 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
3k 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
120 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?
10
votes
3answers
7k 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
308 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
378 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
431 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 ...
5
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?
10
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
770 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 ...