Tag Archives: tools

MySQL on RAID0 and useful MySQL tools

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

Stuff to check out for Linux SysAdmin clustering and scalability tools

Puppet is an open-source next-generation server automation tool. It is composed of a declarative language for expressing system configuration, a client and server for distributing it, and a library for realizing the configuration.

The primary design goal of Puppet is that it have an expressive enough language backed by a powerful enough library that you can write your own server automation applications in just a few lines of code. With Puppet, you can express the configuration of your entire network in one program capable of realizing the configuration. The fact that Puppet has open source combined with how easily it can be extended means that you can add whatever functionality you think is missing and then contribute it back to the main project if you desire.
http://reductivelabs.com/trac/puppet

Hypertable is an open source project based on published best practices and our own experience in solving large-scale data-intensive tasks. Our goal is to bring the benefits of new levels of both performance and scale to many data-driven businesses who are currently limited by previous-generation platforms. Our goal is nothing less than that Hypertable become one of the world’s most massively parallel high performance database platforms.
http://www.hypertable.org/