Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Amazon RDS (Relational Database Service) is a distributed relational database service based on popular variants, running in the cloud. Currently supported are:

  • MySQL
  • Oracle
  • SQL Server
  • PostgreSQL

Additional Documentation:

549 questions
0
votes
1 answer

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?
Suman
  • 607
  • 1
  • 6
  • 12
0
votes
1 answer

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 mysqlslowdump command? If not, are there ways of…
user749618
  • 193
  • 1
  • 6
0
votes
2 answers

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
priya
  • 199
  • 1
  • 6
0
votes
1 answer

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 the JNDI DataSource. Is it possible to do that?
Random2
  • 19
  • 3
0
votes
1 answer

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, we are running two/three web servers (large…
luxerama
  • 189
  • 5
0
votes
4 answers

Remote Server can't access RDS Database

I'm having problems accessing my Amazon RDS MySQL Database from my server. I get this:- [Thu Sep 22 13:45:33 2011] [error] [client xx.xx.xx.xx] PHP Warning: mysqli::mysqli() [fqli-mysqli]: (HY000/2003): Can't…
WiseDonkey
0
votes
2 answers

Easy GUI way to auto scale EC2 and RDS: aws console, scalr, ylastic...?

I am managing all my instances with the AWS Management Console (the GUI web console) but now I want to use Auto Scale and it seems that this can not be done with that console. Yes, there is CloudWatch but I can only create alarms (e-mail…
Zillo
  • 111
  • 2
  • 4
0
votes
1 answer

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 data center. Does anything like this exist?
jnorris
  • 101
  • 2
0
votes
1 answer

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 10000s of warnings but I cannot find a way to output…
af-at-work
  • 670
  • 1
  • 6
  • 12
0
votes
1 answer

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 instance, to improve reliability and redundancy of our…
chrism2671
  • 2,579
  • 9
  • 34
  • 45
0
votes
1 answer

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 SSH which is not the case with RDS. I am not…
Cellfex Edgars
  • 111
  • 5
0
votes
1 answer

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 production server did a: mysqldump --single-transaction…
timoxley
  • 133
  • 1
  • 7
0
votes
2 answers

Hosting a MySQL server on Amazon Web Services

We are evaluating hosting our application on Amazon EC2 service. While I am confident that a Small instance (1.7GB RAM) will be sufficient for our web server (at this point), I am not sure about requirements for the MySQL server: Would it make sense…
Goro
  • 664
  • 3
  • 9
  • 18
0
votes
2 answers

How to architect my application on AWS cloud?

I am plannig to port an e-exam app on the aws cloud. I have decided to use a ELB, EC2 instances. But i am confused on wether to use a MYSQL DB server on amazon instance or to go for amazon RDS? Also what if my loadbalancer fails? What if I configure…
Jigish Chawda
  • 101
0
votes
1 answer

What is the data integrity of Amazon RDS? Do I need to make automated backups to S3?

I host my most valuable data on Amazon RDS. What is the failure rate of Amazon RDS, and what provisions do they have in place for high availability and data redundancy?
chrism2671
  • 2,579
  • 9
  • 34
  • 45
1 2 3
…
36 37