Database Manager for MySQL 5.1 (v13.3)

Published by RightScale on Dec 20, 2012Revision: 178 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.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.

Release Notes:
Database Manager for MySQL 5.1 Release Notes

Application versions:

MySQL 5.1

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, Citrix CloudStack, 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, 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.2)
Cookbook Repo: git://github.com/rightscale/rightscale_cookbooks.git of RightScale (v13.2)
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_XenServer [rev 8]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_KVM [rev 11]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_HVM_EBS [rev 4]
MultiCloudImage: RightImage_RHEL_6.3_x64_v5.8 [rev 3]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8_EBS [rev 5]
MultiCloudImage: SoftLayerImage_Storage_CentOS_6.3_x64_v5.8 [rev 2]
MultiCloudImage: RightImage_CentOS_6.3_x64_v5.8 [rev 22]
Recipe: db::do_secondary_restore
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: db::do_secondary_backup
Recipe: block_device::setup_ephemeral
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::setup_server_5_1
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.2) [rev 147]

Revisions

Revision 190 | Mar 06, 2013

v13.3 Release

Revision 181 | Jan 15, 2013

Updated public CentOS and Ubuntu MCIs with new Azure images for other regions to match Azure West US.

Revision 178 | Dec 20, 2012

Release 13.2

Revision 171 | Nov 14, 2012

Added support for AWS Sydney.

Revision 167 | Oct 18, 2012

Release v13.1

Revision 148 | Aug 20, 2012

Release v13.0

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

Jesse 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.