Database Manager for MySQL 5.5 (v13.3)

Published by RightScale on Nov 14, 2012Revision: 92 This component has been superseded. Get the current version here

Description

This ServerTemplate is on the Infinity Lineage. For the latest LTS version, see the 12-LTS Release
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, CloudDNS).
iptables management within a three-tier scalable web architecture for clouds that do not have firewall services.
Pre-configured monitoring and alerts.

Release Notes:
Database Manager for MySQL 5.5 Release Notes

Application versions:

MySQL 5.5

Supported public compute clouds:

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

Supported private compute clouds:

Citrix CloudStack (2.2.14 and 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, Azure Storage, Citrix CloudStack, Rackspace Open Cloud CBS
Remote Object Store Upload: AWS S3, Azure Storage, Google Cloud Storage, Rackspace Cloud Files, SoftLayer Object Storage

Supported MultiCloud Images:

CentOS 6 - Amazon, Google, CloudStack, Datapipe, HP, IDC Frontier, Logicworks, OpenStack, Rackspace, Rackspace Open Cloud, SoftLayer, Windows Azure
Ubuntu 12.04 - Amazon, Google, CloudStack, Datapipe, HP, IDC Frontier, Logicworks, OpenStack, Rackspace, Rackspace Open Cloud, SoftLayer, Windows Azure
RHEL 6 - Amazon

Cookbook Repo: git://github.com/rightscale/cookbooks.git of RightScale (v13.1)
Cookbook Repo: git://github.com/rightscale/rightscale_cookbooks.git of RightScale (v13.1)
MultiCloudImage: RightImage_Ubuntu_12.04_x64_v5.8_EBS [rev 4]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_KVM [rev 8]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_XenServer [rev 5]
MultiCloudImage: RightImage_RHEL_6.3_x64_v5.8 [rev 1]
MultiCloudImage: RightImage_Ubuntu_12.04_x64_v5.8 [rev 15]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_HVM_EBS [rev 1]
MultiCloudImage: RightImage_Ubuntu_12.04_x64_v5.8_HVM_EBS [rev 1]
MultiCloudImage: RightImage_Ubuntu_12.04_x64_v5.8_KVM [rev 3]
MultiCloudImage: RightImage_Ubuntu_12.04_x64_v5.8_XenServer [rev 7]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_EBS [rev 2]
MultiCloudImage: SoftLayerImage_Storage_CentOS_6.2_x64_v5.8 [rev 1]
MultiCloudImage: SoftLayerImage_Storage_Ubuntu_12.04_x64_v5.8 [rev 1]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8 [rev 18]
Recipe: db::do_primary_restore_and_become_master
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: block_device::setup_ephemeral
Recipe: db::do_promote_to_master
Recipe: db::do_secondary_backup
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_server
Recipe: sys_firewall::setup_rule
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::request_master_allow
RepoPath: RightScale (v13.1) [rev 143]