Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

11
votes
3answers
8k 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 ...
3
votes
1answer
408 views

Using Amazon RDS (or similar) as a slave

Officially, RDS instances can't be directly set up to slave non-RDS databases. My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, ...
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
1answer
1k views

How can I set up an Amazon RDS for PostgreSQL database to act as a replica to a non-RDS PostgreSQL database?

I'm trying to set up an PostgreSQL database on Amazon RDS as a replica to another PostgreSQL database that lives on a regular server. Most of the instructions I've found online require shell access so ...
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?
5
votes
2answers
5k 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 ...
2
votes
2answers
646 views

Setting the timezone in MySQL on every connection using Zend PHP

My company just recent moved our MySQL database to and instance Aamazon Web Service's RDS. The problem is the application relies on time zone information and the timezone in MySQL (under RDS) is set ...
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 ...