Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

0
votes
1answer
123 views

Is Amazon RDS overkill for small business site?

One of my clients wants a small business site run on Wordpress. I'm setting it up through Amazon EC2, and was curious if using Amazon's RDS service to run the wordpress installation is overkill. I ...
0
votes
0answers
193 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 ...
1
vote
1answer
1k 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 ...
2
votes
0answers
112 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. ...
1
vote
1answer
471 views

AWS RDS. Upgrade MySQL from 5.5 to 5.6, external replica and Access denied

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html My old instance is running ...
0
votes
1answer
60 views

Best practice for web applications and windows services remote configuration in AWS

we have a distributed system that contains windows services and web applications (.NET and Java based). Currently, most of the initial configuration for these applications are taken from various ...
1
vote
1answer
1k 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 ...
0
votes
1answer
212 views

Amazon RDS On-Demand DB instance to Reserved instance

We currently have 3 on-demand rds instances running and we're planning to move each instances to reserved ones. Upon purchase of the reserved instances, what migration steps should be done to move ...
0
votes
1answer
287 views

Deleting log files from an AWS RDS Postgres instance

How can I delete logs from an RDS Postgres instance? I just noticed that my instance is displaying the message, storage-full. I can find any descriptions of how to deleted the log files, which I think ...
4
votes
1answer
2k views

can't find the private Ip address for my Amazon-RDS instance

i moved my Master/slave database architecture to Amazon RDS and everything works fine. But i have a slave out of the RDS service which should keep sync with the new Master server, to do so i have to ...
0
votes
0answers
176 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 ...
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 ...
2
votes
1answer
653 views

AWS: Should my EC2 and RDS instances be in the same Availability Zone?

I just noticed that all of our EC2 instances are in zone us-west-2b, but our Multi-AZ RDS instance is in us-west-2a. Performance-wise everything seems to be okay, and it will be a hassle to "move" ...
0
votes
0answers
75 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
55 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 ...
7
votes
2answers
5k views

Highest value of max_connections in AWS RDS micro instance

Currently, the value for the max_connections parameter in a MySQL RDS t1.micro server model is {DBInstanceClassMemory/12582880} is 32. Since my server does not allowing any more connections after 32, ...
8
votes
2answers
2k views

Access Amazon EC2 RDS instance from inside VPC

I have an Amazon RDS instance set up in the 'classic' EC2 (no VPC.) I also have a VPC set up that holds our newer, migrated applications and such. However, it would seem that there is no way to ...
0
votes
1answer
2k 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
1answer
3k 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
1answer
346 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
172 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
4k 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
411 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 ...
6
votes
2answers
5k 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 ...
2
votes
1answer
364 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 ...
1
vote
1answer
4k 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
1answer
2k 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
1answer
203 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
661 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
154 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 ...
19
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 ...
3
votes
1answer
2k 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
1k 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
254 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 ...
2
votes
1answer
1k 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 ?
3
votes
2answers
4k 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
356 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 ...
4
votes
1answer
1k 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 ...
1
vote
0answers
33 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
1answer
711 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
649 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
54 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 ...
1
vote
0answers
660 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 ...
7
votes
2answers
2k 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 ...
2
votes
0answers
577 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
166 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
1k 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
656 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
49 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
3k 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 ...