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

Any logs for AWS RDS auto start?

From AWS documentation Stopping an Amazon RDS DB Instance Temporarily: You can stop a DB instance for up to seven days. If you do not manually start your DB instance after seven days, your DB instance is automatically started. But I cannot find…
ronald8192
  • 171
  • 1
  • 5
2
votes
3 answers

Does anyone have a fast way to "warm up" an RDS instance created from snapshot

My understanding is that a new RDS instance will "page in" blocks from the snapshot on an as-needed basis, as is described for EC2 volumes here. This is currently causing me pain: I'm running a large query on a new test instance; it should take…
kdgregory
  • 211
  • 3
  • 7
2
votes
1 answer

AWS EC2, Apache, PHP: php_network_getaddresses: getaddrinfo failed

Running PHP 5.6 on an EC2 instance with Apache 2.4.18, I'm occasionally seeing errors in the log when trying to connect to an RDS database: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: No address associated with hostname The…
Marcus Ilgner
  • 21
  • 1
  • 7
2
votes
1 answer

MySQL connection on Amazon RDS t2.small performing very slow

I'm very new to AWS. I've created a new RDS instance t2.small by following the previous one. I've selected all options as similar with the previous one. But the new instance is performing very slow, about 5 times slower than the previous one. What…
biplob
  • 121
  • 5
2
votes
2 answers

Connect QuickSight to the private Redshift cluster

Can anyone tell me if it is possible to connect QuickSight to the Redshift cluster which is not publicly accessible? Documentation tells only this: Q: How do I connect my VPC to Amazon QuickSight? If your VPC has been set up with public…
Roman Laguta
  • 21
  • 1
  • 4
2
votes
1 answer

How can I start replication of on premise Postgres 8.4 into AWS RDS Postgres 9.x?

I wonder if you can help. I need to replicate a Postgres 8.4 database (master-slave style) from an on-premise server to an RDS instance on AWS running Postgres 9.x. I've read that Postgres > 9.0 has a nice replication mechanism, but before that…
migueldavid
  • 131
  • 4
2
votes
2 answers

Connect to RDS from EC2 instance in a different Availability Zone (AZ)

OK, so I have a VPC with three app servers and an instance of Postgres in RDS. I have a security group called 'rds-staging' that allows inbound connections on port 5432 from a security group called 'app-elb-staging'. 'app-elb-staging' is the…
Codebeef
  • 1,449
  • 4
  • 19
  • 20
2
votes
1 answer

Is it possible to connect to a non publicly available RDS instance from SequelPro?

I have a MySql AWS RDS instance inside a VPC. I was wondering if it is possible to make the RDS instance NOT publicly available, but still be able to somehow connect to the DB via SequelPro or Workbench. Thanks!
Michalis Antoniou
  • 21
  • 1
2
votes
1 answer

How to redirect database traffic to a new master on RDS after promoting a read replica?

A lot of RDS's documentation about read replicas contains a magical step along the lines of "direct database traffic to the new master." For instance, their instructions on implementing failure recovery say: In the event of a failure you would…
Mark Amery
  • 727
  • 1
  • 8
  • 25
2
votes
2 answers

Upgrade RDS to new instance type?

We have a db.m3.large RDS MySQL instance in us-west-2 w/ multi-AZ that we need to upgrade to a larger instance type (and would like to move to current generation, as well). However, for the last 2 days we can't upgrade to either db.m4.xlarge nor…
denishaskin
  • 273
  • 2
  • 10
2
votes
1 answer

Why is there a delay with executing queries on my RDS instance

I have an application running on an ec2 m3 instance and mysql running on an dRDS instance. They're both in the same, region, VPC hwoever they appear to be in different availability Zones. The issue is that running queries can be excruciatingly slow…
Ali
  • 279
  • 1
  • 3
  • 14
2
votes
1 answer

What happens when we remove the SnapshotIdentifier from our Cloudformation config

When we spun up our Cloudformation stack, we restored our DBCluster from a snapshot. We are now in the process of updating our stack. What will Cloudformation do with our DBCluster if we remove the SnapshotIdentifier key from our config? Let's…
Thomas K
  • 155
  • 5
2
votes
1 answer

how to identify and report bad RDS hardware

Recently we [finally] migrated all of our production hardware from the deprecated default networking into VPCs including EC2 and RDS nodes. Everything went pretty well except when we started to run performance tests in production and noticed quite…
Gray
  • 579
  • 1
  • 5
  • 17
2
votes
1 answer

Amazon RDS and Auto-Scale EBS: Security Groups

I have the following setup on Amazon AWS: An Auto-Scaling Group An ELB An RDS database Everything is in the default VPC The only thing about this setup that I don't quite understand yet relates to the security rules. For the RDS instance, I want…
bobsoap
  • 161
  • 8
2
votes
0 answers

Connect to RDS from EC2 - different AZ

I have set up a RDS instance with Multi-AZ support. It ended up in eu-west-1a. It is setup with "Publically available = YES" I have a EC2 instance in eu-west-1c, from which I want to access the RDS database. I do this to test connectivity: nc -zv …
Markus Johansson
  • 151
  • 1
  • 3
1 2 3
…
36 37