... more stuff
at
php-app-engine.com

Archive for the ‘RDS’ Category

Automatically scaling a LAMP application in the cloud

Saturday, January 16th, 2010

http://www.lindstromconsulting.com/node/8

In the previous article on the subject of cloud computing using AWS, we setup a simple LAMP application that used a single web server to present data that was queried from a single RDS instance. In this guide we will see how to save the changes we made to the EC2 instance, create more EC2 instances, and setup load balancing across our web servers.

tpcc-mysql rough benchmark for Amazon RDS

Thursday, December 17th, 2009

http://zuzara.com/blog/2009/11/01/tpcc-mysql-rough-benchmark-for-amazon-rds/

I tried to do tpcc-mysql benchmark for Amazon RDS. Before do that, did the same test for EC2 small instance.

This is a pretty rough benchmark, but I can say EC2 small instance and RDS small instance have the same performances as CPU and memory are the same spec. RDS is about 30% expensive. (EC2=$0.085, RDS=$0.11/h)

Capturing slow queries on Amazon RDS

Tuesday, November 24th, 2009

http://blog.hori-uchi.com/2009/11/amazonrdsslow-query.html

$ rds-modify-db-parameter-group acme-param-grp \
–parameters=”name=slow_query_log, value=ON, method=immediate” \
–parameters=”name=long_query_time, value=1, method=immediate” \
–parameters=”name=min_examined_row_limit, value=100, method=immediate”

Running Databases on AWS

Monday, November 16th, 2009

http://aws.amazon.com/running_databases/


This page contains the following categories of information.

* Amazon EC2 Relational Database AMIs
* Amazon Relational Database Service (Amazon RDS)
* Amazon SimpleDB
* Storage Practices and Backups
* Security
* Documentation and Case Studies

Top 10 Things to Know About Amazon RDS

Monday, November 16th, 2009

http://www.webyog.com/blog/2009/11/16/top-10-things-to-know-about-amazon-rds/

10. Amazon RDS uses a patched version of MySQL 5.1.38. While several discussions within MySQL forums allude to a growing concern that Amazon may not have the required expertise for upgrading and maintaining patched versions of MySQL, the fact still remains that Amazon has enough resources to just buy them from other vendors who do. The patch enables MySQL to scale dynamically in the cloud, besides adding other features.

Amazon RDS – The Beginner’s Guide

Saturday, November 7th, 2009

http://www.webyog.com/blog/2009/11/06/amazon-rds-the-beginners-guide/

On the eve of Microsoft’s announcement of the public release of SQL Azure Database, Amazon decides to release RDS. And that, too, after having resisted users’ demands for a relational database service for a very long time. Preemptive action, perhaps? Whatever it may be, I believe that such a healthy competition can do much good to the Cloud marketplace.

RDS brings with it the promise of MySQL on a Cloud. Having been a MySQL fan for quite some time now, I was itching to get my hands on an AWS account and check out what the hype was all about. Imagine my confusion when I signed up for Amazon RDS and all the AWS Management Console showed me was the EC2 dashboard! It was time I downloaded the Getting Started Guide and went through the rigmarole of studying it

Better one:

http://aws.typepad.com/aws/2009/10/introducing-rds-the-amazon-relational-database-service-.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+AmazonWebServicesBlog+%28Amazon+Web+Services+Blog%29

Amazon RDS and Django

Tuesday, October 27th, 2009

http://www.lonelycode.com/2009/10/27/amazon-rds-and-django/


Amazon has recently released a long-awaited feature addition to it’s Web Services infrastructure: Relational Databases. Having for a long time only had SimpleDB on offer (non-relational and weird to implement), it’s always been something of a struggle to get MySQL running on EC2.

Traditionally one would have to set up a block storage device, mount it, hack the mySQL configuration to use the mounted EBS volume for storage (not to mention messing around with XFS locking and snapshotting the DB when the instance goes down). All in all a pain to implement and maintain.

Now with Amazon’s Relational Database Service, you get a MySQL database, hosted in the cloud – auto backed-up, patched and running on a scalable infrastructure (you can re-size it to your hearts content) and at the same time independent of your instances – meaning no more messing around with block storage for your database.

Now RDS is actually completely compatible with all mySQL tools, so interfacing it with django is stupid simple – but, for those that want a quick walkthrough, I’ve prepared one below, from getting the service running to getting django to use it:

Amazon Launches Hosted MySQL Database Cloud Service

Tuesday, October 27th, 2009

http://www.techcrunch.com/2009/10/26/amazon-launch-relational-database-cloud-service/

Amazon has launched a hosted relational database service, Amazon RDS, as part of the suite of services available at AWS. The new service is a hosted MySQL database instance with the full capabilities and access rights as a normal self-hosted DB.