Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

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
577 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
644 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
669 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
144 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
313 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
644 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
492 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 ...
3
votes
1answer
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
222 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
537 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
114 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
206 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 ...
5
votes
2answers
490 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
789 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
106 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
694 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
2answers
1k 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
2k 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
408 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, ...
7
votes
2answers
6k 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
370 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
580 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
3k 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 ...
4
votes
1answer
945 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
536 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 ...
1
vote
1answer
264 views

How can I tell if I would benefit from upgrading my Amazon RDS instance?

I have several sites with very high traffic - all hosted on Heroku and all of which access a db.m1.large mySQL Amazon RDS instance - and would like to know if there would be a performance benefit in ...
2
votes
1answer
555 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 ...
3
votes
2answers
745 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 ...
2
votes
3answers
855 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 ...
3
votes
1answer
224 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 ...
4
votes
1answer
590 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 ...
6
votes
2answers
2k 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 ...
2
votes
2answers
3k 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 ...
0
votes
1answer
539 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 ...
3
votes
3answers
806 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 ...
1
vote
0answers
903 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: ...
1
vote
1answer
1k 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. ...
7
votes
4answers
3k views

Ways to auto scale MySQL servers?

I run a site which has high traffic surges and because of that auto scaling solutions is very profitable for this case. Currently the web server is able to horizontally auto scale but the bottleneck ...
0
votes
1answer
672 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?
2
votes
2answers
751 views

Efficient plan for backing up EC2 instance, EBS volumes and RDS DBs

I have an EBS-based EC2 instance (ebs_vol_1) which mounts and extra EBS volume (ebs_vol_2), and DB in RDS. Is tacking a snapshot of ebs_vol_1 & ebs_vol_2, enough for preventing data-loss? Is ...
0
votes
1answer
461 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
0
votes
2answers
509 views

Amazon AWS mysql RDS Cluster with outside AWS?

I'm now using AWS RDS multi-AZ with great results, the problem is that I want my infrastructure fault tolerant between regions. I'm looking for some kind of tool to make a cluster with RDS and my ...
0
votes
1answer
335 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
502 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. ...
1
vote
2answers
947 views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...