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
15
votes
3 answers

How do a I edit .conf file for a postgres AWS RDS?

I would like to alter pg_hba.conf in my postgres RDS instance so that I can use cert authentication. I have found the Parameters Group manager in the RDS which allows me to alter parameters but it just references a path for pg_hba.conf. It doesn't…
Steven Noble
  • 383
  • 1
  • 2
  • 12
15
votes
3 answers

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter database 'Morningstar', the database does not exist,…
Scott Munro
  • 263
  • 1
  • 2
  • 8
15
votes
2 answers

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 used to restore to a new database anywhere, on any…
djangofan
  • 4,182
  • 10
  • 46
  • 59
13
votes
3 answers

Unable to connect to RDS instance from outside VPC (ERROR 2003 (HY000) Can't connect to MySQL Server)

I've created a VPC, and inside it an RDS instance. The RDS instance is publicly accessible and its settings are as follows: RDS settings The security group attached to the RDS instance accepts all traffic: All of my network ACLs accept all…
dazedviper
  • 232
  • 1
  • 2
  • 6
12
votes
2 answers

How do I access and use an AWS RDS reserved instance?

I've set up several AWS RDS on-demand instances. Each time, the process was the same, and it included selecting instance type, capacity, storage, etc. When I'm done, and click on the instance icon, I get the end point details, DB name, user name,…
EastsideDev
  • 333
  • 3
  • 13
12
votes
2 answers

First attempt to migrate EC2 MySQL to Amazon RDS no going well - SUPER privileges

I've been trying to move an existing db from MySQL running on EC2 to a new Amazon RDS instance (an experiment to see if we can move across). So far, it's not going well. I'm stuck at the initial import before setting up replication (instructions…
dsl101
  • 433
  • 1
  • 8
  • 14
11
votes
1 answer

Does RDS in private subnet inside AWS VPC need a NAT instance/gateway?

I have hosted an AWS RDS inside the private subnet of the VPC. While creating the VPC with public and private subnets, I had to create a NAT instance. I know NAT instance is mainly for private instances to connect to the internet. Is the NAT…
Neron Joseph
  • 287
  • 1
  • 5
  • 10
11
votes
3 answers

AWS CIDR is not within the CIDR ranges of VPC

Right now i have a public subnet : CIDR 10.0.0.0/24 I want to add a new subnet on my current vpc to be able to use RDS service. When i try to add a new subnet with CIDR, i got this message : 10.0.1.0/24 CIDR is not within the CIDR ranges of VPC My…
TheShun
  • 213
  • 1
  • 2
  • 5
11
votes
3 answers

AWS RDS MySQL vs Aurora

I read everywhere that Aurora is more performant (claims etc). If that's the case and cost differences are ignored, what would be the reason for any one to use RDS MySQL? What are the technical differences between the two which would make someone…
Vijay Dev
  • 213
  • 3
  • 7
11
votes
3 answers

How to move RDS database to different VPC

I didn't select a VPC when creating a MySQL RDS database, so it created it inside an auto-generated "default" VPC. I'm now unable to add it to any of my pre-defined security groups, or access it from instances in my existing VPC. The obvious…
Cerin
  • 3,600
  • 19
  • 61
  • 79
11
votes
2 answers

Access Amazon EC2 RDS instance from inside VPC

I have an Amazon RDS instance set up in the 'classic' EC2 (no VPC.) I also have a VPC set up that holds our newer, migrated applications and such. However, it would seem that there is no way to specify a combination of either CIDR or EC2 security…
Sam Halicke
  • 6,222
  • 1
  • 25
  • 35
11
votes
5 answers

AWS: Multi-region setup using single RDS instance

I'm trying to scale our web application (PHP, MySQL, memcache) in a multi-region scheme. Currently we are using a setup with two EC2 instances behind an ELB and an RDS instance, all of them in US-EAST (Virginia) region. We would like to have a…
Ion
  • 278
  • 2
  • 3
  • 10
10
votes
2 answers

How to see what is my Amazon rds password

Hi I think it is possible to rest Amazon rds password, I mean db password. Is it called master password. I mean RDS-PASAWORD. But any way to see current rds password. I searched internet for a long time and can't find a way to do it?
Fun Media
  • 121
  • 1
  • 1
  • 6
10
votes
1 answer

Amazon RDS On-Demand DB instance to Reserved instance

We currently have 3 on-demand rds instances running and we're planning to move each instances to reserved ones. Upon purchase of the reserved instances, what migration steps should be done to move from the on-demand to the reserved? Can a snapshot…
Bryan CS
  • 250
  • 3
  • 12
9
votes
5 answers

Unknown Database when trying to connect to an AWS RDS instance

I created a MySQL RDS instance, however, when I try to connect without writing the database name, it connects but does not allow me to create any tables. When I do write the name, the connection fails and I don't know why. Error I have my…
Eduardo Andrés Castillo Perera
  • 113
  • 1
  • 1
  • 4
1
2
3
…
36 37