Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

1
vote
1answer
335 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 ...
0
votes
1answer
27 views

How to re-create the symmetric key on Amazon RDS

We have some column encrypted by symmetric key. Now we want to upload our database to Amazon RDS (SQL Server). Can we do that? If yes, how?
0
votes
1answer
110 views

Multiple RDS vs DNS

have a problem I was hoping someone could help me with. We have two RDS read slaves that we have our app servers round-robin to for data reads (DNS in Route53). Well, yesterday those RDSes got ...
3
votes
1answer
118 views

How can I get Puppet generated configuration to include internal hostnames of other ec2 instances in my CloudFormation stack?

I have a stack generated by AWS CloudFormation that includes an EC2 instance (running Ubuntu 14.04) and an RDS (database) instance. They are both inside a VPC, which includes a puppet master (not as ...
0
votes
0answers
99 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
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 ...
0
votes
1answer
138 views

Solution for PHP / MySQL website loading fast in multiple regions [closed]

I host am ExpressionEngine based website on a single Amazon EC2 instance in the US East (Virginia) region. I use Ubuntu. The website allows members to post their content, and displays it for other ...
0
votes
1answer
130 views

RDS very slow and storage incosistencies [closed]

A couple of hours ago one of our AWS EC2 instances spike in CPU usage to 90 - 100%. That server, along with several other production servers, use one main RDS instance for the databases. All server ...
3
votes
1answer
1k views

AWS RDS MySQL remote connection extremely slow

I have a site hosted on AWS EC2 (Elastic Beanstalk), with a MySQL database hosted on AWS RDS. Everything works fine on the production server, fast and all. However when I try to connect remotely from ...
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 ...
1
vote
0answers
230 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 ...
0
votes
0answers
70 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?
2
votes
0answers
191 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
1answer
197 views

AWS Oracle RDS SE instance larger than m3.2xlarge

All, I was wondering if we can pick anything larger than m3.2xlarge for Oracle SE1 AWS RDS in a pay-as-you-go license mode? The m3.2x large allows only 8 vCPU's and 30GB RAM. Questions: Does SE1 ...
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
297 views

mysql.sock error when deploying with AWS Ubuntu and RDS

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Rails.root: /opt/deployment.myproject/releases/20140805050704 I've spent the better part of 3 days trying to ...
0
votes
1answer
136 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 ...
6
votes
1answer
3k views

Does Amazon RDS support multiple databases per instance?

Title says it all... does it support multiple databases, or do I have to create a new instance for each database?
0
votes
0answers
200 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 ...
4
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
2k 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
117 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
480 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 ...
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 ...
1
vote
1answer
237 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 ...
2
votes
2answers
2k views

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express. I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted ...
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
182 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 ...
1
vote
2answers
5k 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 ...
2
votes
1answer
705 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
78 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
57 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
1answer
671 views

Ways to go about optimizing website performance WordPress, Amazon EC2 Apache and RDS MySQL

I have 6 WordPress websites running on 1 single EC2 instance. All the the websites are connecting to databases in 1 same RDS instance. Earlier today, traffic to the largest website peaked and the ...
4
votes
2answers
4k views

AWS EC2 dns resolution diagnostic

I am using EC2 instances with amazon linux installed (with amazon dns server settings, which comes from DHCP), as well as an RDS database. The EC2 instances are behind ELB and get high traffic. The ...
2
votes
2answers
781 views

Efficient plan for backing up EC2 instance, EBS volumes and RDS DBs

I have an EBS-based EC2 instance (ebs_vol_1) which mounts and extra EBS volume (ebs_vol_2), and DB in RDS. Is tacking a snapshot of ebs_vol_1 & ebs_vol_2, enough for preventing data-loss? Is ...
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
2answers
528 views

Amazon AWS mysql RDS Cluster with outside AWS?

I'm now using AWS RDS multi-AZ with great results, the problem is that I want my infrastructure fault tolerant between regions. I'm looking for some kind of tool to make a cluster with RDS and my ...
2
votes
2answers
827 views

How different is an Amazon EC2 RDS DB Instance different from the normal EC2 Instance?

How different is the Amazons RDS DB Instance different from The normal EC2 Instance other than the fact that RDS DB Instance has a Database server running on it? When an EC2 Instance goes down all ...
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 ...
0
votes
1answer
366 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
184 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 ...
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 ...
0
votes
1answer
437 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 ...
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 ...
4
votes
1answer
406 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 ...
2
votes
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 ...
1
vote
1answer
696 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 ...