Database Manager for PostgreSQL 9.1 Beta (v13.3)

Published by RightScale on Jan 15, 2013Revision: 32 This component has been superseded. Get the current version here

Description

This is a Beta ServerTemplate since it has only recently been released and has not yet had heavy usage. Please provide feedback at our feedback forums or file support tickets on our support site.

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

Configures a PostgreSQL 9.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 or Rackspace Cloud Files). 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 or Cloud Files 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 PostgreSQL 9.1 Release Notes

Application versions:

PostgreSQL 9.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, 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
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 25]
Recipe: db::do_set_dns_slave_private_ip
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: db::do_secondary_restore
Recipe: db::do_secondary_restore_and_become_master
Recipe: block_device::setup_ephemeral
Recipe: db::handle_demote_master
Recipe: db::install_server
Recipe: db::request_master_allow
Recipe: db::request_master_deny
Recipe: sys_firewall::setup_rule
Recipe: db::setup_privileges_admin
Recipe: db::setup_privileges_application
Recipe: db::setup_replication_privileges
Recipe: db_postgres::do_set_slave_async_mode
Recipe: db_postgres::do_set_slave_sync_mode
Recipe: db_postgres::do_show_slave_sync_mode
Recipe: db_postgres::setup_server_9_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::setup_monitoring
RepoPath: RightScale (v13.2) [rev 147]

Revisions

Revision 42 | Mar 06, 2013

v13.3 Release

Revision 32 | Jan 15, 2013

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

Revision 29 | Dec 20, 2012

Release 13.2

Revision 23 | Nov 14, 2012

Added support for AWS Sydney.

Revision 20 | Oct 23, 2012

Release v13.1

Discussion

Adin Stein on Feb 02, 2013 | Re: v20

rs_run_recipe does not work rs_run_recipe -n rightscale:setup_timezone Requesting to execute the recipe named "rightscale:setup_timezone" locally on this server Failed to process request: Failed to retrieve executable

Kannan Manickam on Feb 15, 2013 | Re: v20