Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

0
votes
1answer
41 views

20% CPU usage by RDS instance when idle

I have brought up a db.t1.micro PostgreSQL instance in us-east-1 region. It's single availability zone no backups not in a security group that's reachable from the outside world For some reason ...
0
votes
1answer
97 views

Forcing an eni change when changing subnets in a rds subnet group

I'm looking at changing the subnets that our RDS instances are currently in. The subnet group currently has /20 for both a & c zones. I've created new /22 subnets for a & c and associated ...
1
vote
1answer
38 views

AWS Reducing RDS Instance size causes job to run longer

I recently reduced the size of one of our RDS instances from an r3.xlarge to an r3.large. Under usual load this is absolutely fine for this instance. We do however have a morning job that runs that is ...
0
votes
1answer
83 views

Demystifying MySQL Read/Write Ratio on RDS

I am in the process of upgrading/selecting resources for an application powered by a MySQL database running on Amazon RDS. I am considering introducing read replicas and some other strategies to ...
0
votes
1answer
4k views

Assign Elastic IP to RDS instance

Is it possible to assign a fixed Elastic IP to an AWS RDS database instance? If I create a new database instance, the instance gets a random endpoint like ...
3
votes
0answers
207 views

AWS: RDS + CloudFormation – VPC peering

So here's my situation: We are a young startup scaling up and we decided to give Mesosphere DCOS Community edition a try. The community edition deploys a stack of Masters, Slaves and LB's over AWS ...
0
votes
1answer
89 views

Can't establish a command line connection to RDS MySQL from EC2

I have imported a CentOS VM to EC2, it is running correctly. I created a MySQL RDS. They are both apparently in the same VPC. From the shell in my VM I tried this command: mysql -u root -h ...
1
vote
0answers
44 views

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 ...
1
vote
0answers
229 views

AWS DynamoDB Cost efficiency

I have to move a business application into the cloud, therefore cost is one of my biggest concerns. DynamoDB seems to be a good option, while a big part of our data is able to migrate from ...
-2
votes
2answers
140 views

amazon aws, rds

just need a quick info on two questions but very related. 1 if we use rds on amazon aws, what happens if some of the machines rds is running on crash? i mean what happens with the data? is it gone? ...
1
vote
1answer
91 views

AWS Network ACL/Security groups and RDS access

Just want to clarify a few settings on a new Amazon setup I'm creating. I have followed a number of guides and everything appears to be working and secure, I'd just really appreciate if someone who is ...
6
votes
2answers
8k views

How do you recover you RDS master user username?

Resetting the RDS master user's password is simple enough, but how do you find your master users username?
0
votes
2answers
1k views

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

Amazon EC2 and Amazon RDS in Same Network

We have deployed our application in EC2 instance and our database is in RDS which is db.m2.2xlarge. I see some minor slowness in our application when compare to our QA environment where has both ...
0
votes
0answers
255 views

AWS RDS MySQL DB unable to connect in MySQL workbench and could not connect using telnet

I am using default VPC and created RDS MySQL instance (Publicly Accessible: Yes) with newly created db security group. I have given Inbound/Outbound rules as All Traffic, ALL, ALL, and Source = ...
1
vote
1answer
230 views

Mysql 5.6 client is unable show UTF8 characters

Mysql databases are hosted on AWS RDS Mysql 5.6 On one of the EC2 Cent OS 6.5 instance, I had Mysql Client 5.1. I used it to execute SELECT queries over the RDS-Mysql. There is one particular query ...
1
vote
2answers
3k views

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 ...
7
votes
2answers
6k views

Downtime for increasing RDS storage?

I am looking to increase storage of two RDS instances (just the storage space allocated, not the instance type or other parameters). The documentation at ...
0
votes
0answers
219 views

Memory usage on db.t2.micro

I just brought up an RDS-MSSQL instance which this page says has .6GB of memory. However, the console shows this: I haven't added any databases, but the Memory Threshold looks like its peaking at ...
12
votes
3answers
6k views

How to associate an existing RDS instance to an Elastic Beanstalk environment?

I have created my RDS instance before creating my Elastic Beanstalk environment. The two are working together with no problem, but I'd like them to be linked together, and have the RDS parameters ...
0
votes
1answer
167 views

Amazon RDS CPU is about 55-65% after optimizing some Mysql tables

I was having high RAM consumption and, looking for a solution, I executed the script mysqltunner to monitor possible optimizations in the Mysql database. Its first advice was I had to run OPTIMIZE ...
1
vote
1answer
65 views

Connection / Tunnel to AWS RDS from EC2

I'm working on a website hosted in a VPC on AWS. Yesterday, we moved the mysql server from a EC2 instance to a RDS instance to allow the mysql server to perform better. So, before, when I wanted to ...
0
votes
1answer
92 views

named-sdb (bind) can't resolve mysql hostname in chroot

When running bind in chroot, the mysql dlz driver cannot resolve the hostname of the mysql server (rds). Using amazon ami (centos based) in VPC. Aug 25 10:22:27 paper named-sdb[6812]: Loading 'Mysql ...
1
vote
1answer
215 views

Install PostgreSQL pgAdmin Tools on Amazon RDS

Is there a way to install the optional adminpack (contrib) tools for utilizing pgAdmin on an Amazon RDS PostgreSQL instance? My gut says no because of this question. When you don't have the tools ...
0
votes
1answer
663 views

pgpool2 parallel mode: Non-superusers must provide a password in the connection string

I have two AWS RDS postgres nodes backing a parallel mode pgpool setup on EC2. After using pgbench to populate test tables, I get odd behavior from test queries. Any query that uses a function ...
0
votes
2answers
2k views

Can't connect from EC2 to RDS via PHP. I can directly thought

I've set up an EC2 instance it has mysql and php-mysql installed (not mysql-server). I've set up an RDS instance and set the security group to the EC2 instance. I can connect via the command line ...
2
votes
1answer
7k views

Connecting RDS database from out side of VPC

My RDS database located in VPC. It's a Multi AZ database so that it's located on two VPC subnet. How could I connect it from outside of VPC?
1
vote
1answer
290 views

RDS to EC2 mysql replication

I would like to create a RDS mysql and to replicate it to an EC2 server so the DB will be local and thus the query time will be faster (the EC2 is a web server). According to the second paragraph here ...
0
votes
0answers
28 views

Amazon RDS Connection Denied via additional user

I just created a new database and user grant all privileges on that user. I don't know what's happening I can't connect by using that user always "Access Denied". But I change to RDS master user it's ...
2
votes
1answer
123 views

Are IOPS capped at 3000 for AWS Oracle RDS with General Purpose (SSD) (gp2)?

Documentation at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html says This storage type can deliver single-digit millisecond latencies, with a base performance of 3 IOPS/GB ...
5
votes
2answers
11k views

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 ...
1
vote
0answers
95 views

Elastic Beanstalk Test Environment use copy of production data

I have 3 environments using Elastic Beanstalk - Prod, Test, Dev. I want to use a copy of production database in my Test environment. It seems there's no easy way to "just use a different database". ...
5
votes
1answer
2k views

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 ...
0
votes
0answers
124 views

AWS RDS subnet/az requirement doesn't work with virtual UTM

Background: I want to put an AWS RDS instance into a VPC that has a virtual UTM as its internet gateway. Virtual UTM is an normal EC2 instance with 2 network connections, one internal, one external. ...
5
votes
3answers
3k views

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 ...
2
votes
2answers
11k views

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 ...
0
votes
1answer
216 views

On a pfsense router how would I redirect one IP to another?

I have a poorly made piece of software at work that only asks for a IP when connecting and cant use URL and I cant get a static IP for the database its connecting to (Amazon RDS). I was wondering if ...
2
votes
2answers
1k views

Can Amazon Elastic Beanstalk auto-scale Amazon RDS?

I'm planning to run a PHP/MySQL application using Amazon Elastic Beanstalk. In the settings I can define when it should launch new instances automatically (Auto-Scaling). However, as I understand ...
0
votes
1answer
563 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
0
votes
0answers
435 views

Create RDS Read-Replicate in a separate region using VPC

We have a MySQL RDS instance in a VPC, and want to setup a read-replicata in another region. Unfortunately since our RDS instance is in a VPC, we don't appear to have the option to replicate across ...
25
votes
4answers
24k views

Why can't I connect to Amazon RDS after setting it up?

So, I just created the Amazon RDS account. And I started an instance of database. The "endpoint" is: abcw3n-prod.cbmbuiv8aakk.us-east-1.rds.amazonaws.com Great! Now I try to connect to it from one ...
6
votes
2answers
8k views

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 ...
0
votes
1answer
467 views

AWS RDS CLI: AccessDenied on CreateDBSnapshot

I want to use the AWS RDS command line tool to create a snapshot of my database my-database using create-db-snapshot. I have created a special backup role in IAM with a policy that allows me to ...
4
votes
3answers
2k views

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure ...
16
votes
1answer
10k views

What is “freeable memory”?

Amazon RDS has a metric for 'freeable memory'. It appears to go up & down in a sawtooth pattern. This leads me to believe that it's memory that is being used by MySQL for caching and that when ...
-1
votes
1answer
219 views

What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license? [duplicate]

I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware Microsoft Volume ...
1
vote
2answers
178 views

Amazon RDS on solid state drives

I am planning to design a cloud based application which leverages the MySQL provided using Amazon RDS. I wish to setup read replicas for the data which I have obtained on solid state drives. Does ...
-1
votes
1answer
110 views

Why the latency increases on highload? [closed]

We have a system built on AWS. We use Beanstalk, we have autoscaling, our database (mysql) is hosted on RDS. We use apache and php. We wanted to test our system on highload. So, we chose large ...
6
votes
2answers
5k views

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

What is the best way to share an AWS RDS instance across multiple Stacks?

I'd like to create one larger RDS instance and share it across OpsWorks stacks so I can pool the database resources across multiple applications. Here is a reference to the OpsWorks docs for ...