MultiCloud Marketplace


Database Manager with MySQL 5.1 - 11H1

Open in Dashboard

Published by RightScale on Oct 11, 2012Revision: 32 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. 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 * Choice of DNS providers (DNS Made Easy, DynDNS, AWS Route53) ---- This ServerTemplate is part of a compatibility release. Note: Micro instance types and Start/Stop functionality are not supported.


  • MultiCloudImage: RightImage_CentOS_5.4_i386_v5.6 - 11H1 [rev 16]

  • MultiCloudImage: RightImage_Ubuntu_10.04_x64_v5.6 - 11H1 [rev 12]

  • MultiCloudImage: RightImage_Ubuntu_10.04_i386_v5.6 - 11H1 [rev 13]

  • MultiCloudImage: RightImage_CentOS_5.4_x64_v5.6 - 11H1 [rev 16]

  • RightScript: DNS Tools install - 11H1 [rev 18]

  • RightScript: DB EBS slave init - 11H1 [rev 6]

  • RightScript: DB EBS slave init at boot - 11H1 [rev 7]

  • RightScript: DB Freeze binary backups - 11H1 [rev 4]

  • RightScript: DB MySQL 5.1 gem install - 11H1 [rev 2]

  • RightScript: DB MySQL 5.1 server install - 11H1 [rev 27]

  • RightScript: DB Privileges set - 11H1 [rev 6]

  • RightScript: DB Rightscale tools install - 11H1 MR [rev 3]

  • RightScript: DB TERMINATE SERVER - Delete EBS volume and halt - 11H1 [rev 5]

  • RightScript: DB Unfreeze binary backups - 11H1 [rev 4]

  • RightScript: DNS External id register - 11H1 [rev 9]

  • RightScript: DB EBS restore and become master - 11H1 [rev 11]

  • RightScript: MAIL Postfix local delivery - 11H1 [rev 5]

  • RightScript: MISC SSH private key install - 11H1 [rev 8]

  • RightScript: DB Check master DNS TTL - 11H1 [rev 6]

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

  • RightScript: DB EBS continuous backups - 11H1 [rev 9]

  • RightScript: DB EBS backup - 11H1 [rev 7]

  • RightScript: SYS Add swap partition - 11H1 [rev 13]

  • RightScript: SYS Disable UEC cronjob - 11H1.1 [rev 3]

  • RightScript: SYS Lvm install - 11H1 [rev 8]

  • RightScript: SYS Monitoring MySQL 5.1 add - 11H1 [rev 2]

  • RightScript: SYS Monitoring file stats add - 11H1 [rev 8]

  • RightScript: SYS Monitoring install - 11H1 [rev 12]

  • RightScript: SYS Syslog remote logging client - 11H1 [rev 12]

  • RightScript: SYS Timezone set - 11H1 [rev 7]

  • See More



44b0c3eb040f1eac48bfe75848363bf8 myCloudWatcher on May 09, 2011 | Re: v16

This is the current best MySQL 5.1 EBS Templet. The only changes that I make are to adjust the Alerts to match the needs of the application. For example 2G free for ROOT works better for an early alert. The 1G in the template is too late. Keep the EBS Volumes LARGE, try 300G over 3 EBS Volumes ( 100G each ) to start with for good performance. NEVER set a root password for LOCALHOST or the backups stop working. Please call any time: Cell:     916-202-1600 Skype:  EdwardMGoldberg Edward M. Goldberg e.m.g.

C4ca0e0001ce9fb5391d1c0a06fa5b64Hirokazu Narita on May 20, 2011 | Re: v16

I'm using this template on ja_JP.UTF-8 environment. By running following command. `echo "LANG=ja_JP.UTF-8" > /etc/sysconfig/i18n` Then, this cannot detect MySQL running status in backupDB.rb and restoreDB.rb. So I run following command. sed -i "s/s\.+is running/s.+pid/" /opt/rightscale/db/ec2_ebs/backupDB.rb sed -i "s/s\.+is running/s.+pid/" /opt/rightscale/db/ec2_ebs/restoreDB.rb Then work well.

565f31581c2dd888722d87c27e9bab43Cloud Gurus on Jun 08, 2011 | Re: v16

Template works great in the same AWS region. For HA / disaster recovery, you need hot slave in a different region. One possible solution:

Ad16f9e341a478de800d42583c4a196dBlair Trosper on Sep 22, 2013 | Re: v32

Great template, but cannot be launched in the US-WEST-2 region of AWS (Oregon). You should be aware of this limitation before using it for HA/DR.


6 Ratings

Supported Clouds


All Users

Sign-up for RightScale

Support Information