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:

549 questions
6
votes
1 answer

AWS RDS Nightly Staging Database

I am trying to determine if it is possible to configure the RDS service in AWS to do the following, but have not had much luck with my Google searches. When it does its instance backup, have it automatically delete an RDS instance and spin up a new…
Jeremy Harris
  • 245
  • 4
  • 12
6
votes
4 answers

Allow access to RDS instance from EC2 instance on same VPC

I am having trouble gaining access to a MySQL RDS instance. I am trying to connect to the RDS instance from an EC2 instance. Both the RDS instance and the EC2 instance are contained within the same VPC, myVPC. I have confirmed this by checking that…
PhiloEpisteme
  • 169
  • 1
  • 2
  • 4
6
votes
0 answers

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 virtual NIC. The traffic profile is sustained around…
tcpnewb
6
votes
1 answer

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 that you can copy over a bunch of data files…
Dan Loewenherz
  • 913
  • 3
  • 10
  • 19
6
votes
2 answers

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 double check with you guys that there are no hidden…
DOOManiac
  • 791
  • 6
  • 12
  • 26
6
votes
1 answer

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 requires also following the instructions from…
user702300
  • 267
  • 1
  • 3
  • 7
6
votes
2 answers

Amazon RDS - SQL Server - Master User Privileges

I created an RDS instance with SQL Server Express Edition on it. The instance setup was all fine, and I also succeeded connecting to it. But once connected using the master user, I cannot create any database, schema or table on the server. It keeps…
Nirmal
  • 389
  • 1
  • 5
  • 15
6
votes
1 answer

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 my local machine, it sometimes gets extremely…
nute
  • 791
  • 2
  • 11
  • 22
6
votes
1 answer

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?
CatDadCode
  • 265
  • 3
  • 10
6
votes
2 answers

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 application that I use is coded with PHP. The…
Kevin Lee
  • 93
  • 1
  • 5
6
votes
3 answers

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 possible. The RDS instance is mySql. If it's not…
Webmonger
  • 203
  • 2
  • 7
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,800
  • 18
  • 65
  • 96
5
votes
1 answer

Migrating from DynamoDB to RDS

I'm considering the different options available for migrating a DynamoDB Database to RDS. The data structure makes much more sense in a relational format. There are 8 tables with around 1 million documents in each. We have worked out the mapping…
Peter Grainger
  • 163
  • 1
  • 7
5
votes
1 answer

Amazon RDS "Freeable Memory" decreasing rapidly

I have noticed recently that freeable memory on my Amazon RDS (db.m4.large instance) is decreasing rapidly. Over the past few weeks, it has come down rapidly from almost 3700 MB to 1000 MB. There hasn't been any issues with the applications though.…
Rahul
  • 53
  • 1
  • 5
5
votes
2 answers

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, stage DB, tested, then promoted to use the prod…
Ryan Fisher
  • 233
  • 1
  • 9
1 2 3
…
36 37