Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Amazon RDS (Relational Database Service) is a distributed relational database service based on popular variants, running in the cloud. Currently supported are:

  • MySQL
  • Oracle
  • SQL Server
  • PostgreSQL

Additional Documentation:

559 questions
6
votes
1 answer

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?
Ben
  • 3,880
  • 19
  • 66
  • 99
4
votes
1 answer

How to migrate snapshot to an existing database in AWS RDS

I currently have two databases, one for production environment and the other one for staging environment. I made snapshot of the production database to migrate it into the staging database. I researched about how to do that, but most of resources…
Jay
  • 189
3
votes
2 answers

Options for giving remote access to private AWS RDS Aurora cluster

We have a production database server which at the moment is not publicly accessible, has no public IP address, and sits in a private VPC subnet. At the moment it is only accessible from applications we have running on EC2's in the same VPC. We now…
user1751825
  • 395
3
votes
2 answers

How to refer to AWS RDS host name

I started an Amazon RDS instance (with Multi-Az enabled) and was provided with a host name like instance.abc123.us-west-1.rds.amazonaws.com. Will this instance's hostname ever change? Can I use this hostname directly in my applications, or should I…
simpleuser
  • 274
1
vote
0 answers

Keep getting '...is blocked because of many connection' on Amazon RDS

I'm finding that for the second time in a week I've got the '...is blocked because of many connection' issue with my Amazon RDS. From the monitor within RDS control panel I can see that I'm nowhere near the limit for max connections (it peaked at 25…
Drew
  • 111
  • 3
1
vote
1 answer

Amazon RDS connection issues

It seems that my database instance had a failover in the middle of the night and changed IP address. My webserver connects to it remotely. The IP address, which is found from Amazons DNS service that contains its internal IP, doesn't seem to have…
user144453
  • 11
1
vote
1 answer

Amazone RDS change Class or copy to new instance

I have a RDS instance and I want to change this class to a smaller class, from xlarge to large. I try to do this in console, but it doesn't work. May be it's easier to create new instance and copy old db to new. But how?
Voldemar
  • 11
0
votes
1 answer

Getting same price for RDS Reserved Instance at 1yr or 3yr

I was looking at pricing some reserved instances for one of our organisation's mssql DBs. When I head into the console the appropriate options, such as product (sqlserver-se), size (m5.xlarge), etc, Amazon is giving the same price for an upfront…
Trev
  • 103
0
votes
1 answer

Why does an RDS snapshot have storage type?

I was under the impression that the snapshots were stored on S3 and so the original instance's storage type wouldn't be relevant. So why is the storage type listed under snapshots? Is the cost of the snapshot higher for IO1 higher than SSD?
Nic Cottrell
  • 1,332
0
votes
0 answers

Connecting to AWS RDS [Warning] IP address 'xxx.xx.x.xxx' could not be resolved: Temporary failure in name resolution

I'm new to AWS and trying to connect using PHP to a test RDS like this $dbhost = 'xxxx.xxxxxxxxxxx.rds.amazonaws.com'; $dbport = 3306; $dbname = 'xxxx'; $charset = 'utf8' ; $dsn =…
PHP User
  • 99
0
votes
1 answer

RDS Memory Monitoring is almost full but nothing is happenning on the server

I don't understand how to read the Memory monitoring graph. RDS Monitoring Graph Thank you for your advices.
wanted
  • 101
0
votes
1 answer

What is the data integrity of Amazon RDS? Do I need to make automated backups to S3?

I host my most valuable data on Amazon RDS. What is the failure rate of Amazon RDS, and what provisions do they have in place for high availability and data redundancy?
chrism2671
  • 2,629
  • 10
  • 36
  • 45