1
vote
1answer
93 views
+50

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
47 views

installing phpmyadmin for remote db host

I am having trouble trying to install phpmyadmin. We are using AWS services for our servers. Our mysql db is located in an RDS instance. Now I am trying to install phpmyadmin on an EC2 instance. I ...
0
votes
1answer
60 views

Can I access an AWS RDS read replica directly from Internet?

Or what is the same, is possible assign a public IP address to my RDS read replicas? My read replicas end points answer with private IPs right now, even they are in a VPC subnet with an AWS Internet ...
0
votes
0answers
19 views

discrepancy between data used and

In AWS RDS our DB is using up a total of 75 mb out of 5 gb, mysql> SELECT sum((data_length+index_length)/power(1024,2)) tablesize_mb FROM information_schema.tables order by tablesize_mb desc; ...
0
votes
0answers
39 views

Upgrade the storage and/or provisioned IOPS on a reserved RDS instance?

I would like to reserve an RDS instance, but as of right now my instance does not need a lot of storage provisioned. I would like to reserve the instance with 100GB and 500 IOPS provisioned, but I ...
0
votes
0answers
13 views

AWS Cloudwatch shows wrong RDS size

I have a single RDS instance at AWS, which is -- supposedly -- a db.m1.large instance. When viewing Cloudwatch metrics for RDS, I see an option to filter by db instance size, and this filter shows ...
0
votes
0answers
8 views

AWS - RDS SQL SERVER 2012 - The server principal “sa” is not able to access the database under the current security context [duplicate]

We have created a AWS RDS SQL Server 2012 DB instance in a VPC. We are installing a third party software which also creates a database , while installation we provided the master user account YYY ...
0
votes
1answer
477 views

How do I connect to an AWS RDS with MySQL Workbench? [closed]

I've read this documentation and several other sources but to no avail: I cannot connect to my MySQL instance from MySQL Workbench. I can connect to my RDS instance through EC2, but I cannot dump ...
0
votes
1answer
93 views

What is best practice for secure access to AWS, especially RDS?

After some reading (AWS docs, http://stratumsecurity.com/2012/12/03/practical-tactical-cloud-security-ec2/, etc..) I still don't understand how to organize secure & easy access to AWS (especially ...
0
votes
1answer
52 views

Multiple RDS Sync with Auto Scaling

I would like to allow for scaling of our RDS databases for an application but can't seem to find any information on how to keep multiple RDS databases in sync with the same data. Any ideas how to set ...
0
votes
1answer
62 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
1answer
938 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
705 views

how to fix slow query of mysql on Amazon and CPU 100% on the small rds instance [closed]

I am quite new to the both MySQL and AWS RDS service. I just find my query to the MySQL on a small RDS instance takes roughly more than 5 seconds. Besides, I notice with the CloudWatch that the CPU of ...
1
vote
1answer
688 views

MySQL Server hitting 100% unexpectedly (Amazon AWS RDS)

Please help! We've been struggling with this one for months. This week we upped our RDS instance to the highest performing instance and although the occurrences have reduced, we're still having ...
1
vote
1answer
777 views

Connecting to RDS database from EC2 instance using bind9 CNAME alias

Update: it's working by now. Turns out I was missing a valid DNS forwarder inside the named.conf.options file. I'm trying to get internal DNS up and running on a EC2 instance. The main goal is to be ...
4
votes
1answer
483 views

What is the best JDBC connection URI for AWS RDS instances?

When using an Amazon Web Services RDS instance from a Java application, what is the best JDBC connection string? It should tolerate the instance falling over to the standby. AWS handles flipping the ...
1
vote
1answer
681 views

LAMP server to AWS with HA and NFS

I am planning to use Amazon Web Service (AWS) to migrate my existing LAMP infrastructure to them. So I created a simple design of my system architecture with the following. *1 Elastic Load Balancer ...
0
votes
1answer
300 views

MySQL running on Amazon EBS EC2 performs a lot faster than Amazon RDS

Currently, I have MySQL running on EBS EC2 us-east-1c. I wanted to try Amazon RDS so created an instance running on "us-east-1b", but the response from the RDS is really slow. It takes about few ...
1
vote
3answers
2k views

MySQL query very slow on Amazon RDS but really fast on my laptop?

I would love to know if anybody knows why this is happening. i've just migrated over to Amazon RDS for our website and our biggest query which takes .2 seconds to execute on my macbook takes 1.3 ...
-1
votes
2answers
1k views

Remote Server can't access RDS Database

I'm having problems accessing my Amazon RDS MySQL Database from my server. I get this:- [Thu Sep 22 13:45:33 2011] [error] [client xx.xx.xx.xx] PHP Warning: mysqli::mysqli() [<a ...
0
votes
2answers
2k views

Easy GUI way to auto scale EC2 and RDS: aws console, scalr, ylastic…?

I am managing all my instances with the AWS Management Console (the GUI web console) but now I want to use Auto Scale and it seems that this can not be done with that console. Yes, there is CloudWatch ...
2
votes
2answers
2k views

Poor performance on Amazon RDS instance

I'm doing some load/stress testing on a PHP web application that is backed by a Small RDS database instance. When I hit the website with ~50 concurrent web requests, the RDS database just stops ...
1
vote
5answers
734 views

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan ...
6
votes
1answer
2k views

How do you recover you RDS master user username?

Resetting the RDS master user's password is simple enough, but how do you find your master users username?