0
votes
1answer
54 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
52 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 ...
1
vote
1answer
63 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 ...
0
votes
1answer
127 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
0answers
94 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
257 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 ...
1
vote
1answer
246 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
51 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
68 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 ...
1
vote
1answer
525 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
124 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
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 ...
2
votes
1answer
230 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
35 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
39 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 ...
3
votes
1answer
838 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, ...
0
votes
1answer
690 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
1k 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
1k 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 ...
5
votes
2answers
3k 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
172 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
2k 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 ...
0
votes
0answers
19 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
162 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 ...
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
856 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
692 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
0answers
27 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 ...
0
votes
1answer
643 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
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
227 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 ...
0
votes
0answers
76 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
28 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 ...
2
votes
0answers
467 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
44 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
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
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 ...
0
votes
1answer
170 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
1answer
561 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 ...
4
votes
5answers
3k 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
57 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
1answer
170 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
76 views

RDS - Dynamic endpoint causing problems with static configuration files

I'm running into a slight problem with RDS. My system I designed works like so: Server A initiates an RDS startup from a snapshot on a daily bases Server A puts data in RDS database Server A ...
1
vote
2answers
3k 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 ...
0
votes
2answers
267 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
1
vote
1answer
1k views

Connecting RDS database from out side of VPC

My RDS database located in VPC. It's a Multi AZ database so that it's located on two VPC subnet. How could I connect it from outside of VPC?
0
votes
1answer
108 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 ...
1
vote
1answer
428 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 ...
0
votes
1answer
55 views

Amazon EC2 and RDS - Creating Access

I was wondering how I can automatically enable access to my RDS server from my EC2 server. I have read that you can do this using keys kept on the EC2 server but I would rather not go that route. ...
1
vote
1answer
149 views

Using Amazon's RDS Read Replica

I'm interested in the potential read performance increase of having a "Read replica" of my amazon RDS. Before I try, I'd like to be clearer on a few things. After creating a read replica, how does ...