Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

2
votes
1answer
301 views

amazon RDS Security Groups Issue

We had a odd issue today related to the security groups in our RDS. All the sudden, without any changes from our end, our RDS instance's security group stopped working. No server was able to connect ...
0
votes
1answer
127 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
654 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 ...
2
votes
2answers
974 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 ...
0
votes
1answer
72 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
265 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
922 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 ...
1
vote
1answer
764 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
1k 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
1k 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
857 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 ...
0
votes
2answers
514 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 ...
0
votes
2answers
2k 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 ...
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
1answer
189 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 ...
2
votes
5answers
4k views

Can't authorize a server for Amazon RDS

We are attempting to slowly migrate a website over to AWS among other things. We decided the first thing to move was the database. We have some dedicated server with a different hosting provider. We ...
1
vote
1answer
338 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
93 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
3answers
1k views

I/O intensive MySql server on Amazon AWS

We recently moved from a traditional Data Center to cloud computing on AWS. We are developing a product in partnership with another company, and we need to create a database server for the product we'...
2
votes
3answers
2k views

Tool to test MySQL latency [closed]

I want to compare the latency of my web application against two different MySQL servers: one a local machine and one hosted via Amazon RDS. What would be a good, free, and (preferably) easy tool to ...
1
vote
0answers
1k 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 ...
-2
votes
1answer
272 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 ...
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
4k 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
920 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 ...
4
votes
1answer
970 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 ...
2
votes
1answer
4k 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
2answers
1k views

AWS document on number of databases allowed on an Amazon RDS instance

At the Amazon RDS FAQ there is the question "What is a database instance (DB Instance)?". The entire answer (as of mid-June 2012) is: You can think of a DB Instance as a database environment in ...
0
votes
1answer
509 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
862 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
4k 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 ...
1
vote
0answers
1k views

Cannot connect to MySQL on RDS (Amazon Web Services) from my laptop

I'm having some trouble connecting to a MySQL 5.1 server on an RDS instance on AWS from my laptop. The detailed description of the problem is here: https://forums.aws.amazon.com/thread.jspa?messageID=...
3
votes
1answer
266 views

AWS - bigger EC2 instance or DB split

I am running a website of off a small EC2 instance. The memory on the instance is maxed out, mostly due to SQL server process. I am thinking about either upgrading to a medium instance or staying with ...
5
votes
1answer
1k views

On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?

I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
4
votes
1answer
707 views

Amazon AWS VPC Performance Advantages

We have a simple setup that consists of... 1 EC Instance for HTTP/PHP requests 1 RDS Instance for our Database requests Currently our two servers do not use VPC to communicate. I was wondering if ...
3
votes
1answer
1k views

What is the Amazon RDS tenancy model?

My organization would like to better understand the Amazon RDS architecture. In particular, my managers would like to understand RDS's "tenancy" model, that is, how the service accommodates multiple ...
0
votes
1answer
2k views

Update RDS db via mysqlbinlog: “you need (at least one of) the SUPER privilege(s)”

We are moving a production site to EC2/RDS Followed these instructions: http://geehwan.posterous.com/moving-a-production-mysql-database-to-amazon I have set up row-based binary logging on the ...
1
vote
2answers
523 views

RDS, scalr with EC2 or xeround for a 40GB database

We are currently preparing for a move of a reasonably high traffic web site to the cloud. We are thinking of using scalr to help us manage the whole setup especially since we dont have experience ...
6
votes
2answers
3k views

Amazon RDS: What are IO Requests?

I have an RDS instance that is costing me a lot of money. From my account activity on amazon I see that the instance has had about 800,000,000 IO requests over the past 7 days. To give you a little ...
3
votes
2answers
4k views

How can I setup a VPN for remote users to connect to a AWS RDS server?

I have remote developers that travel and have constantly changing IP addresses. I would like them to be able to connect to a VPN running on a instance on EC2. Once they are connected to the VPN with a ...
1
vote
1answer
807 views

Amazone RDS change Class or copy to new instance

I have a RDS instance and I want to change this class to a smaller class, from xlarge to large. I try to do this in console, but it doesn't work. May be it's easier to create new instance and copy ...
1
vote
1answer
2k views

mysql 5.5 character encoding in Amazon RDS

I recently setup mysql 5.5.20 database in Amazon RDS with movable type but actual character encoding doesn't take effect. I change the parameter group setting to utf8 like below. character-set-client-...
0
votes
1answer
844 views

Amazon RDS: encryption on port 3306?

It looks like Amazon's RDS instances have encryption turned off for their connections - is there a way to turn on SSL encryption on RDS instances?
0
votes
1answer
644 views

Parser or export for slow queries table (mysql.slow_log) on AWS RDS?

So I turned on slow query logging in my Amazon RDS instance (via the method here), and now I'm wondering how to parse the data collected in the slow queries table (mysql.slow_log). Can I use the ...
0
votes
2answers
53 views

Is there a way to obtain the list of client machines which connect to an EC2 instance

We would like to monitor the list of client machines (IP addresses, login, logout times) which connect (e.g. via ssh) into a Amazon EC2 | RDS instance
3
votes
1answer
302 views

Is it possible to backup an Amazon RDS database to another service?

I moved my site's database to RDS a few months ago. At the time, I finally decided I was ready to have a dedicated database server, and during the process of setting one up on EC2, I discovered RDS. ...
2
votes
3answers
191 views

How do I quickly create new instances of complex MySQL database?

I'm managing an enterprise web application that uses Amazon's RDS as our database server. Our architecture is such that when a user signs up for a new account we create a brand new database for them ...
0
votes
1answer
448 views

Encrypted MySQL Connection with JNDI DataSource in Tomcat 6

I want to encrypt a connection to an Amazon RDS MySQL server. I have the .pem and can connect to the server using mysql --ssl_ca=file.pem in bash, but I need to connect to the server in a web app with ...
5
votes
1answer
607 views

MySQL transaction issue with Django and Amazon RDS

I'm having a problem with a MySQL 5.5 database instance running on Amazon RDS. Periodically (once every couple of days) a transaction will fail to complete and appears to leave the tables locked. ...
0
votes
1answer
399 views

amazon aws network latency issues

We have just started to move our infrastructure to Amazon's AWS (EU West). Since we started the move we have started seeing some quite substantial spikes in network latency. Our setup is quite simple, ...