Category Archives: Uncategorized

Now Open: AWS Region in Asia Pacific

1 Reply

“Businesses and developers in the Asia Pacific part of the world can now obtain their processing, storage, and other services on an economical, pay-as-you-go basis from resources located nearby.

We’ve just opened up an AWS Region in Singapore, with two Availability Zones. The new region supports Amazon EC2 (including Elastic IP Addresses, Amazon CloudWatch, Elastic Block Storage, Elastic Load Balancing, and Auto Scaling), Amazon S3, Amazon SimpleDB, the Amazon Relational Database Service, the Amazon Simple Queue Service, the Amazon Simple Notification Service, Amazon DevPay, and Amazon CloudFront. The page for each service includes full pricing information for the Singapore Region.

Read more here

MySQL on RAID0 and useful MySQL tools

Leave a reply

Maintaining a production DB containing 15-25M rows show best improvement with the use of RAID0 on EC2 platform. Having a MySQL master-slave replication of servers and keeping the documented procedure is very handy for restoring the DB and the RAID volumes.

Documenting the process on downgrading and upgrading RAID0+MySQL from large to xlarge EC2 instance or vice versa helps a lot.

The links below best describes the RAID0 performance for IO operations on EC2 and how to setup the EBS RAID0 and MySQL in your machine.

RAID0 Refrences
IO Performance on EBS
EC2 EBS SINGLE AND-RAID VOLUMES IO BENCHMARK
EC2 EBS RAID
mdadm: A New Tool For Linux Software RAID Management
Running MySQL on Amazon EC2 with Elastic Block Store

MySQL Tools
EC2 Consistent Snapshot
Using Maatkit to restore Slave-Master
Maatkit.Org
MySQL Sandbox
Auto MySQL Backup