Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

1
vote
2answers
948 views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...
0
votes
2answers
563 views

MySQL - Slow query - wp_options table. Website unable to handle traffic

After spending several days researching, I have placed a website on a c1.medium instance, Amazon Linux, and the MySQL database on a db.m1.instance. The RDS is running MySQL version 5.6.13. I have ...
0
votes
2answers
190 views

Installing testlink on Amazon EC2 instance

I have created an Amazon EC2 instance to host a testlink server with RHEL. I have successfully configured mysql client, Apache and PHP, but when I try to install it and create the DB, I'm unable to ...
0
votes
2answers
315 views

AWS RDS Scaling

Folks, Since ELB is not available for load balancing RDS instances, what methodology do you recommend to load balance read replicas? RR Route53 DNS entries? Or something more clever? Thanks
0
votes
2answers
434 views

How to architect my application on AWS cloud?

I am plannig to port an e-exam app on the aws cloud. I have decided to use a ELB, EC2 instances. But i am confused on wether to use a MYSQL DB server on amazon instance or to go for amazon RDS? Also ...
2
votes
1answer
388 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
248 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
603 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 ...
1
vote
1answer
512 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
451 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
144 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
265 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 ...
1
vote
1answer
311 views

Setup game server using amazon web service?

I am relative new to amazon web services (aws). I would like to setup a game server for my next coming project. Basically, I just need a database(mysql) and php to connect to the database, nothing ...
0
votes
1answer
298 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
176 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
152 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
54 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
109 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
461 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
335 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
283 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
306 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 ...
2
votes
0answers
93 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
569 views

MySQL on Amazon RDS connection handshake error reached max_connection_errors

We are using a C# web app on AWS connecting to a MySql RDS. Suddenly, connections start to fail with two different exceptions: First one (most repeated): Authentication to host 'xxx' for user 'xx' ...
1
vote
0answers
13 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
148 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
138 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 ...
1
vote
0answers
22 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
174 views

Elastic Beanstalk w/ RDS and PHPmyAdmin

I'm trying to configure a Drupal CMS on my new Amazon EC2 server with Elastic Beanstalk PHP. I also have MySQL configured for my RDS database. I want to get PHPmyAdmin running for use with Drupal. I ...
1
vote
0answers
123 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
212 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
31 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
570 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
356 views

Is it possible to force Re-creation of EC2::Instance or RDS::DBInstance in amazon cloudformation?

It's possible to force the re-creation of a EC2 or RDS instance using cloudformation stacks? My stack goes stuck in a point where simply destroying and creating the resource will fix it, instead of ...
1
vote
0answers
538 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
904 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
17 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
0answers
40 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
52 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
0answers
62 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
44 views

Load average metric for RDS in Cloudwatch

Has anyone succeeded in getting load average data for an RDS instance into Cloudwatch? If so, how did you do it?
0
votes
0answers
129 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
154 views

Token Mismatch When Accessing RDS Instance Through phpMyAdmin on localhost

Having problems using phpMyAdmin with a RDS instance. This is the guide that I used. phpMyAdmin is installed on my Windows 7 laptop and I can connect to the RDS instance and I can see the databases ...
0
votes
0answers
53 views

Visual Studio RDS Setup

I'm trying to go through this tutorial: http://docs.aws.amazon.com/elasticbeanstalk/latest/dg/create_deploy_NET.quickstart.html on setting up an RDS instance and sql db using Visual Studio AWS ...
0
votes
0answers
44 views

Pending: Master User Password AWS RDS

I'm trying to create a sql server express RDS instance. When I fill out the form on the AWS management console it prompts you to set up a "Master Username" and "Master Password". So I enter some ...
0
votes
0answers
90 views

Replicate SQL Server to Amazon RDS

I have a SQL Server in a dedicated hosted facility that we would like to have DR for. Is it possible such that the database is replicated out to a SQL Server instance in Amazon RDS? Or would I have ...
0
votes
0answers
20 views

Amazon AWS RDS Parameter Groups: query_size value is 0-9223372036854774784?

While trying to edit query_size, the current default value is 0-9223372036854774784 I am confused, what does this means? I was trying to set it to around 200MB, in this case what should I enter? ...
0
votes
0answers
16 views

Drupal on Amazon VPC tries to reinstall a new site

My Drupal based web site running on a cluster that includes Amazon VPC instance, gluster network file server and Amazon RDS database instance. Sometimes, not very frequently, when a new instance is ...
0
votes
0answers
195 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: ...
-1
votes
0answers
14 views

jQuery cannot pass local storage to RDS postgreSQL via php on AWS

I am slightly new to programming, I have had a few friends help me out with getting my Phone Gap app to post local storage to postgres via php. I am testing my app on my desktop browser and in an ...