Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

1
vote
1answer
3k 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
225 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
790 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 ...
0
votes
2answers
1k 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 ...
5
votes
5answers
4k 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
65 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
2answers
226 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
87 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
233 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: ...
1
vote
2answers
5k 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
703 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
2answers
345 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
56 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 ...
1
vote
1answer
3k 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
116 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
502 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
60 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
190 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
726 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 ...
3
votes
4answers
1k 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 ...
3
votes
1answer
1k 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
601 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
633 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
698 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 ...
2
votes
2answers
2k 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
666 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
782 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
867 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
154 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
354 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
763 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
617 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 ...
4
votes
2answers
3k 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
247 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
88 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
1k 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
685 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
votes
1answer
123 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
215 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 ...
6
votes
2answers
552 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
3answers
953 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
109 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 ...
2
votes
1answer
2k 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 ...
1
vote
1answer
754 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 ...
2
votes
1answer
2k views

Does an Amazon RDS endpoint change in the event of instance failure?

I would like to know if an Amazon RDS endpoint ever changes when a DB instance crashes and is brought back up. I want to setup 2 EC2 instances (additional EC2 instances may be spun up depending on ...
1
vote
1answer
3k 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 ...
3
votes
1answer
448 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, ...
9
votes
3answers
7k 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
1answer
395 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
635 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 ...