Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > 11H1 > References > LAMP All-In-One with MySQL 5.1 - 11H1

LAMP All-In-One with MySQL 5.1 - 11H1

Table of Contents

  1. Info
  2. Images
  3. Scripts
  4. Inputs
  5. Revision History
  6. See also

Info

Current Revision: 15
MultiCloud Marketplace: https://www.rightscale.com/library/server_templates/LAMP-All-In-One-with-MySQL-5-1/18987

  • Description - Basic all-in-one LAMP server (Linux, Apache, MySQL, PHP). Server is configured to take continuous backups of a MySQL 5.1 database and save them to a user-specified S3 bucket. Suitable for single server test, development and production (non-redundant) purposes.
  • Supported Clouds - AWS US-East, AWS EU, AWS AP-Singapore, AWS AP-Tokyo, AWS US-West

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_5.4_x64_v5.6 - 11H1
    • AWS US-East, AWS EU, AWS AP-Singapore, AWS AP-Tokyo, AWS US-West
  • RightImage_CentOS_5.4_i386_v5.6 - 11H1
    • AWS US-East, AWS EU, AWS AP-Singapore, AWS AP-Tokyo, AWS US-West
  • RightImage_Ubuntu_10.04_i386_v5.6 - 11H1
    • AWS US-East, AWS EU, AWS AP-Singapore, AWS AP-Tokyo, AWS US-West
  • RightImage_Ubuntu_10.04_x64_v5.6 - 11H1
    • AWS US-East, AWS EU, AWS AP-Singapore, AWS AP-Tokyo, AWS US-West

Scripts

Inputs

ADMIN_EMAIL

The email address that Apache uses to send administrative mail (set in /etc/httpd/conf/httpd.conf). By setting it to root@localhost.com emails are saved on the server. You can use your own email address, but your spam filters might block them because reverse DNS lookup will show a mismatch between EC2 and your domain.

APACHE_MPM

Can be set to "worker" or "prefork" and defines the setting in httpd.conf. Use "worker" for Rails/Tomcat/Standalone frontends and "prefork" for PHP.

APPLICATION

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

APPLICATION_CODE_BUCKET

The name of the S3 bucket where the application tarball (.tgz) can be retrieved.

APPLICATION_CODE_PACKAGE

The name of application tarball that can be retrieved from the S3 bucket specified by APPLICATION_CODE_BUCKET. Valid extensions are .tar/, .tar.gz/, .tgz/, .gz/, .zip/, .war/, and .jar. Be sure to include the file extension. (Ex: myapp.tgz)

AWS_ACCESS_KEY_ID

The Access Key ID is an Amazon Access Credential that's used to authenticate your requests to AWS services. It's unique to your AWS Account Number. The Access Key ID and Secret Access Key are used to retrieve objects from an S3 bucket that are 'private'. Log into your AWS account at aws.amazon.com to retrieve your access identifiers. It's strongly recommended that you use a RightScale Credential (Design > Credentials) to hide the actual key value from non-admin users while still allowing them to pass the appropriate value as an input. Ex: 1JHQQ4KVEVM02KVEVM02

AWS_SECRET_ACCESS_KEY

The Secret Access Key is an Amazon Access Credential that's used to authenticate your requests to AWS services. It's unique to your AWS Account Number. The Access Key ID and Secret Access Key are used to retrieve objects from an S3 bucket that are 'private'. Log into your AWS account at aws.amazon.com to retrieve your access identifiers. It's strongly recommended that you use a RightScale Credential (Design > Credentials) to hide the actual key value from non-admin users while still allowing them to pass the appropriate value as an input. Ex: XVdxPgOM4auGcMlPz61IZGotpr9LzzI07tT8s2Ws

DBAPPLICATION_PASSWORD

If the MySQL administrator set up a restricted MySQL account for application servers to access the database, then specify the password of that account for this input. If there is not a restricted MySQL account then use the same value that's used for DBADMIN_PASSWORD. The application server will then have unrestricted access to the database.

DBAPPLICATION_USER

If the MySQL administrator set up a restricted MySQL account for application servers to access the database, then specify the username of that account for this input. If there is not a restricted MySQL account then use the same value that's used for DBADMIN_USER. The application server will then have unrestricted access to the database.

DB_BINLOG_PREFIX

The prefix defines the filename and location of your MySQL stored binlog files. The prefix sets the log-bin variable in MySQL config file. If you do not specify an absolute path, it will be relative to the data directory. Ex: /mnt/mysql-binlogs/mysql-bin

DB_MYSQLDUMP_BUCKET

The S3 bucket where the MySQL database dump files will be stored to or restored from. The S3 bucket is specific to MySQL-S3 setups that are not using binary backups. Typically used for free developer ServerTemplates where binary backups are not supported.

DB_MYSQLDUMP_PREFIX

Defines the prefix of the MySQL dump filename that will be used to name the backup database dumpfile along with a timestamp. Backups are stored in your S3 bucket (DB_MYSQLDUMP_BUCKET). For example, if prefix is 'mydb', the filename will be 'mydb-timestamp.gz'. During a database restoration, the prefix will be used to find the most recent MySQL dumpfile. Each database's prefix should be unique. Ex: mydbprefix

DB_SCHEMA_NAME

Enter the name of the MySQL database schema to which applications will connect. The database schema was created when the initial database was first set up. This input will be used to set the application server's database config file so that applications can connect to the correct schema within the database. This input is also used for MySQL dump backups in order to determine which schema is getting backed up. Ex: mydbschema

DB_SERVER_USAGE

Set this input to "dedicated" if it's a standalone MySQL server. Set to "shared" if you're launching an all-in-one server where there are other applications such as Apache, PHP, Rails, etc. also running on the server.

MASTER_DB_DNSNAME

The fully qualified hostname for the MySQL Master-DB server. There must be a corresponding DNS A Record for the Master-DB server with your DNS provider (e.g. DNSMadeEasy). Application servers and Slave-DB servers will connect to the Master-DB by looking up the IP address that's mapped to the Master-DB's hostname. RightScale's scripts are designed to update the A Record with the Master-DB's private IP address. Ex: master.mydomain.com

MON_PROCESSES

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

MON_PROCESSMATCH

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

OPT_DB_MYSQL_TIMEOUT

Optional period of time to wait for a MySQL server to startup. When starting MySQL with large databases or on databases that need to rebuild tables, you may need to increase this value to prevent a MySQL server from timing out during startup.

OPT_MYSQL_MAX_CONNECTIONS

The maximum number of MySQL connections that can be established across the entire deployment. (Default: 500) Use caution when adjusting this value! Increasing the number of connections can consume large amounts of memory and crash your database.

OPT_PHP_MODULES_LIST

Optional PHP module packages to install. By default php5-mysql and php-pear are installed.

SERVER_UUID

A value of 'env:RS_INSTANCE_UUID' is required for proper RightScale monitoring and logging.

SKETCHY

A value of 'env:RS_SKETCHY' is required to use RightScale monitoring servers.

SYSLOG_SERVER

The hostname of the syslog server where log files will be sent. This input should be set to 'env:RS_SYSLOG' so that you can view your log files in the Dashboard.

SYS_TZINFO

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 -> Preferences tab. You can find a list of valid examples from the timezone pulldown bar in the Preferences tab. Ex: US/Pacific, US/Eastern

WEBSITE_DNS

The fully qualified domain name that the server will accept traffic for. Ex: www.mydomain.com

Revision History

Revision Date Published Description of Changes Known Issues
15 Apr 20, 2011 Fixed DB_MYSQLDUMP_PREFIX input (w3798)  
14 Mar 22, 2011 Initial Release -- 12H1 (w3798) The DB_MYSQLDUMP_PREFIX input has a default value set to 'mysql' however it should be left blank because it's a user-specific value.

You must to post a comment.
Last modified
23:31, 16 May 2013

Tags

Classifications

This page has no classifications.

Announcements

None


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.