MultiCloud Marketplace

RightScale

Database Manager for MySQL 5.5 (v12.11.3-LTS)

Open in Dashboard

Published by RightScale on Nov 20, 2012Revision: 12

Description

This ServerTemplate is on the LTS Lineage. For the latest Infinity version, see the Infinity Lineage
For a description of the Infinity and LTS lineages, see ServerTemplate Release Methodology

Configures a MySQL 5.5 database server. This ServerTemplate provides a high-availability master/slave database configuration that can be used as the backbone for a variety of applications and workloads.

The ServerTemplate supports multiple clouds, using either instance-based storage or attachable volumes. Instance-based snapshot backups are automatically uploaded to your choice of remote object storage (Amazon S3, Rackspace Cloud Files, or SoftLayer Object Storage). It also includes iptables management for clouds that do not have firewall services.

Key Features:

  • Master or slave roles.
  • Uses attachable volumes or instance-based LVM volumes for primary backup.
  • Supports a secondary, disaster-recovery backup to S3, Cloud Files, or SoftLayer Object Storage remote object stores.
  • Support for striping of external volumes for faster database performance.
  • Continuous snapshot backups using a grandfather-father-son paradigm (on clouds with volume support).
  • Assisted database restoration, including stripe re-creation.
  • Provides scripts for master to slave fail-over, restoration of master, and more.
  • Choice of DNS providers (DNS Made Easy, DynDNS, AWS Route53).
  • iptables management within a three-tier scalable web architecture for clouds that do not have firewall services.
  • Pre-configured monitoring and alerts.

Related ServerTemplates:
Load Balancer with HAProxy
PHP App Server
Apache-Rails-Passenger App Server
Tomcat App Server

Release Notes:
Database Manager for MySQL 5.5 Release Notes

Application versions:

  • MySQL 5.5.20

Supported compute clouds:

  • Amazon Web Services EC2
  • Citrix CloudStack (2.2 and Acton)
  • Datapipe
  • IDC Frontier
  • Logicworks
  • Rackspace
  • SoftLayer

Supported backup clouds:

  • Amazon Web Services S3
  • Rackspace CloudFiles
  • SoftLayer Object Storage

Supported primary backup methods:

  • Volume snapshots: AWS EC2, Citrix CloudStack
  • Remote Object Store Upload: AWS S3, Rackspace Cloud Files, SoftLayer Object Storage

Supported MultiCloud Images:

  • CentOS 5.8 - Amazon, CloudStack, Datapipe, IDC Frontier, Logicworks, Rackspace, SoftLayer
  • RHEL 5.8 - Amazon

Contents

  • Cookbook Repo: git://github.com/rightscale/cookbooks.git of RightScale (v12.11.3-LTS)

  • Cookbook Repo: git://github.com/rightscale/rightscale_cookbooks.git of RightScale (v12.11.3-LTS)

  • MultiCloudImage: RightImage_CentOS_5.8_x64_v5.8_v12_LTS_HVM_EBS [rev 2]

  • MultiCloudImage: RightImage_CentOS_5.8_x64_v5.8_v12_LTS [rev 1]

  • MultiCloudImage: RightImage_CentOS_5.8_x64_v5.8_v12_LTS_EBS [rev 1]

  • MultiCloudImage: RightImage_CentOS_5.8_x64_v5.8 - XenServer_v12_LTS [rev 1]

  • MultiCloudImage: RightImage_RHEL_5.8_x64_v5.8_v12_LTS [rev 1]

  • MultiCloudImage: RightImage_CentOS_5.8_x64_v5.8 - VMWare_v12_LTS [rev 1]

  • MultiCloudImage: SoftLayerImage_CentOS_5.8_x64_v5.8_v12_LTS [rev 1]

  • MultiCloudImage: SoftLayerImage_Storage_CentOS_5.8_x64_v5.8_v12_LTS [rev 1]

  • MultiCloudImage: RightImage_CentOS_5.8_x64_v5.8 - KVM_v12_LTS [rev 1]

  • Recipe: db::do_secondary_backup

  • Recipe: db::default

  • Recipe: db::do_appservers_allow

  • Recipe: db::do_appservers_deny

  • Recipe: db::do_delete_volumes_and_terminate_server

  • Recipe: db::do_dump_import

  • Recipe: db::do_force_reset

  • Recipe: db::do_init_and_become_master

  • Recipe: db::do_init_slave_at_boot

  • Recipe: db::do_primary_backup

  • Recipe: db::do_primary_backup_schedule_disable

  • Recipe: db::do_primary_backup_schedule_enable

  • Recipe: db::do_primary_init_slave

  • Recipe: db::do_primary_restore

  • Recipe: db::do_primary_restore_and_become_master

  • Recipe: db::do_promote_to_master

  • Recipe: block_device::setup_ephemeral

  • Recipe: db::do_secondary_restore

  • Recipe: db::do_secondary_restore_and_become_master

  • Recipe: db::do_set_dns_slave_private_ip

  • Recipe: db::handle_demote_master

  • Recipe: db::install_client

  • Recipe: sys_firewall::setup_rule

  • Recipe: db::request_master_allow

  • Recipe: db::request_master_deny

  • Recipe: db::setup_monitoring

  • Recipe: db::setup_privileges_admin

  • Recipe: db::setup_privileges_application

  • Recipe: db::setup_replication_privileges

  • Recipe: db_mysql::default_5_5

  • Recipe: block_device::default

  • Recipe: sys_ntp::default

  • Recipe: logging::default

  • Recipe: rightscale::default

  • Recipe: rightscale::install_file_stats_collectd_plugin

  • Recipe: rightscale::install_tools

  • Recipe: sys::do_reconverge_list_disable

  • Recipe: sys::do_reconverge_list_enable

  • Recipe: sys::setup_swap

  • Recipe: sys_dns::default

  • Recipe: sys_firewall::default

  • Recipe: sys_firewall::do_list_rules

  • Recipe: db::install_server

  • RepoPath: RightScale (v12.11.3-LTS) [rev 9]

    • See More

Revisions

Revision 12 | Nov 20, 2012

v12.11.3-LTS

Revision 8 | Aug 17, 2012

Additional updates for rightscale_cookbooks SHA for v12.11.2-LTS release.

Discussion

44b0c3eb040f1eac48bfe75848363bf8 myCloudWatcher on Aug 25, 2012 | Re: v8

I have set up a server for AWS with this Template for 5.5 MySQL and it works great. No issues so far for the AWS Version. I will try the RackSpace next. Edward M. Goldberg, myCloudWatcher.

Info

1 Rating

Supported Clouds

Pricing

All Users

Sign-up for RightScale

Support Information

http://support.rightscale.com/ServerTemplates