Home > ServerTemplates > v13.5 LTS > ST > LAMP All-In-One with MySQL 5.5 (v13.5 LTS) > LAMP All-In-One with MySQL 5.5 (v13.5.0-LTS) - Reference

LAMP All-In-One with MySQL 5.5 (v13.5.0-LTS) - Reference

Table of Contents

Long Term Support

Stable, tested ServerTemplate assets

► Reference

Info

Current revision: 2
Date published: 2013/08/30 20:56:53 +0000
MultiCloud Marketplace: http://www.rightscale.com/library/se.../lineage/44251

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

Basic all-in-one LAMP (Linux, Apache, MySQL, PHP) ServerTemplate designed to work in a hybrid cloud setting. This ServerTemplate takes regular backups of the MySQL 5.5 database and saves them to public cloud storage. Suitable for single-server test, development, and production (non-redundant) purposes.

Related ServerTemplates:  
PHP App Server  
Database Manager for MySQL 5.5

Documentation:  
Release Notes  
Tutorial  
```
Application versions: * Apache 2.2 * MySQL 5.5 * PHP 5.3 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 MultiCloud Images: * CentOS 6 - Amazon, CloudStack, Datapipe, Google, HP, OpenStack, Rackspace, Rackspace Open Cloud, SoftLayer, Windows Azure * Ubuntu 12.04 - Amazon, CloudStack, Datapipe, HP, OpenStack, Rackspace, Rackspace Open Cloud, SoftLayer, Windows Azure * RHEL 6 - Amazon
Supported Clouds: AWS AP-Singapore, AWS AP-Sydney, AWS AP-Tokyo, AWS EU, AWS SA-Sao Paulo, AWS US-East, AWS US-Oregon, AWS US-West, Azure East Asia, Azure East US, Azure North Europe, Azure Southeast Asia, Azure West Europe, Azure West US, CloudStack default, Datapipe Hong Kong, Datapipe London, Datapipe New York Metro, Datapipe Silicon Valley, Google, HP Cloud, OpenStack default, Rackspace, Rackspace Managed, Rackspace Open Cloud - Chicago, Rackspace Open Cloud - Dallas, Rackspace Open Cloud - London, Rackspace Open Cloud - Sydney, Rackspace UK

Images

The following MultiCloud Images (MCIs) are used by the ServerTemplate. The MCIs determine which operating systems and clouds are supported.

MultiCloud Images

RightImage_CentOS_6.4_x64_v13.5_LTS
- AWS AP-Singapore, AWS AP-Sydney, AWS AP-Tokyo, AWS EU, AWS SA-Sao Paulo, AWS US-East, AWS US-Oregon, AWS US-West, Azure East Asia, Azure East US, Azure North Europe, Azure Southeast Asia, Azure West Europe, Azure West US, Google, HP Cloud, Rackspace, Rackspace Managed, Rackspace Open Cloud - Chicago, Rackspace Open Cloud - Dallas, Rackspace Open Cloud - London, Rackspace Open Cloud - Sydney, Rackspace UK
RightImage_CentOS_6.4_x64_v13.5_LTS_EBS
- AWS AP-Singapore, AWS AP-Sydney, AWS AP-Tokyo, AWS EU, AWS SA-Sao Paulo, AWS US-East, AWS US-Oregon, AWS US-West
RightImage_CentOS_6.4_x64_v13.5_LTS_HVM_EBS
- AWS AP-Tokyo, AWS EU, AWS US-East, AWS US-Oregon
RightImage_CentOS_6.4_x64_v13.5_LTS_KVM
- CloudStack default, Datapipe Hong Kong, Datapipe London, Datapipe New York Metro, Datapipe Silicon Valley, OpenStack default
RightImage_CentOS_6.4_x64_v13.5_LTS_VMware
- None
RightImage_CentOS_6.4_x64_v13.5_LTS_XenServer
- None
RightImage_RHEL_6.4_x64_v13.5_LTS
- Rackspace Open Cloud - Chicago, Rackspace Open Cloud - Dallas, Rackspace Open Cloud - London, Rackspace Open Cloud - Sydney
RightImage_RHEL_6.4_x64_v13.5_LTS_EBS
- AWS AP-Singapore, AWS AP-Sydney, AWS AP-Tokyo, AWS EU, AWS SA-Sao Paulo, AWS US-East, AWS US-Oregon, AWS US-West
RightImage_Ubuntu_12.04_x64_v13.5_LTS
- AWS AP-Singapore, AWS AP-Sydney, AWS AP-Tokyo, AWS EU, AWS SA-Sao Paulo, AWS US-East, AWS US-Oregon, AWS US-West, Azure East Asia, Azure East US, Azure North Europe, Azure Southeast Asia, Azure West Europe, Azure West US, HP Cloud, Rackspace, Rackspace Managed, Rackspace Open Cloud - Chicago, Rackspace Open Cloud - Dallas, Rackspace Open Cloud - London, Rackspace Open Cloud - Sydney, Rackspace UK
RightImage_Ubuntu_12.04_x64_v13.5_LTS_EBS
- AWS AP-Singapore, AWS AP-Sydney, AWS AP-Tokyo, AWS EU, AWS SA-Sao Paulo, AWS US-East, AWS US-Oregon, AWS US-West
RightImage_Ubuntu_12.04_x64_v13.5_LTS_HVM_EBS
- AWS AP-Tokyo, AWS EU, AWS US-East, AWS US-Oregon
RightImage_Ubuntu_12.04_x64_v13.5_LTS_KVM
- CloudStack default, Datapipe Hong Kong, Datapipe London, Datapipe New York Metro, Datapipe Silicon Valley, OpenStack default
RightImage_Ubuntu_12.04_x64_v13.5_LTS_VMware
- None
RightImage_Ubuntu_12.04_x64_v13.5_LTS_XenServer
- None
SoftLayerImage_CentOS_6.4_x64_v13.5_LTS
- None
SoftLayerImage_Storage_CentOS_6.4_x64_v13.5_LTS
- None
SoftLayerImage_Storage_Ubuntu_12.04_x64_v13.5_LTS
- None
SoftLayerImage_Ubuntu_12.04_x64_v13.5_LTS
- None

Scripts

Boot Scripts
- rightscale::setup_security_updates
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- rightscale::install_rightimage_extras
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- logging::default
- INPUTS: SSL Certificate, Remote Server, Logging Protocol
- sys_firewall::default
- INPUTS: Firewall Rule Port, Firewall, Firewall Rule IP Address, Firewall Rule Protocol, Firewall Rule
- sys_ntp::default
- INPUTS: NTP Servers
- rs-postfix::setup_local_delivery
- INPUTS: None
- rightscale::setup_server_tags
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- rightscale::setup_timezone
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- rightscale::setup_monitoring
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- rightscale::setup_cloud
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- rightscale::install_tools
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- block_device::setup_ephemeral
- INPUTS: Percentage of the LVM used for data (1), Secondary Backup Storage Container (2), Keep Monthly Backups (2), Primary Backup Storage Cloud Endpoint URL (default), Number of Volumes in the Stripe (2), Backup Max Snapshots (2), Secondary Backup Storage Cloud (default), I/O Operations per Second (1), Keep Daily Backups (2), Number of Volumes in the Stripe (1), Keep Yearly Backups (2), Block Device(s) to Operate On, Keep Daily Backups (1), Backup Lineage (2), Percentage of the ephemeral LVM used for data, Block Device Mount Directory (1), Total Volume Size (2), Secondary Backup Secret (default), Keep Weekly Backups (2), Nickname (1), Force Reset Safety, Backup Restore Timestamp Override (1), Backup Cron Minute (1), Backup Cron Minute (2), Backup Cron Hour (2), Backup Max Snapshots (1), Block Device Mount Directory (2), Total Volume Size (1), Ephemeral File System Type, Primary Backup User (default), Primary Backup Storage Cloud (default), Secondary Backup Storage Container (1), Backup Lineage Override, Primary Backup Secret (default), Keep Monthly Backups (1), Rackspace SNET Enabled for Backup, Secondary Backup User (default), Volume Type, Backup Restore Timestamp Override (2), Terminate Safety, I/O Operations per Second (2), Secondary Backup Storage Cloud Endpoint URL (default), Keep Yearly Backups (1), Backup Lineage (1), Percentage of the LVM used for data (2), Backup Cron Hour (1), Keep Weekly Backups (1), Nickname (2)
- sys::setup_swap
- INPUTS: Swap size in GB, Swapfile location, Reconverge List, Interval in Minutes to Run Reconverge List
- db_mysql::setup_server_5_5
- INPUTS: Master SSL Key, Compression of the slave/master protocol, MySQL Binlog Destination, MySQL Expire Logs Days, Slave SSL Certificate, Server Usage, Master SSL Certificate, MySQL Init Timeout, Slave SSL Key, MySQL Binlog Format, CA SSL Certificate, Enable mysql_upgrade, MySQL Temp Directory Destination
- db::install_server
- INPUTS: Dump Storage Account Secret, Master Backup Cron Hour, Dump Prefix, Database Replication Network Interface, Database Replication Username, Slave Secondary Backup Cron Minute, Master Secondary Backup Cron Hour, Force Promote to Master, Force Reset Safety, Database Provider type, Database Master DNS Record ID, Slave Backup Cron Minute, Slave Backup Cron Hour, Dump Storage Account Provider, Dump Container, Database Admin Username, Database Slave FQDN, Database Replication Password, Dump Storage Endpoint URL, Database Admin Password, Master Secondary Backup Cron Minute, Database Application Username, Init Slave at Boot, Database Slave DNS Record ID, Database DNS TTL Limit, Master Backup Cron Minute, Terminate Safety, Database Restore Timestamp Override, Database Schema Name, Database Application Password, Database Master FQDN, Dump Storage Account ID, Database Restore Lineage Override, Slave Secondary Backup Cron Hour, Database Backup Lineage
- repo::default
- INPUTS: ROS Storage Account Provider, ROS Prefix, Repository URL/ROS Container, Repository Provider, Project App root, Storage Cloud Endpoint URL, Known hosts ssh key, Repository Branch/Tag/Commit, Action, Account name, Account credential
- web_apache::default
- INPUTS: SSL Passphrase, SSL Certificate, AllowOverride Directive, Application Name, SSL Certificate Chain, Multi-Processing Module, SSL Certificate Key, SSL Enable
- app_php::setup_server_5_3
- INPUTS: PHP module packages
- app::install_server
- INPUTS: Database Schema Name, Application IP Type Given to Load Balancer, Application Listen Port
- lamp::default
- INPUTS: None
- db::do_dump_import
- INPUTS: Dump Storage Account Secret, Master Backup Cron Hour, Dump Prefix, Database Replication Network Interface, Database Replication Username, Slave Secondary Backup Cron Minute, Master Secondary Backup Cron Hour, Force Promote to Master, Force Reset Safety, Database Provider type, Database Master DNS Record ID, Slave Backup Cron Minute, Slave Backup Cron Hour, Dump Storage Account Provider, Dump Container, Database Admin Username, Database Slave FQDN, Database Replication Password, Dump Storage Endpoint URL, Database Admin Password, Master Secondary Backup Cron Minute, Database Application Username, Init Slave at Boot, Database Slave DNS Record ID, Database DNS TTL Limit, Master Backup Cron Minute, Terminate Safety, Database Restore Timestamp Override, Database Schema Name, Database Application Password, Database Master FQDN, Dump Storage Account ID, Database Restore Lineage Override, Slave Secondary Backup Cron Hour, Database Backup Lineage
- app::do_update_code
- INPUTS: Database Schema Name, Application IP Type Given to Load Balancer, Application Listen Port
- app::setup_db_connection
- INPUTS: Database Schema Name, Application IP Type Given to Load Balancer, Application Listen Port
- app::setup_vhost
- INPUTS: Database Schema Name, Application IP Type Given to Load Balancer, Application Listen Port
- db::do_dump_schedule_enable
- INPUTS: Dump Storage Account Secret, Master Backup Cron Hour, Dump Prefix, Database Replication Network Interface, Database Replication Username, Slave Secondary Backup Cron Minute, Master Secondary Backup Cron Hour, Force Promote to Master, Force Reset Safety, Database Provider type, Database Master DNS Record ID, Slave Backup Cron Minute, Slave Backup Cron Hour, Dump Storage Account Provider, Dump Container, Database Admin Username, Database Slave FQDN, Database Replication Password, Dump Storage Endpoint URL, Database Admin Password, Master Secondary Backup Cron Minute, Database Application Username, Init Slave at Boot, Database Slave DNS Record ID, Database DNS TTL Limit, Master Backup Cron Minute, Terminate Safety, Database Restore Timestamp Override, Database Schema Name, Database Application Password, Database Master FQDN, Dump Storage Account ID, Database Restore Lineage Override, Slave Secondary Backup Cron Hour, Database Backup Lineage
- web_apache::setup_monitoring
- INPUTS: SSL Passphrase, SSL Certificate, AllowOverride Directive, Application Name, SSL Certificate Chain, Multi-Processing Module, SSL Certificate Key, SSL Enable
- db::setup_monitoring
- INPUTS: Dump Storage Account Secret, Master Backup Cron Hour, Dump Prefix, Database Replication Network Interface, Database Replication Username, Slave Secondary Backup Cron Minute, Master Secondary Backup Cron Hour, Force Promote to Master, Force Reset Safety, Database Provider type, Database Master DNS Record ID, Slave Backup Cron Minute, Slave Backup Cron Hour, Dump Storage Account Provider, Dump Container, Database Admin Username, Database Slave FQDN, Database Replication Password, Dump Storage Endpoint URL, Database Admin Password, Master Secondary Backup Cron Minute, Database Application Username, Init Slave at Boot, Database Slave DNS Record ID, Database DNS TTL Limit, Master Backup Cron Minute, Terminate Safety, Database Restore Timestamp Override, Database Schema Name, Database Application Password, Database Master FQDN, Dump Storage Account ID, Database Restore Lineage Override, Slave Secondary Backup Cron Hour, Database Backup Lineage
- rightscale::setup_security_update_monitoring
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
- rightscale::do_security_updates
- INPUTS: Rackspace API Key, RedHat Network Password, Timezone, Enable security updates, Process Match List, RedHat Network Username, Private SSH Key, Domain Name, Rackspace Username, Domain Search Suffix, Short Hostname, Process List, Rackspace Tenant ID
Operational Scripts
Decommission Scripts
- None

Inputs

Account credential

A valid credential (i.e. password, SSH key, account secret) to access files in the specified location. This input is always required for Git and Rsync but may be optional for other providers. Example: cred:RACKSPACE_AUTH_KEY

Account name

The account name (i.e. username, ID) that is required to access files in the specified location. This input is optional and may not be required. Example: cred:RACKSPACE_USERNAME

Action

Specify how the application code will be pulled from the specified repository. 'pull'- standard repository pull, 'capistrano_pull' standard repository pull plus a capistrano deployment style is applied. Example: pull

AllowOverride Directive

Allows/disallows the use of .htaccess files in project web root directory. Can be None (default), All, or any directive-type as specified in Apache documentation. Example: None

Application IP Type Given to Load Balancer

Specify the IP type where the application server is listening. Example: private

Application Listen Port

The port that the application service is listening on. Example: 8000

Application Name

Sets the directory for your application's web files (/home/webapps/Application Name/). If you have multiple applications, you can run the code checkout script multiple times, each with a different value for the 'Application Name' input, so each application will be stored in a unique directory. This must be a valid directory name. Do not use symbols in the name. Example: myapp

Backup Cron Hour (1)

Defines the hour when the backup will be taken. Use a value of 1-24, or set to 'Ignore' to create a backup every hour. Example: 10

Backup Cron Hour (2)

Defines the hour when the backup will be taken. Use a value of 1-24, or set to 'Ignore' to create a backup every hour. Example: 10

Backup Cron Minute (1)

Defines the minute of the hour when the backup will be taken. Use a value of 1-59, or set to 'Ignore' and a random minute will be calculated. Example: 10

Backup Cron Minute (2)

Defines the minute of the hour when the backup will be taken. Use a value of 1-59, or set to 'Ignore' and a random minute will be calculated. Example: 10

Backup Lineage (1)

The name associated with your primary and secondary database backups. It's used to associate them with your database environment for maintenance, restore, and replication purposes. Backup snapshots will automatically be tagged with this value (e.g. rs_backup:lineage=mysqlbackup). Backups are identified by their lineage name. Note: For servers running on Rackspace, this value also indicates the Cloud Files container to use for storing primary backups. If a Cloud Files container with this name does not already exist, one will automatically be created. Example: prod_db_lineage

Backup Lineage (2)

Backup Lineage Override

If defined, this will override the input defined for 'Backup Lineage' (block_device/devices/device2/backup/lineage) so that you can restore the volume from another backup that has as a different lineage name. The most recently completed snapshots will be used unless a specific timestamp value is specified for 'Restore Timestamp Override' (block_device/devices/device2/backup/timestamp_override). Example: prod_db_lienage_2

Backup Max Snapshots (1)

The maximum number of primary backups to keep in addition to those being rotated. Example: 60

Backup Max Snapshots (2)

The maximum number of primary backups to keep in addition to those being rotated. Example: 60

Backup Restore Timestamp Override (1)

Another optional variable to restore from a specific timestamp. Specify a string matching the timestamp tags on the volume snapshot set. You will need to specify the timestamp that's defined by the snapshot's tag (not name). For example, if the snapshot's tag is 'rs_backup:timestamp=1303613371' you would specify '1303613371' for this input. Example: 1303613371

Backup Restore Timestamp Override (2)

Block Device Mount Directory (1)

The directory of where to mount the block device (e.g., /mnt/storage). Example: /mnt/storage

Block Device Mount Directory (2)

The directory of where to mount the block device (e.g., /mnt/storage). Example: /mnt/storage

Block Device(s) to Operate On

The block device(s) to operate on. Can be a comma-separated list of device names or '*' to indicate all devices. Example: device1

CA SSL Certificate

The name of your CA SSL Certificate. This is one of the 5 inputs needed to do secured replication. Example: cred:CA_CERT. Please DO NOT use this input for LAMP ServerTemplates.

Compression of the slave/master protocol

Use compression of the slave/master protocol if both the slave and the master support it. Default: disabled

Database Admin Password

The password of the database user with 'admin' privileges. Example: cred:DBADMIN_PASSWORD.

Database Admin Username

The username of the database user with 'admin' privileges. Example: cred:DBADMIN_USER.

Database Application Password

The password of the database user that has 'user' privileges. Example: cred:DBAPPLICATION_PASSWORD.

Database Application Username

The username of the database user that has 'user' privileges. Example: cred:DBAPPLICATION_USER.

Database Backup Lineage

The prefix that will be used to name/locate the backup of a particular database.Note: For servers running on Rackspace, this value also indicates the Cloud Files container to use for storing primary backups.If a Cloud Files container with this name does not already exist,the setup process creates one. Example: text:prod_db_lineage

Database DNS TTL Limit

The upper limit for the TTL of the master DB DNS record in seconds. This value should be kept low in the event of Master DB failure so that the DNS record updates in a timely manner. When installing the DB server, this value is checked in the DNS records. Input should be set for 300 when using CloudDNS. Example: 60

Database Master DNS Record ID

The unique identifier that is associated with the DNS A record of the master database server.The unique identifier is assigned by the DNS provider when you create a dynamic DNS A record. This ID is used to update the associated A record with the private IP address of the master server when this recipe is run. If you are using DNS Made Easy as your DNS provider, a 7-digit number is used (e.g., 4403234).Example:4403234

Database Master FQDN

The fully qualified domain name for the master database server. Example: db-master.example.com

Database Provider type

Database provider type to use on client side. This must be a string containing the provider cookbook name and (optionally) the version of the database. Example: db_mydatabase_1.0, db_mysql_5.1, db_mysql_5.5, db_postgres_9.1

Database Replication Network Interface

The network interface used for replication. WARNING: when selecting 'public' we highly recommend enabling SSL encryption, otherwise data could travel over insecure connections. Make sure you understand what you are doing before changing this value. Default: private

Database Replication Password

The password of the database user that has 'replication' privileges. Example: cred:DBREPLICATION_PASSWORD.

Database Replication Username

The username of the database user that has 'replication' privileges. Example: cred:DBREPLICATION_USER.

Database Restore Lineage Override

If defined, this will override the input defined for 'Backup Lineage' (db/backup/lineage) so that you can restore the database from another backup that has as a different lineage name. The most recently completed snapshots will be used unless a specific timestamp value is specified for 'Restore Timestamp Override' (db/backup/timestamp_override). Although this input allows you to restore from a different set of snapshots, subsequent backups will use 'Backup Lineage' to name the snapshots. Be sure to remove the 'Backup Lineage Override' input after the new master is operational. Example: text:new_db_lineage

Database Restore Timestamp Override

An optional variable to restore a database backup with a specific timestamp rather than the most recent backup in the lineage. You must specify a string that matches the timestamp tag on the volume snapshot. You will need to specify the timestamp that is defined by the snapshot's tag (not the name). For example, if the snapshot's tag is 'rs_backup:timestamp=1303613371' you would specify '1303613371' for this input. Example: 1303613371

Database Schema Name

Enter the name of the database name/schema to create/restore a dump from/for. Example: mydbschema

Database Slave DNS Record ID

The unique identifier that is associated with the DNS A record of a slave server. The unique identifier is assigned by the DNS provider when you create a dynamic DNS A record. This ID is used to update the associated A record with the private IP address of a slave server when this recipe is run. If you are using DNS Made Easy as your DNS provider, a 7-digit number is used (e.g., 4403234). Example:4403234

Database Slave FQDN

The fully qualified domain name for a slave database server. Example: db-slave.example.com

Domain Name

The domain name that you would like this node to have. Example: example.com

Domain Search Suffix

The domain search suffix you would like this node to have. Example: example.com

Dump Container

The cloud storage location where the dump file will be saved to or restored from. For Amazon S3, use the bucket name. For Rackspace Cloud Files, use the container name. Example: db_dump_bucket

Dump Prefix

The prefix that will be used to name/locate the backup of a particular database dump. Defines the prefix of the dump file name that will be used to name the backup database dump file, along with a timestamp. Example: prod_db_backup

Dump Storage Account ID

In order to write the dump file to the specified cloud storage location, you need to provide cloud authentication credentials. For Amazon S3, use your Amazon access key ID (e.g., cred:AWS_ACCESS_KEY_ID). For Rackspace Cloud Files, use your Rackspace login username (e.g., cred:RACKSPACE_USERNAME). For OpenStack Swift the format is: 'tenantID:username'. Example: cred:AWS_ACCESS_KEY_ID

Dump Storage Account Provider

Location where the dump file will be saved. Used by dump recipes to back up to remote object storage (complete list of supported storage locations is in input dropdown). Example: s3

Dump Storage Account Secret

In order to write the dump file to the specified cloud storage location, you need to provide cloud authentication credentials. For Amazon S3, use your AWS secret access key (e.g., cred:AWS_SECRET_ACCESS_KEY). For Rackspace Cloud Files, use your Rackspace account API key (e.g., cred:RACKSPACE_AUTH_KEY). Example: cred:AWS_SECRET_ACCESS_KEY

Dump Storage Endpoint URL

The endpoint URL for the storage cloud. This is used to override the default endpoint or for generic storage clouds such as Swift. Example: http://endpoint_ip:5000/v2.0/tokens

Enable mysql_upgrade

Run mysql_upgrade if a restore from an older version of MySQL is detected. Default: false

Enable security updates

Unfreezes software repositories after booting and installing packages, allowing for security updates to be installed.

Ephemeral File System Type

The type of file system that will be installed on the ephemeral device. By default, this input will be set to 'xfs'. This input is ignored on Redhat and Google cloud since we do not support 'xfs' on them. The 'ext3' file system will be set up by default on Redhat and Google cloud. Example: xfs

Firewall

Enables an iptables firewall for this server which allows port 22, 80 and 443 open by default. Use the sys_firewall::setup_rule recipe to enable/disable extra ports. Example: enabled

Firewall Rule

Enables or disables a firewall rule. Example: enable

Firewall Rule IP Address

Address can either be a network name, a network IP address (with /mask), or a plain IP address. The mask can either be a network mask or a plain number specifying the number of 1's at the left side of the network mask. Thus, a mask of 24 is equivalent to 255.255.255.0. A '!' argument before the address specification inverts the sense of the address. A value of 'any' allows any IP address. Example: any

Firewall Rule Port

Comma-separated list of ports to Enable or Disable. Example: 8080,8000

Firewall Rule Protocol

Firewall protocol use. Example: tcp

Force Promote to Master

If true, when promoting a slave to master, ignores making checks and changes to any current master. WARNING: setting this will promote a slave to a master with no replication until a new slave is brought up. Make sure you understand what you are doing before changing this value. Default: false

Force Reset Safety

Prevents the accidental running of the db::do_force_reset recipe. This recipe will only run if the input variable is overridden and set to "off". Example: text:off

I/O Operations per Second (1)

The input/output operations per second (IOPS) that the volume can support. IOPS is currently only supported on Amazon EC2. Example: 500

I/O Operations per Second (2)

The input/output operations per second (IOPS) that the volume can support. IOPS is currently only supported on Amazon EC2. Example: 500

Init Slave at Boot

Set to 'True' to have the instance initialize the database server as a slave on boot. Set to 'False' if there is no master database server running. Example: false

Interval in Minutes to Run Reconverge List

Defines the interval in minutes to run recipe(s) of reconverge list. Example: 15

Keep Daily Backups (1)

The number of daily primary backups to keep (i.e., rotation size). Example: 14

Keep Daily Backups (2)

The number of daily primary backups to keep (i.e., rotation size). Example: 14

Keep Monthly Backups (1)

The number of monthly primary backups to keep (i.e., rotation size). Example: 12

Keep Monthly Backups (2)

The number of monthly primary backups to keep (i.e., rotation size). Example: 12

Keep Weekly Backups (1)

The number of weekly primary backups to keep (i.e., rotation size). Example: 6

Keep Weekly Backups (2)

The number of weekly primary backups to keep (i.e., rotation size). Example: 6

Keep Yearly Backups (1)

The number of yearly primary backups to keep (i.e., rotation size). Example: 2

Keep Yearly Backups (2)

The number of yearly primary backups to keep (i.e., rotation size). Example: 2

Known hosts ssh key

A valid SSH key which will be appended to /root/.ssh/known_hosts file. This input will allow to verify the destination host, by comparing its IP,FQDN, SSH-RSA with the record in /root/.ssh/known_hosts file. Use this input if you want to improve security and for MiTM attacks prevention. Example: cred:SSH_KNOWN_HOST_KEY.

Logging Protocol

Protocol used to send logging messages from client to server. Example: udp

Master Backup Cron Hour

Defines the hour of the day when the primary backup will be taken of the master database. Backups of the master are taken daily. By default, an hour will be randomly chosen at launch time. Otherwise, the time of the backup is defined by 'Master Backup Cron Hour' and 'Master Backup Cron Minute'. However, if you specify a value in this input (e.g., 23 for 11:00 PM), then backups will occur once per day at the specified hour, rather than hourly. Uses standard crontab format. Example: 23

Master Backup Cron Minute

Defines the minute of the hour when the backup of the master database will be taken. Backups of the master are taken daily. By default, a minute will be randomly chosen at launch time. Otherwise, the time of the backup is defined by 'Master Backup Cron Hour' and 'Master Backup Cron Minute'. Uses standard crontab format. Example: 30

Master SSL Certificate

The name of your Master SSL Certificate. This is one of the 5 inputs needed to do secured replication. Example: cred:MASTER_CERT. Please DO NOT use this input for LAMP ServerTemplates.

Master SSL Key

The name of your Master SSL Key. This is one of the 5 inputs needed to do secured replication. Example: cred:MASTER_KEY. Please DO NOT use this input for LAMP ServerTemplates.

Master Secondary Backup Cron Hour

Defines the hour of the day when the secondary backup will be taken of the master database. Backups of the master are taken daily. By default, an hour will be randomly chosen at launch time. Otherwise, the time of the backup is defined by 'Master Secondary Backup Cron Hour' and 'Master Secondary Backup Cron Minute'. Uses standard crontab format (e.g., 23 for 11:00 PM).

Master Secondary Backup Cron Minute

Defines the minute of the hour when the secondary backup will be taken of the master database. Backups of the master are taken daily. By default, a minute will be randomly chosen at launch time. Otherwise, the time of the backup is defined by 'Master Secondary Backup Cron Hour' and 'Master Secondary Backup Cron Minute'. Uses standard crontab format (e.g., 30 for minute 30 of the hour).

Multi-Processing Module

Defines the multi-processing module setting in httpd.conf. Use 'worker' for Rails/Tomcat/Standalone frontends and 'prefork' for PHP. Example: prefork

MySQL Binlog Destination

Defines the filename and location of your MySQL stored binlog files. Sets the 'log-bin' variable in the MySQL config file. Example: /mnt/mysql-binlogs/mysql-bin

MySQL Binlog Format

Defines the format of your MySQL stored binlog files. Sets the 'binlog_format' option in the MySQL config file. Accepted options: STATEMENT, ROW, and MIXED. Example: MIXED

MySQL Expire Logs Days

Defines number of days to wait until the log expires. Default: 2

MySQL Init Timeout

Defines timeout to wait for a MySQL socket connection. Default: 600

MySQL Temp Directory Destination

Defines the location of your MySQL temp directory. Sets the 'tmpdir' variable in the MySQL config file. Example: /tmp

NTP Servers

A comma-separated list of fully qualified domain names for the array of servers that instances should talk to. Example: time1.example.com, time2.example.com, time3.example.com

Nickname (1)

The name displayed in the dashboard for volumes and to uniquely identify LVM volume groups. Example: data_storage1

Nickname (2)

The name displayed in the dashboard for volumes and to uniquely identify LVM volume groups. Example: data_storage1

Number of Volumes in the Stripe (1)

The total number of volumes in the volume stripe that will be used by the database. Volumes will be created and mounted to the instance. The default value is 1, which means that only a single volume will be used (no striping). This value is ignored on clouds that do not support volumes (e.g., Rackspace). Example: 1

Number of Volumes in the Stripe (2)

PHP module packages

An optional list of php module packages to install. Accepts an array of package names. When using CentOS, package names are prefixed with php53u instead of php. To see a list of available php modules on CentOS, run 'yum search php53u' on the server. Example: php53u-mysql, php53u-pecl-memcache

Percentage of the LVM used for data (1)

The percentage of the total Volume Group extents (LVM) that is used for data. (e.g. 50 percent - 1/2 used for data and remainder used for overhead and snapshots, 100 percent - all space is allocated for data (therefore snapshots can not be taken). WARNING: If the space used for data storage is too large, LVM snapshots cannot be performed. Using a non-default value is not recommended. Make sure you understand what you are doing before changing this value.

Percentage of the LVM used for data (2)

Percentage of the ephemeral LVM used for data

The percentage of the total ephemeral Volume Group extents (LVM) that is used for data (e.g. 50 percent - 1/2 used for data, 100 percent - all space is allocated for data). WARNING: Using a non-default value is not recommended. Make sure you understand what you are doing before changing this value. Example: 100

Primary Backup Secret (default)

Primary cloud authentication credentials. For Rackspace Cloud Files, use your Rackspace account API key (e.g., cred:RACKSPACE_AUTH_KEY). For clouds that do not require primary credentials (e.g., Amazon), set to 'ignore'. Example: cred:CLOUD_ACCOUNT_KEY

Primary Backup Storage Cloud (default)

The primary backup storage cloud (complete list of supported storage locations is in input dropdown). This is only used if the server's cloud does not have volume support. Example: s3

Primary Backup Storage Cloud Endpoint URL (default)

The endpoint URL for the primary backup storage cloud. This is used to override the default endpoint or for generic storage clouds such as Swift. Example: http://endpoint_ip:5000/v2.0/tokens

Primary Backup User (default)

Primary cloud authentication credentials. For Rackspace Cloud Files, use your Rackspace login username (e.g., cred:RACKSPACE_USERNAME). For OpenStack Swift the format is: 'tenantID:username'. For clouds that do not require primary credentials (e.g., Amazon), set to 'ignore'. Example: cred:CLOUD_ACCOUNT_USERNAME

Private SSH Key

The private SSH key of another instance that gets installed on this instance. Select input type 'key' from the dropdown and then select an SSH key that is installed on the other instance. Example: key:my_key

Process List

A space-separated list of additional processes to monitor in the RightScale Dashboard. Example: sshd crond

Process Match List

A space-separated list of pairs used to match the name(s) of additional processes to monitor in the RightScale Dashboard. Paired arguments are passed in using the following syntax 'name/regex'. Example: ssh/ssh* cron/cron*

Project App root

The destination location where the application code will be placed on the local instance. If you want the application code to be placed in the root directory, use a forward slash (/) otherwise you will need to specify the full path (e.g. /path/to/code). Example: /home/webapps

ROS Prefix

The prefix that will be used to locate the correct tarball of the application. For example, if you're using 'myapp.tgz' specify 'myapp' as the ROS Prefix. Example: myapp

ROS Storage Account Provider

The Remote Object Storage (ROS) service where the tarball of the application code will be retrieved from. Example: s3

Rackspace API Key

The API Key for Rackspace cloud account. This is required for registering instances with Rackspace Managed Cloud.

Rackspace SNET Enabled for Backup

When 'true', Rackspace internal private networking preferred) (is used for communications between servers and Rackspace Cloud Files. Ignored for all other clouds. Example: true

Rackspace Tenant ID

The tenant ID for Rackspace cloud account. This is required for registering instances with Rackspace Managed Cloud.

Rackspace Username

The username for Rackspace cloud account. This is required for registering instances with Rackspace Managed Cloud.

Reconverge List

A space-separated list of recipes to run every 15 minutes, which is designed to enforce system consistency. Example: app::do_firewall_request_open lb_haproxy::do_attach_all

RedHat Network Password

The password associated with the username specified in the rightscale/redhat/username input. Example: cred:REDHAT_SUBSCRIBER_PASSWORD

RedHat Network Username

The username to register the system with under RHN Satellite or Red Hat Network Classic. Example: cred:REDHAT_SUBSCRIBER_USERNAME

Remote Server

Configures an instance to forward its log data to a remote server. Specify either the remote server's FQDN or IP address. Example: syslog.example.com or 192.168.0.1

Repository Branch/Tag/Commit

The specific branch, tag, or commit (SHA) of the specified Git/Subversion repository that the application code will be retrieved from. For Git repositories, use 'master' to retrieve the master branch from the repository. For SVN repositories, use 'HEAD' to retrieve the latest changes from the repository. Example: mybranch

Repository Provider

Specify where the application code should be checked out from. Example: repo_git

Repository URL/ROS Container

The URL that points to the location of the repository that contains the application code. Or the name of the ROS container where a tarball of the application code will be retrieved from if you use 'repo_ros' provider. For Amazon S3, use the bucket name. Example: mycontainer, http://mysvn.net/app/ or git://github.com/username/myapp.git

SSL Certificate

The name of your SSL Certificate. Example: cred:SSL_CERT

SSL Certificate Chain

Your SSL Certificate Chain. Example: cred:SSL_CERT_CHAIN

SSL Certificate Key

Your SSL Certificate Key. Example: cred:SSL_KEY

SSL Enable

Enables SSL ('https'). Example: true

SSL Passphrase

Your SSL passphrase. Example: cred:SSL_PASSPHRASE

Secondary Backup Secret (default)

Secondary cloud authentication credentials. For Rackspace Cloud Files, use your Rackspace account API key (e.g., cred:RACKSPACE_AUTH_KEY). For Amazon S3, use your Amazon secret key (e.g., cred:AWS_SECRET_ACCESS_KEY). Example: cred:CLOUD_ACCOUNT_KEY

Secondary Backup Storage Cloud (default)

The secondary backup storage cloud. (See complete list of supported storage locations in input dropdown). Example: s3

Secondary Backup Storage Cloud Endpoint URL (default)

The endpoint URL for the secondary backup storage cloud. This is used to override the default endpoint or for generic storage clouds such as Swift. Example: http://endpoint_ip:5000/v2.0/tokens

Secondary Backup Storage Container (1)

The secondary backup storage container where the backup will be saved to or restored from. For Amazon S3, use the bucket name. For Rackspace Cloud Files, use the container name. Example: db_backup_bucket

Secondary Backup Storage Container (2)

Secondary Backup User (default)

Secondary cloud authentication credentials. For Rackspace Cloud Files, use your Rackspace login username (e.g., cred:RACKSPACE_USERNAME). For OpenStack Swift the format is: 'tenantID:username'. For Amazon S3, use your Amazon key ID (e.g., cred:AWS_ACCESS_KEY_ID). Example: cred:CLOUD_ACCOUNT_USERNAME

Server Usage

When set to 'dedicated' all server resources are allocated to MySQL. When set to 'shared' less resources are allocated for MySQL so that it can be run concurrently with other apps like Apache and Rails for example. Example: shared

Short Hostname

The short hostname that you would like this node to have. Example: myhost

Slave Backup Cron Hour

By default, primary backups of the slave database are taken hourly. However, if you specify a value in this input (e.g., 23 for 11:00 PM), then backups will occur once per day at the specified hour, rather than hourly. Example: 23.

Slave Backup Cron Minute

Defines the minute of the hour when the backup EBS snapshot will be taken of the slave database. Backups of the slave are taken hourly. By default, a minute will be randomly chosen at launch time. Uses standard crontab format (e.g., 30 for minute 30 of the hour). Example 30

Slave SSL Certificate

The name of your Slave SSL Certificate. This is one of the 5 inputs needed to do secured replication. Example: cred:SLAVE_CERT. Please DO NOT use this input for LAMP ServerTemplates.

Slave SSL Key

The name of your Slave SSL Key. This is one of the 5 inputs needed to do secured replication. Example: cred:SLAVE_KEY. Please DO NOT use this input for LAMP ServerTemplates.

Slave Secondary Backup Cron Hour

By default, secondary backups of the slave database are taken hourly. However, if you specify a value in this input (e.g., 23 for 11:00 PM), then backups will occur once per day at the specified hour, rather than hourly. Uses standard crontab format (e.g., 23 for 11:00 PM).

Slave Secondary Backup Cron Minute

Defines the minute of the hour when the secondary backup will be taken of the slave database. Backups of the slave are taken hourly. By default, a minute will be randomly chosen at launch time. Uses standard crontab format (e.g., 30 for minute 30 of the hour). Uses standard crontab format (e.g., 30 for minute 30 of the hour).

Storage Cloud Endpoint URL

The endpoint URL for the storage cloud. This is used to override the default endpoint or for generic storage clouds such as Swift. Example: http://endpoint_ip:5000/v2.0/tokens

Swap size in GB

Creates and activates a swap file based on the selected size (in GB). Note: The swap added by this file will be in addition to any swap defined in the image. Example: 1.0

Swapfile location

The location of the swap file. Example: /mnt/ephemeral/swapfile

Terminate Safety

Prevents the accidental running of the 'db::do_teminate_server' recipe. This recipe will only run if this input variable is overridden and set to "off". Example: text:off

Timezone

Sets the system time to the timezone of the specified input, which must be a valid zoneinfo/tz database entry. If the input is 'unset' the timezone will use the 'localtime' that's defined in your RightScale account under Settings -> User Settings -> Preferences tab. You can find a list of valid examples from the timezone pulldown bar in the Preferences tab. Example: US/Pacific

Total Volume Size (1)

Defines the total size of the LVM volume stripe set (in GB). For example, if the stripe_count is '3' and you specify '3' for this input, it will create an LVM volume stripe that contains 3 volumes that are each 1 GB in size. If an uneven ratio is defined, volume sizes will be rounded up to the nearest whole integer. Ignored on clouds that do not support volumes (e.g., Rackspace). Example: 10

Total Volume Size (2)

Volume Type

The type of the volume - SATA or SSD. This attribute is supported only on Rackspace Open Cloud. Example: SATA

Revision History

Revision	Date Published	Description of Changes	Known Issues
2	Aug 30, 2013	Initial release. See v13.5 LTS Release Notes.	N/A