Amazon RDS (Relational Database Service)
0
votes
1answer
35 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 ...
1
vote
2answers
52 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
0answers
36 views
Amazon vs Owned Hosting: Performance [duplicate]
Disclaimer: I am not an Amazon aficionado by any means. My background is in mostly "traditional" system deployments as opposed to any cloud technologies. Also, this is not a "shopping" question - I am ...
0
votes
1answer
25 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
0answers
26 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
15 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 ...
0
votes
0answers
42 views
AWS RDS Parameter Group Deployment Guide: For Replicated Instances?
I am part of a team that manages a small DB cluster, including Multi-AZ and Read-Replicas. I found the following deployment guide:
...
0
votes
1answer
119 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
1answer
93 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
1answer
70 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
0
votes
1answer
34 views
Which Open Source Cloud Management Platform supports Amazon-RDS?
I have been trying to use Amazon Web services, specially EC2 and RDS. Nowadays most CMP (Cloud Management Platform) like Eucalyptus, OpenNebula, OpenStack, Nimbus and CloudStack all support Ec2 to a ...
0
votes
1answer
89 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
78 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
128 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
42 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
74 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 ...
0
votes
1answer
121 views
Malformed input-Unknown service URL provided: rds.ap-southeast-1a.amazonaws.com
I ran rds-describe-db-instances and encountered that error.
I've trying searching for service URL for RDS button nothing found (I've gone through the same thing for EC2 command line tools and it was ...
0
votes
0answers
63 views
Plugin for Innotop: killing RDS queries
It would be cool/helpful/life affirming to be able to kill rds queries via innotop. Does anyone know if a plugin exists for this?
Here's why innotop can't kill queries out of the box: Amazon RDS ...
1
vote
3answers
143 views
MySQL : Separate Log File for Each Database
I have a server with multiple databases on it. Its actually an instance on AmazonRDS so I do not have access to the my.cnf file. What I am trying to do is a create a log for each database separately ...
1
vote
1answer
271 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
254 views
Wordpress : Shift from local MySQL to Amazon RDS Mysql?
i have a 32 bit Bitnami ubuntu wordpress stack ami for amazon and hence a working wordpress installation. My questions are
1)How can i shift over to amazon RDS mysql from local MySQL. And if more ...
1
vote
2answers
164 views
EC2 Ubuntu with WordPress can't connect to RDS
I have set up a WordPress website on a Ubuntu 12.04 Amazon ec2 machine by following this tutorial except the fact that I haven't created a MySQL database and I am using an amazon RDS MySQL service.
...
1
vote
3answers
157 views
Install wordpress using amazon RDS
Now this is weird!
I am trying to install a WordPress website on a Amazon EC2 server with Ubuntu 12.04 LTS and [amazon RDS][1] database service.
I have installed apache and wphp and ran the required ...
1
vote
1answer
220 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 ...
0
votes
1answer
240 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 ...
0
votes
2answers
147 views
How to use read replica instance for websites? Amazon RDS MySQL
Amazon RDS FAQs stated that it is up my application to distribute traffic to the read replica.
My websites have mostly visitors - non-logged in users. So, I suppose most database activities are ...
1
vote
1answer
162 views
Possible to join an Amazon RDS SQL Server 2008 instance to a Windows Domain?
We're planning on using an Amazon RDS MS SQL Server 2008 instance in our Amazon VPC. Since we don't have access to the underlying OS for RDS, I was wondering if it's at all possible to join an RDS ...
1
vote
1answer
101 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 ...
0
votes
2answers
90 views
In Amazon RDS, how can a disabled master user be re-enabled?
With a SQL Server instance on Amazon RDS it is possible to do the following to your master user:
ALTER LOGIN masteruserid1 DISABLE
GO
If this command is executed while logged in as the that master ...
2
votes
2answers
256 views
Setting the timezone in MySQL on every connection using Zend PHP
My company just recent moved our MySQL database to and instance Aamazon Web Service's RDS.
The problem is the application relies on time zone information and the timezone in MySQL (under RDS) is set ...
1
vote
1answer
122 views
Amazon RDS connection issues
It seems that my database instance had a failover in the middle of the night and changed IP address. My webserver connects to it remotely. The IP address, which is found from Amazons DNS service that ...
2
votes
1answer
903 views
AWS RDS MySQL / SLow Query Log
I'm trying to analyze slow queries on my system and I read that I should enable the "Slow Query Log'. I curious how I can I view this log when I'm using an instance of MySQL hosted on Amazon Web ...
1
vote
1answer
106 views
What is the database server usage size available with the Amazong AWS RDS free usage tier?
At http://aws.amazon.com/free/, the documentation indicates the Free Usage Tier comes with 30 GB of Amazon Elastic Block Storage, and for database/RDS, 20 GB of database storage.
When I create launch ...
0
votes
2answers
69 views
Amazon RDS and users, security
By default you got a username and password for your RDS database. Would it be dangerous to use the credentials on your production website, say in php files?
Or is it necessary to create a user with ...
3
votes
1answer
242 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
0answers
275 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 ...
0
votes
1answer
77 views
amazon aws, rds
just need a quick info on two questions but very related.
1 if we use rds on amazon aws, what happens if some of the machines rds is running on crash? i mean what happens with the data? is it gone?
...
-2
votes
1answer
146 views
Cheapest High Available Web Server [closed]
I would like to create a high-available setup (e.g. a small cluster) for a webserver, i.e. it will run Apache, PHP and MySQL.
There will be between 2-8 small websites running with only very little ...
3
votes
1answer
188 views
Does Amazon EC2 and RDS have ECC memory?
I know that Amazon's Cluster GPU Instances have ECC memory as mentioned on their blog but there's no mention of other instance types. There's a forum post from back in 2007 that went unanswered. Does ...
2
votes
2answers
270 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 ...
2
votes
1answer
89 views
Amazon syn between regions
We have an app on amazon servers on US-east region.
The whole setup contains 2 ec2 instances behind a load balancer, an rds instance and an elasticcache instance which are all located in the US-east ...
1
vote
1answer
504 views
When trying to create a trigger in RDS I get an error about binary logging
When trying to create a trigger in RDS, I get the following error:
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is
enabled (you *might* want to use the less safe ...
0
votes
1answer
290 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 ...
1
vote
1answer
670 views
Allow any ip to connect to Amazon Web Services RDS using MySQL
Is it possible to allow any IP to connect to a Amazon RDS instance using MySQL?
Explaining my scenario as requested in the comments:
Amazon RDS by default blocks all the incoming connections which ...
2
votes
1answer
203 views
Using Amazon RDS (or similar) as a slave
Officially, RDS instances can't be directly set up to slave non-RDS databases.
My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, ...
2
votes
2answers
1k views
AWS RDS connection count
I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that ...
0
votes
0answers
19 views
Query Mysql on iddle processes
I would like to know if there is any method to do some queries just if the database is not stressed.
In my case, I have some kind of queries that could wait, in this case I could try to do this ...
0
votes
1answer
226 views
MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS
I will be uploading a web application to amazon ec2 instance in the next couple of weeks.
I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS.
The only confusion i ...
2
votes
3answers
257 views
amazon dynamoDB or MySQL for storing large arrays inside each row
I am trying to decide which database I should use for an application I'm making. I was leaning toward dynamoDB because of its scalability, but then I read in the documentation which said:
there ...
7
votes
2answers
2k views
RDS Replication across regions
We are using Amazon AWS for our web services but given the recent instabilities in their infrastructure, we are trying to figure out how to run our application across multiple regions for additional ...
