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
7
votes
2 answers

What is the "Automated backups" tab in AWS RDS console on Aurora engines?

I have 7 day backups enabled on my RDS cluster. I can visit the "Snapshots" tab and see 8 snapshots (today + previous 7 days). I can restore to a specific point in time, all works well. The next tab down, Automated backups, is confusing. When I…
Charlie Schliesser
  • 440
  • 1
  • 4
  • 12
7
votes
1 answer

How to check via aws cli if a specific rds instance exists?

I want my bash script to detect, if an AWS RDS instance with a specific name exists already. This is what I tried: #!/usr/bin/env bash DBINSTANCEIDENTIFIER=greatdb EXISTINGINSTANCE=$(aws rds describe-db-instances \ …
hey
  • 327
  • 1
  • 5
  • 14
7
votes
1 answer

Download Amazon-RDS (SQL-Server) Backup or Snapshot

I want to download one of my backups and restore it on my laptop for testing a web app locally. I'm using SQL Express. This is similar to this MySQL question. Can I just run a backup using T-SQL? And then somehow direct it to S3?
NealWalters
  • 1,333
  • 8
  • 19
  • 39
7
votes
1 answer

Connection timed out on new AWS RDS instances - can connect to older, almost identical RDS with no issue

I have two RDS instances, both hosted in the same VPC, and on the same subnet. Both have the same security group applied. Both are the same size, encryption disabled, basically exactly the same other than the instance name and table name. However, I…
MrDuk
  • 865
  • 2
  • 10
  • 18
7
votes
5 answers

How to calculate current IOPS usage and IOPS credit count and graph on AWS RDS

I have a running Mysql db.m3.medium RDS instance at AWS, running with 20GB SSD as in: RDS machine description Last hour write and read operations went as following: Disk operations It looks like max(write)+max(read) operations total around…
Guilherme Silveira
  • 71
  • 1
  • 1
  • 4
7
votes
2 answers

AWS RDS MySQL / Slow Query Log

I'm trying to analyze slow queries on my system and I read that I should enable the "Slow Query Log'. I curious how I can I view this log when I'm using an instance of MySQL hosted on Amazon Web Service's RDS.
Philip Isaacs
  • 113
  • 1
  • 1
  • 9
7
votes
2 answers

Does Amazon EC2 and RDS have ECC memory?

I know that Amazon's Cluster GPU Instances have ECC memory as mentioned on their blog but there's no mention of other instance types. There's a forum post from back in 2007 that went unanswered. Does anyone know if they're running ECC?
Sean Bannister
  • 751
  • 8
  • 19
7
votes
1 answer

Does an Amazon RDS endpoint change in the event of instance failure?

I would like to know if an Amazon RDS endpoint ever changes when a DB instance crashes and is brought back up. I want to setup 2 EC2 instances (additional EC2 instances may be spun up depending on traffic) hosting a Django app pointing to an RDS…
Binary Maze
  • 233
  • 5
  • 11
7
votes
2 answers

RDS Replication across regions

We are using Amazon AWS for our web services but given the recent instabilities in their infrastructure, we are trying to figure out how to run our application across multiple regions for additional redundancy. Ideally, we would run our entire app…
Bryan Migliorisi
  • 253
  • 3
  • 7
7
votes
2 answers

Strategy for maintaining Amazon RDS instance on prod vs development

How do you folks manage your Amazon RDS instances? In production I obviously want to use Amazon RDS with a master-slave replication setup going. Unfortunately this incurs substantial costs to bring something similar into a development/qa…
imaginative
  • 1,971
  • 10
  • 32
  • 48
7
votes
1 answer

AWS: What is the difference between Burst Balance and EBS IO Balance metrics?

AWS Docs describe Burst Balance and EEBS IO Balance in the following way: BurstBalance The percent of General Purpose SSD (gp2) burst-bucket I/O credits available. EBSIOBalance% The percentage of I/O credits remaining in the burst bucket of your…
Zillo
  • 81
  • 1
  • 4
7
votes
1 answer

does / should RDS have egress access outside of VPC?

I've done a little digging but struggled to come up with a definitive answer, for RDS should/do the require any form of external access i.e outside of VPC for server updates, ntp etc? Assuming it's not ingress but egress only i.e connections formed…
Matt James
  • 93
  • 4
6
votes
2 answers

Copying over indexes with AWS DMS

I need to use AWS DMS to copy one MySQL RDS instance to the other. I've been tinkering about have set it all up and I've run a successful migration. The issue is it doesn't create indexes. I understand the reason behind this, obviously it's much…
James
  • 133
  • 2
  • 8
6
votes
3 answers

How do I view the RDS_ prefixed environment variables in AWS ElasticBeanstalk?

If you set up RDS with ElasticBeanstalk how can you go into the box (via eb ssh) and view the environment variables that are set when you apply RDS to your EB Instance? Amazon automatically sets up these environment variables.…
ThomasReggi
  • 621
  • 2
  • 10
  • 25
6
votes
2 answers

How to do offsite AWS RDS PostgreSQL backups?

As a measure to mitigate against catastrophes such as a malicious entity gaining full access to our AWS account and deleting everything, I am in the process of setting up offsite backups for our production database. We use PostgreSQL on AWS RDS. We…
Olivier Lalonde
  • 753
  • 3
  • 13
  • 20
1 2 3
…
36 37