Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

0
votes
2answers
33 views

How to create hostname alias WITHOUT IP address?

In linux , /etc/hosts stores ip aliases. But I want to create a hostname without knowing its IP address. In Amazon RDS , it's endpoint is a long domain name such as : ...
0
votes
0answers
15 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
1answer
36 views

Can't connect to RDS MySQL

So, I created a new DB and my EB app is reaching it fine, but I can't seem to access MySQL from my computer. When I try to run: mysql --host=123.abc.us-west-2.rds.amazonaws.com –-port=3306 –u myname ...
1
vote
1answer
37 views

Why can't I create a superuser in AWS Postgresql instance?

I have an AWS EC2 instance connecting to an RDS instance (Postgresql). When I created the RDS instance, I told it the DB root's username was: my_user1 and the password was password1. Now I'm ...
3
votes
1answer
27 views

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our ...
10
votes
1answer
6k views

What is “freeable memory”?

Amazon RDS has a metric for 'freeable memory'. It appears to go down in a sawtooth pattern: https://skitch.com/adamnelson/rnhpu/aws-management-console This leads me to believe that it's memory that ...
1
vote
2answers
993 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
1answer
51 views

unable to connect to public postgresql rds instance

I created a basic test PostgreSQL RDS instance in a VPC that has a single public subnet and that should be available to connect over the public internet. It uses the default security group, which is ...
2
votes
3answers
841 views

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure ...
1
vote
1answer
48 views

AWS RDS Nightly Staging Database

I am trying to determine if it is possible to configure the RDS service in AWS to do the following, but have not had much luck with my Google searches. When it does its instance backup, have it ...
1
vote
0answers
34 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
2answers
94 views

AWS EC2 Auto Scaling Groups, RDS, Route 53 and Constantly changing IP addresses

I setup an auto scaling group on EC2 along with an RDS Postgres instance. I am not using ELB. Maybe I should be... The challenge is that every time a new EC2 instance is created it assigns a unique ...
-1
votes
1answer
87 views

Why the time taken to fetch results of a query for 10,000 times from a RDS is so uneven? (experiment)

tl;dr : Why the time taken to fetch results of a SELECT statement for 10,000 times from a RDS when requested from an EC2 is so uneven? Updated the question with results of small and medium RDS ...
1
vote
2answers
56 views

Allow access to RDS instance from EC2 instance on same VPC

I am having trouble gaining access to a MySQL RDS instance. I am trying to connect to the RDS instance from an EC2 instance. Both the RDS instance and the EC2 instance are contained within the same ...
0
votes
2answers
202 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
1answer
39 views

Amazon RDS on solid state drives

I am planning to design a cloud based application which leverages the MySQL provided using Amazon RDS. I wish to setup read replicas for the data which I have obtained on solid state drives. Does ...
2
votes
0answers
648 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
0answers
37 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
2answers
1k 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 ...
0
votes
0answers
46 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) ...
-1
votes
2answers
70 views

Never miss a HTTP post [closed]

I have a webservice that have a couple of "machine" clients connected to it that does HTTP post with data once in a while. The nature of the service is that I cant allow the service to loose a single ...
0
votes
2answers
66 views

Is it possible to attach an Amazon RDS SSD volume to an EC2 instance?

It has been my understanding that you cannot attach an Amazon RDS SSD volume to an EC2 instance. I was under the impression that the RDS instances were a "managed" solution and that the volume was not ...
0
votes
0answers
70 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
197 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
25 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
85 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
80 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
73 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
56 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
109 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
79 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
2k 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
181 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
1answer
349 views

How to move RDS database to different VPC

I didn't select a VPC when creating a MySQL RDS database, so it created it inside an auto-generated "default" VPC. I'm now unable to add it to any of my pre-defined security groups, or access it from ...
0
votes
0answers
54 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?
1
vote
0answers
150 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
126 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 ...
7
votes
2answers
1k 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
230 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
92 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
152 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 ...
3
votes
2answers
3k 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
867 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
97 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
407 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 ...
0
votes
1answer
158 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 ...