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
3
votes
1 answer

Possible to join an Amazon RDS SQL Server 2008 instance to a Windows Domain?

We're planning on using an Amazon RDS MS SQL Server 2008 instance in our Amazon VPC. Since we don't have access to the underlying OS for RDS, I was wondering if it's at all possible to join an RDS instance to a Windows Domain? Anyone has experience…
DanyO
  • 33
  • 3
3
votes
1 answer

Allow any ip to connect to Amazon Web Services RDS using MySQL

Is it possible to allow any IP to connect to a Amazon RDS instance using MySQL? Explaining my scenario as requested in the comments: Amazon RDS by default blocks all the incoming connections which the incoming IP is not listed in the AWS security…
Rubem Azenha
  • 695
  • 3
  • 8
  • 15
3
votes
2 answers

AWS document on number of databases allowed on an Amazon RDS instance

At the Amazon RDS FAQ there is the question "What is a database instance (DB Instance)?". The entire answer (as of mid-June 2012) is: You can think of a DB Instance as a database environment in the cloud with the compute and storage resources…
user35042
  • 2,681
  • 12
  • 34
  • 60
3
votes
1 answer

AWS - bigger EC2 instance or DB split

I am running a website of off a small EC2 instance. The memory on the instance is maxed out, mostly due to SQL server process. I am thinking about either upgrading to a medium instance or staying with a small instance, but transfering the DB to RDS…
Elad Lachmi
  • 189
  • 1
  • 11
3
votes
3 answers

I/O intensive MySql server on Amazon AWS

We recently moved from a traditional Data Center to cloud computing on AWS. We are developing a product in partnership with another company, and we need to create a database server for the product we'll release. I have been using Amazon Web Services…
rhossi
  • 33
  • 4
3
votes
0 answers

Cannot connect to MySQL on RDS (Amazon Web Services) from my laptop

I'm having some trouble connecting to a MySQL 5.1 server on an RDS instance on AWS from my laptop. The detailed description of the problem is here: https://forums.aws.amazon.com/thread.jspa?messageID=323397 In short: I have 2 MySQL servers, both…
Bruno Reis
  • 315
  • 3
  • 11
3
votes
2 answers

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg Swap Usage is 420MB. Read Latency is 0-20ms/op it…
rksprst
  • 445
  • 1
  • 6
  • 9
3
votes
1 answer

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. I've been really happy with it. The problem is…
Peter
  • 133
  • 4
3
votes
1 answer

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 else, just fetching and writing data to database. I…
moderaga
  • 79
  • 2
  • 7
3
votes
1 answer

Public Amazon RDS database?

Is there any way 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 up for the time being.
miketucker
  • 31
  • 1
  • 2
3
votes
2 answers

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 the data associated with it also vanishes(when you…
Sudheer
  • 33
  • 4
3
votes
1 answer

How to get a local mysql dump of a specific AWS RDS Snapshot

Hello I have a linux bastion host in AWS that I am able to SSH into. In the Bastion I am able to run a mysqldump command which makes a copy of an RDS instance. What I want to accomplish is being able to make a copy of a specific RDS snapshot. When I…
CodeConnoisseur
  • 133
  • 1
  • 4
3
votes
1 answer

Create Postgres index on RDS is far slower than a weaker linux host

Background: Postgres 10.9 DB runs as a docker container on the dev hosts. (t3.large, gp2 500GB storage) DB runs in RDS for staging and production. (m5.2xlarge, gp2 1TB storage) Everything works great, been like that a long time, and my db alter…
Rino Bino
  • 511
  • 5
  • 21
3
votes
1 answer

Can't upgrade RDS instance from MySQL 5.7.x to 8.0.x

I need to recover data from an old 5.6.x snapshot. With a little bit of tinkering, I managed to get the 5.6.x snapshot restored on an m3.xlarge instance (any instance type other than m3.* won't work). I then successfully upgraded from 5.6.x to the…
Zenexer
  • 521
  • 8
  • 20
2
votes
2 answers

Force SSL on AWS RDS Postgres

I've got a brand new Postgres 11 RDS instance that I can connect to with or without an SSL cert. However, I would like to ensure that we never connect to this database without SSL. So I have taken the following steps to attempt to enforce…
Oliver Lorton
  • 141
  • 1
  • 5
1 2 3
…
36 37