Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

0
votes
1answer
21 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 ...
2
votes
1answer
33 views

What is the rdsadmin user and should I care?

I've inherited control of an AWS MySQL RDS instance. I'm curious to know what the 'rdsadmin' user is and whether I should know the password for this or whether this is purely for use by the Amazon Web ...
0
votes
0answers
25 views

PostgreSQL Error: out of memory

I'm trying to run a query that should return around 2000 rows, but my RDS-hosted PostgreSQL 9.3 database is giving me the error "out of memory DETAIL: Failed on request of size 2048.". What does ...
0
votes
0answers
9 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
1answer
34 views

Amazon RDS MySQL limitations

I have a web app that's quite data-heavy. The application is currently storing approximately 5k rows (logs) a day into a MySQL RDS micro instance (all settings default - InnoDB, UTF8,etc). Each log is ...
0
votes
1answer
31 views

Oracle Database suddenly fills storage device in about 20 minutes

My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out ...
0
votes
1answer
68 views

Amazon: How do I know if I need Provisioned IOPS?

We recently moved to Amazon Web Servers and are still learning our way around. Our EC2 Web instance and our RDS MySQL instance (right now we only have 1 of each) seem to be chugging along okay. But I ...
0
votes
1answer
58 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 ...
2
votes
2answers
405 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. We're new to AWS, so before moving ...
1
vote
1answer
32 views

How do I access and use an AWS RDS reserved instance?

I've set up several AWS RDS on-demand instances. Each time, the process was the same, and it included selecting instance type, capacity, storage, etc. When I'm done, and click on the instance icon, I ...
0
votes
1answer
181 views

How to troubleshoot slow performance on AWS EC2/RDS?

We recently moved our web servers from some 10 year old boxes to AWS EC2. Usage of the site is currently higher now (it's our busy season) and the site has become much slower, which is unexpected ...
1
vote
0answers
55 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 ...
0
votes
0answers
12 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
1answer
143 views

Amazon AWS EC2 and RDS: How To Increase MySQL Query Cache?

I tried to find information about this, but can't find anywhere. The only one that I could find was http://survivalguides.wordpress.com/2012/07/11/change-the-query-cache-size-amazon-aws-rds/ but it ...
0
votes
0answers
11 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
1answer
55 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
2answers
147 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 ...
1
vote
0answers
49 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 ...
16
votes
2answers
1k views

In AWS, does an hour of usage get charged just for an instance being in the “running” state?

When AWS documentation and pricing refer to "usage" does this simply mean "if the instance is on" instead of "if the instance is on and doing work". E.g., if I had an EC2 instance running but it was ...
1
vote
1answer
217 views

How to calculate the size of an AWS RDS instance from a MySQL dump?

We are importing a large historical database into RDS from a mysqldump The gziped sql file was 3GB, the uncompressed sql file is 18GB. We created a 30GB AWS RDS instance and imported the file... the ...
4
votes
2answers
230 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 ...
1
vote
0answers
146 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 ...
0
votes
0answers
20 views

Scale down RDS database on Beanstalk

I have to scale down a RDS database on Elastic Beanstalk. Right now it has 1024GB and I need just 30GB. I read that I have to create a new instance and restore a dump. The problem is that I don't ...
-1
votes
1answer
133 views

Amazon RDS automated hourly snapshots [closed]

I have been looking on Amazon RDS for a way to automatically created incremental snapshots for RDS databases. I want to create hourly snapshots. Can anyone help me ?
0
votes
1answer
812 views

First attempt to migrate EC2 MySQL to Amazon RDS no going well - SUPER privileges

I've been trying to move an existing db from MySQL running on EC2 to a new Amazon RDS instance (an experiment to see if we can move across). So far, it's not going well. I'm stuck at the initial ...
1
vote
1answer
84 views

Why AWS RDS doesn't update minor version?

I have a small RDS instance on AWS, and on the maintenance details I have set "Auto minor version upgrade" to Yes. But I still have the MySQL engine version 5.5.27, and AWS has the version 5.5.33 ...
3
votes
1answer
236 views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
0
votes
0answers
31 views

Freeable memory on Amazon RDS maxed. How do I clear it?

This is my freeable memory on my RDS instance: http://cl.ly/image/2y40213K2R1F How can I clear this out? Or at the very least troubleshoot? I tried restarting, but it doesn't work.
0
votes
0answers
41 views

MSSQL on AWS RDS - Should I be worried about falling freeable memory?

My question is similar to What is "freeable memory"?, however we are using MSSQL on RDS, as opposed to mysql. We are seeing a consistent downward trend in freeable memory. Currently sitting ...
1
vote
0answers
20 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 ...
0
votes
0answers
35 views

Amazon RDS equivalent to dedicated

We currently have a dedicated server 8 cores, AMD Opteron @ 2.3GHz (don't know the exact model), 40GB RAM, 500 GB HDD. The MySQL database size reported by SELECT table_schema, Round(Sum(data_length ...
0
votes
0answers
284 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' ...
0
votes
1answer
147 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
votes
2answers
213 views

Amazon RDS - Can't connect to MySQL Server database?

I am trying to login to MySQL server using *nix shell prompt, following is my command : $ mysql ********** -east-1.rds.amazonaws.com:3306 (where the asterisks are my ID) I am getting following ...
0
votes
1answer
29 views

EC2 instance passes health checks but no longer can SSH in

I've had my website (an EC2 instance) running for a year now and everything was fine until this morning when I lost access to it and its associated database (an AWS RDS database instance). I can't ...
0
votes
0answers
236 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
2answers
178 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 ...
1
vote
0answers
70 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 ...
0
votes
1answer
99 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 ...
1
vote
1answer
248 views

What happens when RDS freeable memory runs out?

We have a rather large mysql instance on RDS and the freeable memory is starting to get low (<1GB) in the last 24 hours. What will happen if we reach 0 freeable memory? Does that mean all memory ...
1
vote
1answer
109 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
46 views

Does it make sense to restrict from where a user can connect to a RDS, if already using a DB security group?

Since AWS' RDS have a firewall based on EC2 security groups (or IP ranges), is it meaningful at all to also restrict connections' origins by restricting users?
1
vote
1answer
1k views

Aws Rds - Mysql Block host due to many connections

Recently I have migrated the wordpress database to AWS RDS Large Instance (MySQL 5.6.12). After that occasionally Mysql locked my ec2 instance Ip with below error message. "blocked because of many ...
0
votes
1answer
96 views

Security Group Access Control for RDS is not working

I have been banging on this for awhile and I can't get access to my RDS instance by using the security group of my instance. It works fine if I put in the public IP address using CIDR , but if I ...
0
votes
0answers
97 views

Can I ignore tables in replication on MySQL on Amazon RDS?

We run large updates on a database semi-weekly which, when replicated to our read slave, destroys any performance gains we get from actually having the read replica to begin with. Since the read ...
0
votes
1answer
315 views

PHP cannot connect to AWS RDS server

I have a EC2 Instance with apchane, PHP and phpmyadmin. I have connect phpmyadmin to manage the aws RDS server. they are in the same security group. But when i try to use a php script to connect to ...
0
votes
1answer
479 views

Connecting to a new RDS instance from an EC2 instance

I am having trouble connecting to my RDS instance from my EC2 instance. I added the elastic IP address for the EC2 instance to the RDS security group. as follows: xx.xxx.xx/32 I am using a PHP script ...
3
votes
5answers
2k views

AWS: Multi-region setup using single RDS instance

I'm trying to scale our web application (PHP, MySQL, memcache) in a multi-region scheme. Currently we are using a setup with two EC2 instances behind an ELB and an RDS instance, all of them in US-EAST ...
0
votes
1answer
52 views

How do I create an AWS RDS Database in Europe

If I can create a database in Europe, I have a lot less to worry about with reagards to data protection. amazon's docs imply that I can create one in Ireland. When I get to the apropriate stage of ...
0
votes
0answers
100 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 ...