Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

4
votes
1answer
2k views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
1
vote
0answers
38 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
2answers
910 views

Can Amazon Elastic Beanstalk auto-scale Amazon RDS?

I'm planning to run a PHP/MySQL application using Amazon Elastic Beanstalk. In the settings I can define when it should launch new instances automatically (Auto-Scaling). However, as I understand ...
-1
votes
2answers
782 views

Amazon RDS - Can't connect to MySQL Server database?

I am trying to login to MySQL server using *nix shell prompt, following is my command : $ mysql ********** -east-1.rds.amazonaws.com:3306 (where the asterisks are my ID) I am getting following ...
0
votes
1answer
74 views

EC2 instance passes health checks but no longer can SSH in

I've had my website (an EC2 instance) running for a year now and everything was fine until this morning when I lost access to it and its associated database (an AWS RDS database instance). I can't ...
2
votes
0answers
870 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 ...
10
votes
2answers
3k views

How to associate an existing RDS instance to an Elastic Beanstalk environment?

I have created my RDS instance before creating my Elastic Beanstalk environment. The two are working together with no problem, but I'd like them to be linked together, and have the RDS parameters ...
4
votes
1answer
1k views

Is it possible to force Re-creation of EC2::Instance or RDS::DBInstance in amazon cloudformation?

It's possible to force the re-creation of a EC2 or RDS instance using cloudformation stacks? My stack goes stuck in a point where simply destroying and creating the resource will fix it, instead of ...
0
votes
1answer
213 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 ...
2
votes
1answer
2k views

What happens when RDS freeable memory runs out?

We have a rather large mysql instance on RDS and the freeable memory is starting to get low (<1GB) in the last 24 hours. What will happen if we reach 0 freeable memory? Does that mean all memory ...
1
vote
1answer
930 views

Amazon EC2 and Amazon RDS in Same Network

We have deployed our application in EC2 instance and our database is in RDS which is db.m2.2xlarge. I see some minor slowness in our application when compare to our QA environment where has both ...
1
vote
1answer
50 views

Does it make sense to restrict from where a user can connect to a RDS, if already using a DB security group?

Since AWS' RDS have a firewall based on EC2 security groups (or IP ranges), is it meaningful at all to also restrict connections' origins by restricting users?
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
295 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
995 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
5k 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
72 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
261 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
100 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
273 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
7k 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
2answers
1k 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
381 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
65 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 ...
2
votes
1answer
4k 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
124 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
571 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
64 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. ...
2
votes
1answer
216 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
832 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 ...
4
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
665 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
788 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
890 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
3k 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
726 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
1k 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 ...
2
votes
1answer
1k 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
165 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
427 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
836 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
699 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
4k 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
282 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
91 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
2k 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
788 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
125 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? ...