Amazon RDS (Relational Database Service)
1
vote
1answer
455 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
287 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 ...
3
votes
1answer
241 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 ...
1
vote
1answer
625 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
2answers
618 views
How different is an Amazon EC2 RDS DB Instance different from the normal EC2 Instance?
How different is the Amazons RDS DB Instance different from The normal EC2 Instance other than the fact that RDS DB Instance has a Database server running on it?
When an EC2 Instance goes down all ...
3
votes
2answers
357 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
0answers
199 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, ...
0
votes
0answers
18 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
222 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
235 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 ...
1
vote
0answers
615 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: ...
3
votes
1answer
182 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
1k views
Does Amazon RDS support multiple databases per instance?
Title says it all... does it support multiple databases, or do I have to create a new instance for each database?
3
votes
1answer
563 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?
3
votes
1answer
266 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 ...
2
votes
1answer
229 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
816 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
484 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 ...
1
vote
2answers
1k 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
492 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 ...
1
vote
2answers
2k 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 ...
2
votes
2answers
902 views
AWS EC2 dns resolution diagnostic
I am using EC2 instances with amazon linux installed (with amazon dns server settings, which comes from DHCP), as well as an RDS database. The EC2 instances are behind ELB and get high traffic. The ...
2
votes
1answer
410 views
How do you recover you RDS master user username?
Resetting the RDS master user's password is simple enough, but how do you find your master users username?
0
votes
1answer
187 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 ...
6
votes
4answers
2k 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 ...
1
vote
1answer
511 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.
...
1
vote
0answers
268 views
Migration to Amazon Web Services… How to choose instance size? [closed]
We are currently using Rackspace Cloud Sites for hosting a lot of company-related websites. Because of shortcomings with the service (stuff like no SSH access...), we are considering moving to another ...
-1
votes
2answers
126 views
RDS or SQL Azure, which one do you recommend? [closed]
I have developed a web applicaiton that does soem heavy DB work. I have developed the application using ASP.net and SQL Server 2008 Express. I wanted to know which service I should use, Amazon RDS or ...
0
votes
1answer
425 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
286 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
52 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
215 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
153 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
211 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
359 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
0answers
438 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 ...
0
votes
1answer
225 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, ...
2
votes
1answer
304 views
Low transfer rates on Amazon's EC2
I have a question re transfer rates on Amazons EC2. Basically I am evaluating a move to the Amazon stack of services, however wanted to benchmark it against our current setup first.
My setup is pretty ...
0
votes
1answer
262 views
MySQL running on Amazon EBS EC2 performs a lot faster than Amazon RDS
Currently, I have MySQL running on EBS EC2 us-east-1c. I wanted to try Amazon RDS so created an instance running on "us-east-1b", but the response from the RDS is really slow. It takes about few ...
0
votes
1answer
198 views
Show warnings from mysqlimport
I'm running a job from a Linux box to an Amazon RDS (MySQL) that pumps in about 1GB of data via mysqlimport. It runs flawlessly, however, when I attempt the exact same command with windows I get ...
5
votes
1answer
282 views
Strategy for maintaining Amazon RDS instance on prod vs development
How do you folks manage your Amazon RDS instances? In production I obviously want to use Amazon RDS with a master-slave replication setup going. Unfortunately this incurs substantial costs to bring ...
0
votes
1answer
213 views
Open source alternatives to Amazon RDS for the data center?
I'm looking to for a technology that is similar to Amazon RDS, where the engine (ie: WS management, setting up, operating, HA, backups, point in time recovery, scale, etc.) can be deployed in your own ...
0
votes
1answer
127 views
Amazon RDS instance stopped responding
We've been running a large RDS instance in production for over year without a single moment of downtime. Recently, with a bigger budget and higher stakes, we decided to convert it to a multi-AZ ...
1
vote
1answer
1k views
How to create a local backup of a remote Amazon RDS MySQL database?
How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be ...
1
vote
1answer
805 views
How to Sync data from one amazon RDS to another?
Hi i am pretty new to Amazon RDS.my question how to Sync data from one amazon RDS machine to another? like taking a mysql Dump or something like that, and is it possible to Sync over multiple regions ...
2
votes
1answer
248 views
Scaling by moving Database to Amazon RDS
We have a situation with an Application which is hosted on a dedicated server where we are anticipating a potential surge in traffic. The major bottleneck on the app is MySQL which is heavy on read ...
-1
votes
1answer
271 views
How to store WHM data on remote MySQL without ssh
Is it possible to connect WHM to remote MySQL server without ssh? Thing is I am hosting WHM on Amazon EC2 and want to move all MySQL databases to Amazon RDS, but WHM by default supports connection via ...
1
vote
1answer
106 views
Amazon RDS: Is it possible to have more than 5 read replicas?
The FAQ seems to suggest that you can't have more than 5 replicas. Is there any workaround?
4
votes
3answers
2k views
Why can't I connect to Amazon RDS after setting it up?
So, I just created the Amazon RDS account.
And I started an instance of database.
The "endpoint" is:
abcw3n-prod.cbmbuiv8aakk.us-east-1.rds.amazonaws.com
Great! Now I try to connect to it from one ...
