Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

4
votes
1answer
196 views

If you can't change the RDS endpoint of an AWS Beanstalk instance, how do you do a blue/green deployment?

From what I can tell, one can't change the Amazon RDS (RDS) endpoint of an existing Elastic Beanstalk (EB) instance? If that is the case, than you can't have your code deployed to a stage server, ...
4
votes
1answer
333 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 ...
2
votes
1answer
19 views

Is it possible to connect to a non publicly available RDS instance from SequelPro?

I have a MySql AWS RDS instance inside a VPC. I was wondering if it is possible to make the RDS instance NOT publicly available, but still be able to somehow connect to the DB via SequelPro or ...
2
votes
1answer
408 views

Low transfer rates on Amazon's EC2

I have a question re transfer rates on Amazons EC2. Basically I am evaluating a move to the Amazon stack of services, however wanted to benchmark it against our current setup first. My setup is pretty ...
2
votes
1answer
303 views

amazon RDS Security Groups Issue

We had a odd issue today related to the security groups in our RDS. All the sudden, without any changes from our end, our RDS instance's security group stopped working. No server was able to connect ...
1
vote
1answer
35 views

Amazon RDS Replication

I'm having an issue with working with Amazon RDS in itself, is there a way through RDS to create a seperate RDS instance and have RDS Server 1 replciate to RDS Server 2? I cannot seem to figure out ...
1
vote
1answer
663 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 ...
1
vote
1answer
190 views

Amazon RDS Master-Slave Relationship between EC2 instances with load balancing activated

We're planning to move our Tomcat/MySQL app onto the Amazon cloud employing 2 EC2 instances (inst_1 & inst_2) running in different availability zones whereby inst_1 will contain the master RDS db ...
1
vote
1answer
379 views

How can I tell if I would benefit from upgrading my Amazon RDS instance?

I have several sites with very high traffic - all hosted on Heroku and all of which access a db.m1.large mySQL Amazon RDS instance - and would like to know if there would be a performance benefit in ...
0
votes
1answer
11 views

HY000 General Error on RDS

I have just set up my Laravel (PHP) project on Amazon with EC2 and RDS. Using MySQL 5.7. However, I've stumbled upon an error after I log in. I can register a user just fine, but when I log in, I get ...
0
votes
1answer
20 views

Reset slow_log tables in RDS of AWS

I enabled the slow_log_query in RDS in AWS. I want to reset the table but i am getting Access denied in PhpMyadmin while truncating . Any Idea to make it possible .
0
votes
1answer
23 views

Backing up website that uses amazon ec2 and RDS as database

Hello I'm currently using Amazon ec2 instance to run a wordpress website OS is amazon linux AMI and I'm using RDS as my database I need to back up my website without downtime is that possible? RDS ...
0
votes
1answer
186 views

AWS VPC Public Private Subnets - EC2 Instance cannot reach RDS instance

Following rposcibed pattern here: Scenario 3: VPC with Public and Private Subnets and Hardware VPN Access Summary Description: I have configured a VPC with 1 public Subnet and 2 private Subnets Each ...
0
votes
1answer
191 views

Amazon RDS CPU is about 55-65% after optimizing some Mysql tables

I was having high RAM consumption and, looking for a solution, I executed the script mysqltunner to monitor possible optimizations in the Mysql database. Its first advice was I had to run OPTIMIZE ...
0
votes
1answer
114 views

Forcing an eni change when changing subnets in a rds subnet group

I'm looking at changing the subnets that our RDS instances are currently in. The subnet group currently has /20 for both a & c zones. I've created new /22 subnets for a & c and associated ...
0
votes
1answer
586 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
0
votes
1answer
144 views

MySQL spends too much time cleaning tmp tables

I'm running some Django migrations on an AWS RDS MySQL instance. My team has tested the migrations very thoroughly and they ran fine (even taking less than 30 minutes when run on our laptops against a ...
4
votes
0answers
513 views

Amazon RDS Instance slowly losing free diskspace

A while back the server running my instance had 20GB of EBS storage. It then started getting disk storage errors, so I increased it to 40GB. Then again, storage missing errors so I increased again to ...
4
votes
0answers
425 views

TCP congestion collapse

I am experiencing suboptimal performance on an EC2 instance connecting to an RDS instance. This particular instance was built before VPC's existed, so all the traffic is flowing through a single ...
4
votes
0answers
260 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. ...
3
votes
0answers
249 views

AWS: RDS + CloudFormation – VPC peering

So here's my situation: We are a young startup scaling up and we decided to give Mesosphere DCOS Community edition a try. The community edition deploys a stack of Masters, Slaves and LB's over AWS ...
2
votes
0answers
54 views

Connect to RDS from EC2 - different AZ

I have set up a RDS instance with Multi-AZ support. It ended up in eu-west-1a. It is setup with "Publically available = YES" I have a EC2 instance in eu-west-1c, from which I want to access the RDS ...
2
votes
0answers
359 views

AWS DynamoDB Cost efficiency

I have to move a business application into the cloud, therefore cost is one of my biggest concerns. DynamoDB seems to be a good option, while a big part of our data is able to migrate from ...
2
votes
0answers
1k 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
0answers
17 views

MariaDB on Amazon RDS - Initial setup user grants and permissions

I'm trying to learn more AWS, and have an EC2 setup and an RDS setup running MariaDB. When I created the RDS instance, it asked for user/pass for the initial user, and created 'rdsadmin'@'localhost' ...
1
vote
0answers
15 views

What happens when we remove the SnapshotIdentifier from our Cloudformation config

When we spun up our Cloudformation stack, we restored our DBCluster from a snapshot. We are now in the process of updating our stack. What will Cloudformation do with our DBCluster if we remove the ...
1
vote
0answers
68 views

Cannot connect to remote MySQL server (RDS)

When I am trying to connect to RDS from my vps, it says connection refused. When I tried connecting it from local or other vps, it worked fine. I figured out that it must be a firewall issue on my ...
1
vote
0answers
108 views

Elastic Beanstalk Test Environment use copy of production data

I have 3 environments using Elastic Beanstalk - Prod, Test, Dev. I want to use a copy of production database in my Test environment. It seems there's no easy way to "just use a different database". ...
1
vote
0answers
357 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...
1
vote
0answers
115 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
0answers
402 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 ...
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
0answers
272 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 ...
1
vote
0answers
371 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 connect....
1
vote
0answers
44 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
0answers
1k views

How to connect to Amazon RDS MySQL instance while preventing MITM attack

I have an Amazon RDS instance running MySQL. I've created a user account, and I've configured MySQL to require the use of SSL for all logins to that account. I want the MySQL client to be able to ...
1
vote
0answers
1k views

Cannot connect to MySQL on RDS (Amazon Web Services) from my laptop

I'm having some trouble connecting to a MySQL 5.1 server on an RDS instance on AWS from my laptop. The detailed description of the problem is here: https://forums.aws.amazon.com/thread.jspa?messageID=...
0
votes
0answers
85 views

Too Many database connections on Amazon RDS dropping connection

I need to import a large user base in my application. But while stress and load testing I found that, after 200-300 concurrent requests, mysql starts rejecting the calls and gives the below error. ...
0
votes
0answers
25 views

when do amazon RDS instances change internal IP addresses?

So I hear that RDS instances can change their IPs unexpectedly. What does that mean, exactly? When MS updates cause a reboot? When the DB backup occurs? When the moon changes phases? I am not ...
0
votes
0answers
17 views

amazon RDS vs automated snapshot

Hello running a wordpress website and I want to know If I need an RDS instance. I am curious because RDS has automated backups but It's also possible to add a script to run an Automated snapshot.
0
votes
0answers
33 views

Restrict RDS users to particular region

I am trying to create a policy where I can restrict users to access different region RDS. However I want to give them admin access to only one region i.e. ap-southeast-1. I have created some policies ...
0
votes
0answers
1k views

MySQL RDS Instance full

I have a MySQL instance on Amazon RDS, with 6GB of storage. All databases installed into this instances weight 500MB. Today the server had no space available. How can I identify the problem? This is ...
0
votes
0answers
56 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema TABLES stores the create date of the tables on the column CREATE_TIME. Unfortunately ...
0
votes
0answers
32 views

What is the benefit of the RDS Environment Variables being set for EC2 instances?

Background I am running an ASP.NET MVC website running from Elastic Beanstalk. I have an Windows EC2 instance running IIS and an RDS instance in an Elastic Beanstalk environment. The Problem I've ...
0
votes
0answers
291 views

AWS RDS MySQL DB unable to connect in MySQL workbench and could not connect using telnet

I am using default VPC and created RDS MySQL instance (Publicly Accessible: Yes) with newly created db security group. I have given Inbound/Outbound rules as All Traffic, ALL, ALL, and Source = 0.0.0....
0
votes
0answers
237 views

Memory usage on db.t2.micro

I just brought up an RDS-MSSQL instance which this page says has .6GB of memory. However, the console shows this: I haven't added any databases, but the Memory Threshold looks like its peaking at ...
0
votes
0answers
29 views

Amazon RDS Connection Denied via additional user

I just created a new database and user grant all privileges on that user. I don't know what's happening I can't connect by using that user always "Access Denied". But I change to RDS master user it's ...
0
votes
0answers
464 views

Create RDS Read-Replicate in a separate region using VPC

We have a MySQL RDS instance in a VPC, and want to setup a read-replicata in another region. Unfortunately since our RDS instance is in a VPC, we don't appear to have the option to replicate across ...
0
votes
0answers
132 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
0answers
337 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 ...