Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

2
votes
1answer
400 views

Low transfer rates on Amazon's EC2

I have a question re transfer rates on Amazons EC2. Basically I am evaluating a move to the Amazon stack of services, however wanted to benchmark it against our current setup first. My setup is pretty ...
2
votes
1answer
279 views

amazon RDS Security Groups Issue

We had a odd issue today related to the security groups in our RDS. All the sudden, without any changes from our end, our RDS instance's security group stopped working. No server was able to connect ...
1
vote
1answer
913 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 ...
1
vote
1answer
568 views

AWS MSSQL RDS Instance periodically timing out

Every 5 or so days (including just now) I get a barrage of timeout errors from my webapp. If I look at what my SQL instance is doing in CloudWatch, it reports this: Freeable space: http://cl.ly/NBRM ...
1
vote
1answer
163 views

Amazon RDS Master-Slave Relationship between EC2 instances with load balancing activated

We're planning to move our Tomcat/MySQL app onto the Amazon cloud employing 2 EC2 instances (inst_1 & inst_2) running in different availability zones whereby inst_1 will contain the master RDS db ...
1
vote
1answer
338 views

How can I tell if I would benefit from upgrading my Amazon RDS instance?

I have several sites with very high traffic - all hosted on Heroku and all of which access a db.m1.large mySQL Amazon RDS instance - and would like to know if there would be a performance benefit in ...
0
votes
1answer
12 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 ...
0
votes
1answer
223 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
1answer
109 views

RDS replication from a remote master outside of my VPC

I'm attempting to replicate from an external MySQL master to an RDS instance. I don't really want to be sending data in the clear over the Internet, so I have an EC2 instance that I have set up an ssh ...
0
votes
1answer
83 views

MySQL spends too much time cleaning tmp tables

I'm running some Django migrations on an AWS RDS MySQL instance. My team has tested the migrations very thoroughly and they ran fine (even taking less than 30 minutes when run on our laptops against a ...
0
votes
1answer
83 views

How to access an AWS RDS host in a VPC

I have setup my first AWS VPC. It has a public subnet, and two private subnets. One of the privates has an RDS instance, and the other is vacant (in a different AZ). I followed the tutorials on AWS ...
0
votes
1answer
205 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 ...
0
votes
1answer
294 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
1answer
527 views

Amazon RDS suddenly not working and unable to connect

I'm using an Amazon RDS with MySQL, and I connect to it via another EC2 machine. I correctly set the Security Groups; and it has been working good for two days. Today, for a test I scaled the RDS ...
0
votes
1answer
254 views

With Amazon Web Services' RDS, should I increase the instance size and/or IOPS count to get better performance?

I currently have a small MySQL RDS instance. It's for a webapp that on average does more reads than writes (maybe 75/25) with daily bursts of heavy writing. I set the database size at 305 GB after ...
0
votes
1answer
209 views

Why is my MySQL going offline?

I have 2 applications hosted in a windows server 2008 r2 (AWS EC2 Large instance)machine, using IIS7.5 and mysql 5.5.12. The one database is hosted on the server with a local DB instance the other DB ...
0
votes
1answer
64 views

Which Open Source Cloud Management Platform supports Amazon-RDS?

I have been trying to use Amazon Web services, specially EC2 and RDS. Nowadays most CMP (Cloud Management Platform) like Eucalyptus, OpenNebula, OpenStack, Nimbus and CloudStack all support Ec2 to a ...
0
votes
1answer
123 views

Trouble understanding AWS integration with self-hosting

Lets say I have existing infrastructure for web server(s), application server(s), and database servers. Now I want to take advantage of some of Amazon's Web Service offerings. Lets take RDS for ...
0
votes
1answer
568 views

Parser or export for slow queries table (mysql.slow_log) on AWS RDS?

So I turned on slow query logging in my Amazon RDS instance (via the method here), and now I'm wondering how to parse the data collected in the slow queries table (mysql.slow_log). Can I use the ...
0
votes
1answer
381 views

Encrypted MySQL Connection with JNDI DataSource in Tomcat 6

I want to encrypt a connection to an Amazon RDS MySQL server. I have the .pem and can connect to the server using mysql --ssl_ca=file.pem in bash, but I need to connect to the server in a web app with ...
0
votes
1answer
337 views

amazon aws network latency issues

We have just started to move our infrastructure to Amazon's AWS (EU West). Since we started the move we have started seeing some quite substantial spikes in network latency. Our setup is quite simple, ...
0
votes
1answer
332 views

Show warnings from mysqlimport

I'm running a job from a Linux box to an Amazon RDS (MySQL) that pumps in about 1GB of data via mysqlimport. It runs flawlessly, however, when I attempt the exact same command with windows I get ...
4
votes
0answers
242 views

TCP congestion collapse

I am experiencing suboptimal performance on an EC2 instance connecting to an RDS instance. This particular instance was built before VPC's existed, so all the traffic is flowing through a single ...
4
votes
0answers
159 views

Bugzilla extremely slow on EC2, RDS PostgreSQL

The Problem I have installed Bugzilla on an EC2 instance, using PostgreSQL RDS as my database. After entering a few dozen bugs, Bugzilla became unbelievable slow, and I get a lot of timeouts. ...
2
votes
0answers
231 views

EC2 cannot connect to RDS on VPC. Subnet issues?

I was able to deploy our .NET app using the AWS toolkit for Visual Studio. I set up the RDS database manually (MySQL) and deployed the app using elastic beanstalk (set up on VPC). The issue was that ...
2
votes
0answers
858 views

Amazon RDS: Sudden increase in Read IOPS and Throughput

I am using Amazon RDS to host the databases for my website. I am using the large instances for both my master and my read replica. Everything was running smoothly until suddenly the Read IOPS, Read ...
1
vote
0answers
33 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". ...
1
vote
0answers
205 views

Amazon RDS Instance slowly losing free diskspace

A while back the server running my instance had 20GB of EBS storage. It then started getting disk storage errors, so I increased it to 40GB. Then again, storage missing errors so I increased again to ...
1
vote
0answers
183 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...
1
vote
0answers
75 views

Connecting to a PostgresSQL Database Instance on Amazon Web Services

I've been trying to use the instructions found on amazon to set up my PostgreSQL database instance and connected it to PG Commander. After getting an initial connection error I checked to see if ...
1
vote
0answers
283 views

MySQL on Amazon RDS db.m3.medium performing slowly

I'm moving a rails application from heroku to AWS in order to increase reliability and control over the stack architecture. I was planning to use amazon RDS as I will need several app servers, and a ...
1
vote
0answers
24 views

Launching an RDS Instance with a specified security group

Is it possible to launch an RDS instance and associated with a specific security group? It seems to only let me launch one that is associated with the default security group of the chosen VPC. I can ...
1
vote
0answers
194 views

Keep getting '…is blocked because of many connection' on Amazon RDS

I'm finding that for the second time in a week I've got the '...is blocked because of many connection' issue with my Amazon RDS. From the monitor within RDS control panel I can see that I'm nowhere ...
1
vote
0answers
297 views

Issue connecting to Amazon RDS with stunnel on Windows

I'm trying to set up a local pgbouncer server that then connects using SSL to Amazon's PostgreSQL RDS service. According to pgbouncer's documentation, you need to use something like stunnel to ...
1
vote
0answers
38 views

How To Get Amazon RDS Network Utilization Statistics

With Amazon EC2 instances, one can use cloudwatch to find how much bandwidth is going in/out. However, this is not the case with the RDS database. Does anybody know of a way to discover the ...
1
vote
0answers
782 views

How to connect to Amazon RDS MySQL instance while preventing MITM attack

I have an Amazon RDS instance running MySQL. I've created a user account, and I've configured MySQL to require the use of SSL for all logins to that account. I want the MySQL client to be able to ...
1
vote
0answers
1k views

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: ...
0
votes
0answers
8 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 ...
0
votes
0answers
17 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 ...
0
votes
0answers
184 views

AWS RDS db.t2 instance performance thresholds & monitoring

We have been rolling out a standard web server configuration for mainstream CMS software like Drupal & WordPress, with the server & storage on EC2 / EBS and the database for those software ...
0
votes
0answers
55 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. ...
0
votes
0answers
64 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 ...
0
votes
0answers
74 views

Elastic search custom mysql server

I want to use ElasticSearch nodes with Amazon RDS servers. How I can do this? The idea is to have the ElasticSearch feature only with a remote DB.
0
votes
0answers
166 views

EC2 instance can't connect to RDS

I have created an EC2 instance and an RDS instance. Using Ubuntu and MySQL, RDS instance is public and not A-Z. I have created a security group that allows 3306 from anywhere on both Ingoing and ...
0
votes
0answers
19 views

SQL Server 2012 Web uses max 4CPUs. AZ RDS allows deployment on R3.2xLarge (8vCPU) instance. Why?

According to MS documentation, SQL Server 2012 Web Ed. is limited to use 4CPUs. However, Amazon RDS allows it to be deployed on R3.2xLarge instance. BTW, R3.2xLarge offers 8vCPUs. So is it helpful ...
0
votes
0answers
86 views

PHP FPM, chroot can't connect to AWS RDS

I've been experimenting with chroot'ing php-fpm pools via the built-in chroot method in php's pool config. This is for the purpose of hosting multiple wordpress websites on the same AWS EC2 instance. ...
0
votes
0answers
68 views

iis-disabling-ssl-v3 (CVE­-2014­-356)causing ec2 to Rds connection failure

To disable ssl v3 on my web server (m1.small EC2, i-1aafee15) running windows server 2012 r2, I added registry keys: SSL 3.0->Server->Enabled (0) SSL 3.0 ->Client->DisabledByDefault (1) ...
0
votes
0answers
146 views

What would happen if I provision IOPS in RDS on a non-PIOPS-Optimized instance type?

Quote from the docs: If you are using Provisioned IOPS storage, we recommend that you use the db.m3.xlarge, db.m3.2xlarge, db.m1.large, db.m1.xlarge, db.m2.2xlarge, db.m2.4xlarge, ...
0
votes
0answers
240 views

Load balanced EC2 instances for high performance hosting?

I have a fairly hefty Dell machine with dual quad-core cpus and 32GB memory. On that machine I host a pretty busy forum, but the one machine does everything; web, cache, db, sphinx, etc. I also have ...
0
votes
0answers
271 views

AWS RDS Parameter Group Deployment Guide: For Replicated Instances?

I am part of a team that manages a small DB cluster, including Multi-AZ and Read-Replicas. I found the following deployment guide: ...