All Questions
25
questions
3
votes
2
answers
12k
views
Connecting to an RDS from an EC2 on the same VPC
I have an RDS instance running on one subnet without NAT, and an EC2 instance running on another subnet with an Internet Gateway configured, both located in the same VPC. I have configured the RDS ...
1
vote
0
answers
352
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
1
answer
1k
views
RDS to EC2 mysql replication
I would like to create a RDS mysql and to replicate it to an EC2 server so the DB will be local and thus the query time will be faster (the EC2 is a web server).
According to the second paragraph here ...
-1
votes
1
answer
379
views
Why the latency increases on highload? [closed]
We have a system built on AWS. We use Beanstalk, we have autoscaling, our database (mysql) is hosted on RDS. We use apache and php. We wanted to test our system on highload. So, we chose large ...
-1
votes
2
answers
176
views
Who is responsible for performing the query EC2 or RDS?
Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ).
As I understand RDS is (directly after setup) optimized for ...
4
votes
1
answer
4k
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 ...
11
votes
3
answers
16k
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
1
answer
2k
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 ...
6
votes
1
answer
12k
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
3
answers
2k
views
MySQL - Slow query - wp_options table. Website unable to handle traffic
After spending several days researching, I have placed a website on a c1.medium instance, Amazon Linux, and the MySQL database on a db.m1.instance. The RDS is running MySQL version 5.6.13. I have ...
0
votes
1
answer
456
views
Why is my MySQL going offline?
I have 2 applications hosted in a windows server 2008 r2 (AWS EC2 Large instance)machine, using IIS7.5 and mysql 5.5.12. The one database is hosted on the server with a local DB instance the other DB ...
1
vote
3
answers
6k
views
Can't connect from EC2 to RDS via PHP. I can directly thought
I've set up an EC2 instance it has mysql and php-mysql installed (not mysql-server).
I've set up an RDS instance and set the security group to the EC2 instance.
I can connect via the command line ...
0
votes
1
answer
2k
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 ...
5
votes
1
answer
5k
views
How do I debug lock timeouts with MySQL / Amazon RDS?
We've got a web app hosted on Amazon Web services. Our database is a multi-az RDS MySQL server running 5.1.57 and 3-4 app servers talk to it.
Today, we started seeing a lot of errors along the lines ...
1
vote
1
answer
2k
views
PHP occasionally fails to connect to mysql server
I have a php script on my server which is called by my client app to log some information into a remote mysql server. The scripts works fine, but occasionally (only occasionally) the script fails to ...