Database Manager with MySQL 5.1 - 11H1.1
Published by RightScale on Oct 11, 2012Revision: 32
Description
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.
Contents
-
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
Revisions
Revision 32 | Oct 11, 2012
11H1.1 Maintenance Release.
Revision 16 | Mar 22, 2011
Release 11H1
Discussion
Hirokazu 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.
Cloud 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: http://www.cloudgurus.net/blog/2011/05/15/mySQL_Replication_with_SSL.html
Info
5 Ratings
Supported Clouds
Pricing
All Users
Sign-up for RightScale
Support Information
http://support.rightscale.com
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 http://myCloudWatcher.com/ e.m.g.