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

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 remove that and use the security group instead, it…
digidigo
  • 473
  • 1
  • 4
  • 8
0
votes
1 answer

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 the AWS rds server, it gave me SQLSTATE[HY000]…
Eugene Lim
  • 35
  • 5
0
votes
1 answer

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 the wizard though, I only get us-east-1a,…
0
votes
2 answers

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 reach my RDS instance that will be used to host…
0
votes
1 answer

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 intiates a snapshot of RDS Server A shutsdown RDS The…
J.Zil
  • 1,123
  • 3
  • 21
  • 29
0
votes
2 answers

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
CMag
  • 707
  • 2
  • 11
  • 32
0
votes
2 answers

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 certain level, some do it better than others.…
Flame_Phoenix
  • 131
  • 1
  • 6
0
votes
1 answer

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 example. Am I seeing this correctly: my existing code…
Roatin Marth
  • 103
  • 3
0
votes
1 answer

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. Instead I am assuming there is some kind of bankend…
J.Zil
  • 1,123
  • 3
  • 21
  • 29
0
votes
1 answer

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 clear and easy) ec2-describe-instances works just…
ericn
  • 553
  • 2
  • 8
  • 20
0
votes
1 answer

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 RDS instance went bottle-neck - CPU utilization was…
ericn
  • 553
  • 2
  • 8
  • 20
0
votes
4 answers

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 read. I am supposed to set the MySQL database…
ericn
  • 553
  • 2
  • 8
  • 20
0
votes
2 answers

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 user through SSMS, every other command will fail,…
0
votes
2 answers

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 less control of the db (e.g. only read)? However I…
StCee
  • 241
  • 3
  • 14
0
votes
1 answer

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 have is database (MySQL) related. As i am the…