James Abley jabley

Tasks for automating deployment

Spin up instance
if not RDS
- Install MySQL (binary, create user account)
- Configure MySQL (lower_case_table_names, etc)
- Start MySQL service
Create DB users (GRANT * on my-db.* to x identified by password)
Create DB schema (source create-my-db-tables.sql)

	clojure:apache2 jabley$ curl -v -o /dev/null http://localhost/
	* About to connect() to localhost port 80 (#0)
	* Trying ::1... connected
	* Connected to localhost (::1) port 80 (#0)
	> GET / HTTP/1.1
	> User-Agent: curl/7.19.7 (universal-apple-darwin10.0) libcurl/7.19.7 OpenSSL/0.9.8l zlib/1.2.3
	> Host: localhost
	> Accept: /
	>
	% Total % Received % Xferd Average Speed Time Time Time Current

	import static org.junit.Assert.assertEquals;

	import javax.crypto.Cipher;
	import javax.crypto.SecretKey;
	import javax.crypto.SecretKeyFactory;
	import javax.crypto.spec.DESedeKeySpec;
	import javax.crypto.spec.IvParameterSpec;

	import org.apache.commons.codec.binary.Hex;
	import org.junit.Test;

	This example shows how to setup an environment running Rails 3 beta 3 under 1.9.2-head with a 'rails3' gem set.

	∴ rvm update --head
	# ((Open a new shell)) or do 'rvm reload'

	# If you do not already have the ruby interpreter installed, install it:
	∴ rvm install 1.9.2-head

	# Switch to 1.9.2-head and gemset rails3, create if it doesn't exist.
	∴ rvm --create use 1.9.2-head@rails3

	PATH=/Users/jabley/.rvm/ruby-1.9.1-p376/bin:/Users/jabley/.rvm/gems/ruby-1.9.1-p376/bin:/Users/jabley/.rvm/bin:$PATH ; export PATH
	RUBY_VERSION='ruby 1.9.1p376' ; export RUBY_VERSION
	GEM_HOME='/Users/jabley/.rvm/gems/ruby-1.9.1-p376' ; export GEM_HOME
	GEM_PATH='/Users/jabley/.rvm/gems/ruby-1.9.1-p376' ; export GEM_PATH
	MY_RUBY_HOME='/Users/jabley/.rvm/ruby-1.9.1-p376' ; export MY_RUBY_HOME
	IRBRC='/Users/jabley/.rvm/ruby-1.9.1-p376/.irbrc' ; export IRBRC
	rvm_ruby_string='ruby-1.9.1-p376' ; export rvm_ruby_string
	unset rvm_gem_set_name

	$ bash < <( curl http://rvm.beginrescueend.com/releases/rvm-install-head )
	...
	$ rvm install 1.9.2-p0
	/Users/jabley/.rvm/rubies/ruby-1.9.2-p0, this may take a while depending on your cpu(s)...

	ruby-1.9.2-p0 - #fetching
	ruby-1.9.2-p0 - #extracting ruby-1.9.2-p0 to /Users/jabley/.rvm/src/ruby-1.9.2-p0
	ruby-1.9.2-p0 - #extracted to /Users/jabley/.rvm/src/ruby-1.9.2-p0
	ruby-1.9.2-p0 - #configuring
	ruby-1.9.2-p0 - #compiling

	participant "Development Team" as D
	participant "Sign-off stakeholders" as S
	participant "Apple" as A

	D->D: Develop functionality
	D->S: Issue candidate version
	S->S: Tests
	S->D: Approve or Reject
	note left of D
	Iterate as required until

	<?xml version="1.0" encoding="UTF-8"?>
	<article xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	article-type="patient-topic"
	id="392795"
	version="23">
	<front>
	<article-meta>
	<title-group>
	<article-title>Diabetes, type 1</article-title>
	<alt-title alt-title-type="abridged">Diabetes, type 1</alt-title>

	101109 20:11:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
	101109 20:11:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
	InnoDB: The first specified data file ./ibdata1 did not exist:
	InnoDB: a new database to be created!
	101109 20:11:36 InnoDB: Setting file ./ibdata1 size to 10 MB
	InnoDB: Database physically writes the file full: wait...
	101109 20:11:36 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
	InnoDB: Setting log file ./ib_logfile0 size to 5 MB
	InnoDB: Database physically writes the file full: wait...
	101109 20:11:36 InnoDB: Log file ./ib_logfile1 did not exist: new to be created