MultiCloud Marketplace

RightScale

Database Manager for MySQL 5.1 (v12.11.2)

Open in Dashboard

Published by RightScale on Feb 01, 2012Revision: 87 This component has been deprecated by the publisher.

Description

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

Configures a MySQL 5.1 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.

For the latest version of MySQL, see Database Manager for MySQL 5.5

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, CloudDNS).
  • 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
Passenger-Rails with Ruby 1.9 App Server
Tomcat App Server
Tomcat7 App Server Beta
Django App Server Beta

Documentation:
Release Notes
Tutorial


Application versions:

  • MySQL 5.1

Supported public compute clouds:

  • Amazon Web Services EC2
  • Datapipe
  • Google Compute Engine
  • HP Cloud
  • Rackspace First Generation
  • Rackspace Open Cloud
  • SoftLayer
  • Windows Azure

Supported private compute clouds:

  • Citrix CloudStack 3.0.6
  • OpenStack Folsom
  • Rackspace Private Cloud

Supported backup clouds:

  • Amazon Web Services S3
  • Azure Storage
  • Google Cloud Storage
  • Rackspace CloudFiles
  • SoftLayer Object Storage

Supported primary backup methods:

  • Volume snapshots: AWS EC2, Citrix CloudStack, Google Compute Engine, Rackspace Open Cloud CBS, Windows Azure
  • Remote Object Store Upload: AWS S3, Azure Storage, Google Cloud Storage, Rackspace Cloud Files, SoftLayer Object Storage

Supported MultiCloud Images:

  • CentOS 6 - Amazon, CloudStack, Datapipe, Google, HP, OpenStack, Rackspace, Rackspace Open Cloud, SoftLayer, Windows Azure
  • RHEL 6 - Amazon

Contents

  • Cookbook: web_apache v0.0.1.124

  • Cookbook: apache2 v1.0.0.124

  • Cookbook: app v0.1.0.124

  • Cookbook: app_passenger v0.0.1.124

  • Cookbook: app_php v0.0.1.124

  • Cookbook: app_tomcat v0.1.1.124

  • Cookbook: block_device v0.1.0.124

  • Cookbook: db v0.2.0.124

  • Cookbook: sys_ntp v1.0.0.124

  • Cookbook: sys_firewall v0.1.0.124

  • Cookbook: sys_dns v0.1.0.124

  • Cookbook: sys v0.1.0.124

  • Cookbook: runit v0.13.0.124

  • Cookbook: rs_utils v0.0.1.124

  • Cookbook: rs_tools v0.0.11.124

  • Cookbook: repo_git v0.0.1.124

  • Cookbook: repo v0.1.0.124

  • Cookbook: rails_enterprise v0.1.1.124

  • Cookbook: rails v0.9.2.124

  • Cookbook: passenger_apache2 v0.16.3.124

  • Cookbook: db_mysql v0.0.1.124

  • Cookbook: mysql v0.23.1.124

  • Cookbook: logrotate v0.8.1.124

  • Cookbook: lb_haproxy v0.0.1.124

  • Cookbook: lb_clb v0.0.1.124

  • Cookbook: lb v0.0.1.124

  • Cookbook: lamp v0.1.0.124

  • Cookbook: iptables v0.9.3.124

  • Cookbook: git v0.8.0.124

  • Cookbook: openssl v0.1.0.124

  • Cookbook Repo: git://github.com/rightscale/cookbooks_public.git of RightScale Premium

  • Cookbook Repo: git://github.com/rightscale/cookbooks.git of RightScale Premium

  • Cookbook Repo: git@github.com:rightscale/cookbooks_premium.git of RightScale Premium

  • MultiCloudImage: RightImage_CentOS_5.6_x64_v5.7 - XenServer [rev 2]

  • MultiCloudImage: RightImage_CentOS_5.6_x64_v5.7 [rev 15]

  • MultiCloudImage: RightImage_RHEL_5.6_i386_v5.7 [rev 4]

  • MultiCloudImage: RightImage_CentOS_5.6_x64_v5.7 - VMware [rev 5]

  • MultiCloudImage: RightImage_RHEL_5.6_x64_v5.7 [rev 5]

  • MultiCloudImage: RightImage_Ubuntu_10.04_i386_v5.7 [rev 7]

  • MultiCloudImage: RightImage_Ubuntu_10.04_x64_v5.7 [rev 5]

  • MultiCloudImage: RightImage_CentOS_5.6_i386_v5.7 [rev 6]

  • Recipe: db_mysql::default

  • Recipe: rs_utils::default

  • Recipe: rs_utils::install_file_stats_collectd_plugin

  • 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: sys_firewall::setup_rule

  • Recipe: sys_ntp::default

  • Recipe: db::setup_replication_privileges

  • Recipe: db::setup_privileges_application

  • Recipe: db::setup_privileges_admin

  • Recipe: db::setup_monitoring

  • Recipe: db::request_master_deny

  • Recipe: db::request_master_allow

  • Recipe: db::install_server

  • Recipe: db::install_client

  • Recipe: db::handle_demote_master

  • Recipe: rs_tools::default

  • Recipe: db::do_secondary_restore

  • Recipe: db::do_secondary_backup

  • Recipe: db::do_promote_to_master

  • Recipe: db::do_primary_restore_and_become_master

  • Recipe: db::do_primary_restore

  • Recipe: db::do_primary_init_slave

  • Recipe: db::do_primary_backup_schedule_enable

  • Recipe: db::do_primary_backup_schedule_disable

  • Recipe: db::do_primary_backup

  • Recipe: db::do_init_and_become_master

  • Recipe: db::do_force_reset

  • Recipe: db::do_dump_import

  • Recipe: db::do_delete_volumes_and_terminate_server

  • Recipe: db::do_appservers_deny

  • Recipe: db::do_appservers_allow

  • Recipe: db::default

  • Recipe: block_device::setup_ephemeral

  • Recipe: block_device::default

  • Recipe: db::do_secondary_restore_and_become_master

  • RepoPath: RightScale Premium [rev 124]

  • See More

Revisions

Revision 147 | Aug 16, 2012

Updated rightscale_cookbooks SHA for v12.11.2 release.

Revision 47 | Nov 21, 2011

Beta Update

Revision 34 | Oct 14, 2011

Add Eucalyptus cloud support.

Discussion

1780c1ac178f828fa6bc3f40223f524cJesse Collier on Nov 16, 2011 | Re: v34

Currently the db::setup_block_device is not functioning properly. The server will boot, and is functional, but setting up a stribe EBS for better disk IO is currently not working. 16:36:33: waited 0s for device /dev/sdf to attach, status is attaching Even though the disk is attached, rightscale fails to see it.

Info

1 Rating

Supported Clouds

Pricing

Available to Paid
RightScale Accounts

Sign-up for RightScale

Support Information

http://support.rightscale.com/ServerTemplates