Database Manager with PostgreSQL 9.0 - Alpha
Published by RightScale on May 20, 2011Revision: 7 This component has been deprecated by the publisher.
Description
The RightScale Database Manager for PostgreSQL configures and operates a high-availability cluster of PostgreSQL 9 databases. It is cloneable, just like any other RightScale ServerTemplate, so you can make adjustments specific to your organization's technology or workflow needs. Read the PostgreSQL runbook to learn how to launch and operate this Database Manager.
Features include:
- Master and slave roles.
- Use of external volumes for PostgreSQL data storage.
- Support for striping of external volumes for faster database performance.
- Continuous snapshot backups using a grandfather-father-son paradigm.
- Assisted database restoration, including stripe re-creation.
- DNS management.
- Pre-configured monitoring and alerts.
- Choice of DNS providers (DNS Made Easy, DynDNS, AWS Route53).
Contents
-
MultiCloudImage: RightImage_CentOS_5.4_i386_v5.6 - 11H1 [rev 16]
-
MultiCloudImage: RightImage_Ubuntu_10.04_x64_v5.6 - 11H1 [rev 12]
-
MultiCloudImage: RightImage_Ubuntu_10.04_i386_v5.6 - 11H1 [rev 13]
-
MultiCloudImage: RightImage_CentOS_5.4_x64_v5.6 - 11H1 [rev 16]
-
RightScript: DNS External id register - 11H1 [rev 7]
-
RightScript: DB EBS PostgreSQL restore and become master - 11H2.a1 [rev 6]
-
RightScript: DB EBS PostgreSQL slave init - 11H2.a1 [rev 3]
-
RightScript: DB EBS PostgreSQL slave init at boot - 11H2.a1 [rev 3]
-
RightScript: DB PostgreSQL 9.0 install - 11H2.a1 [rev 6]
-
RightScript: DB PostgreSQL TERMINATE SERVER - Delete EBS volume and halt - 11H2.a1 [rev 3]
-
RightScript: DB PostgreSQL config tools install - 11H2.a1 [rev 2]
-
RightScript: DB PostgreSQL dump export - 11H2.a1 [rev 5]
-
RightScript: DB PostgreSQL dump import - 11H2.a1 [rev 6]
-
RightScript: DB PostgreSQL freeze binary backups - 11H2.a1 [rev 2]
-
RightScript: DB PostgreSQL privileges set - 11H2.a1 [rev 6]
-
RightScript: DB PostgreSQL unfreeze binary backups - 11H2.a1 [rev 2]
-
RightScript: DB Rightscale tools install - 11H2.a1 [rev 1]
-
RightScript: DB EBS PostgreSQL promote to master - 11H2.a1 [rev 2]
-
RightScript: DNS Tools install - 11H1 [rev 13]
-
RightScript: MAIL Postfix local delivery - 11H1 [rev 4]
-
RightScript: MISC SSH private key install - 11H1 [rev 8]
-
RightScript: RB Install Rightscale tools - 11H2.a1 [rev 4]
-
RightScript: DB Check master DNS TTL - 11H2.a1 [rev 1]
-
RightScript: DB EBS PostgreSQL continuous backups - 11H2.a1 [rev 4]
-
RightScript: DB EBS PostgreSQL backup - 11H2.a1 [rev 3]
-
RightScript: DB Create PostgreSQL EBS stripe volume - 11H2.a1 [rev 5]
-
RightScript: SYS Add swap partition - 11H1 [rev 10]
-
RightScript: SYS Lvm install - 11H1 [rev 7]
-
RightScript: SYS Monitoring PostgreSQL add - 11H2.a1 [rev 5]
-
RightScript: SYS Monitoring PostgreSQL add DB monitoring - 11H2.a1 [rev 4]
-
RightScript: SYS Monitoring file stats add - 11H1 [rev 4]
-
RightScript: SYS Monitoring install - 11H1 [rev 10]
-
RightScript: SYS Syslog remote logging client - 11H1 [rev 9]
-
RightScript: SYS Timezone set - 11H1 [rev 5]
See More
Revisions
Discussion
Info
No Ratings
Supported Clouds
Pricing
Available to Paid
RightScale Accounts
Sign-up for RightScale
Support Information
http://support.rightscale.com
This seems to have the problem of periodically failing master backups because of a hung pg_start_backup(). Running psql -c 'select pg_stop_backup();' will allow the next croned backup to continue, but it is disturbing.