MultiCloud Marketplace


MySQL 5.1 EBS v2

Open in Dashboard

Published by RightScale on Oct 08, 2010Revision: 19 This component has been deprecated by the publisher.


The RightScale Database Manager for MySQL is one of our most popular premium ServerTemplates. It provides a high-availability master/slave database configuration that can be used as the backbone for a variety of applications and workloads. This second version incorporates many of the learnings from our first version, which has been used in a variety of production environments for more than a year. Finally, it is cloneable, just like any other RightScale ServerTemplate, so you can make adjustments specific to your organization's technology or work flow needs.

Features include: * Master or slave roles, including multiple read slaves * Use of external volumes for MySQL data storage * Support for striping of external volumes for faster database performance * Continuous snapshot backups using a grandfather-father-son paradigm * Assisted database restoration, including stripe re-creation * DNS management for master to slave fail-over, restoration of master, and more * Pre-configured monitoring and alerts

To get started with the Database Manager for MySQL ServerTemplate, please read the MySQL Database Setup Tutorial.


  • MultiCloudImage: RightImage Ubuntu_9.10_i386_v4.5 [rev 5]

  • MultiCloudImage: RightImage Ubuntu_9.10_x64_v4.5 [rev 6]

  • RightScript: DB unfreeze binary backups v1 [rev 2]

  • RightScript: DB EBS restore and become master v2 [rev 17]

  • RightScript: DB EBS slave init at boot v2 [rev 12]

  • RightScript: DB EBS slave init v2 [rev 12]

  • RightScript: DB MySQL 5.1 server install [rev 3]

  • RightScript: DB MySQL gem install v8 [rev 3]

  • RightScript: DB Rightscale tools install v11 [rev 22]

  • RightScript: DB TERMINATE SERVER - Delete EBS volume and halt v2 [rev 9]

  • RightScript: DB check master DNS TTL [rev 3]

  • RightScript: DB freeze binary backups v1 [rev 2]

  • RightScript: DB privileges set v1 [rev 5]

  • RightScript: DB EBS promote to master [rev 8]

  • RightScript: DNS dnsmadeeasy external id register v1 [rev 4]

  • RightScript: MAIL Postfix Local Delivery v2 [rev 5]

  • RightScript: MISC ssh priv key install v2 [rev 4]

  • RightScript: RB rubygems 1.3.1 + quickinstall v4 [rev 4]

  • RightScript: DB EBS backup [rev 10]

  • RightScript: DB EBS continuous backups v2 [rev 14]

  • RightScript: SYS Add Swap Partition [rev 7]

  • RightScript: SYS Monitoring File Stats Add [rev 5]

  • RightScript: SYS Monitoring MySQL add v8 [rev 5]

  • RightScript: SYS Monitoring install v8 [rev 11]

  • RightScript: SYS Syslog Remote Logging Client v7 [rev 6]

  • RightScript: SYS Timezone set v1 [rev 5]

  • RightScript: SYS lvm install v1 [rev 3]

  • See More



44b0c3eb040f1eac48bfe75848363bf8myCloudWatcher on Jun 27, 2010 | Re: v13

This new MySQL Template is better than any version before. But I do have a few comments: This is tuned for 100% INNODB use on very large instance sizes. If you are 100% MyISAM user you will need to adjust DOWN the INNODB values before use. If you see that about 80% of memory is not in use for RSS of the mysqld process you may have this issue. To check, just inventory your INNODB vs MyISAM use and set the KEY and INNODB values as needed to share resources. The myCloudWatcher team can help you adjust these value and tune up your DB to use all of the memory you paid for on each instance size. Edward M. Goldberg

44b0c3eb040f1eac48bfe75848363bf8myCloudWatcher on Aug 05, 2010 | Re: v13

I keep LAUNCH-ing more and more of these great servers. I still pick this template for all Database servers that ise 5.1 mySQL. I have found that the my.cnf does need to be tuned for most users. So after you have launched the server take a look at the my.cnf file and check to see if your needs are meet my the settings. The performance with the "STOCK" RightScale values is great for INNODB projects. Edward M. Goldberg,

44b0c3eb040f1eac48bfe75848363bf8 myCloudWatcher on Jan 10, 2011 | Re: v19

You need to add "RightScale Services SYS Monitoring MySQL Seconds Behind Master Add v1" if you want to see the Slave Lag in your plots. This is a great script. It should be in this template by default. This RightScript can be added at anytime after LAUNCH also, so add it to all old servers now!!


2 Ratings

Supported Clouds


Available to Paid
RightScale Accounts

Sign-up for RightScale

Support Information