gistfile1.txt

1) install drupal & apache & akiban
 
wget http://ftp.drupal.org/files/projects/drupal-7.17.tar.gz
tar zxvf drupal-7.17.tar.gz
sudo apt-get update
sudo apt-get install -y python-software-properties
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv 0AA4244A
sudo add-apt-repository "deb http://software.akiban.com/apt-developer/ lucid main"
sudo apt-get update
sudo apt-get install -y apache2 php5-pgsql php5-gd libapache2-mod-php5 php-apc postgresql-client akiban-server
sudo mkdir /var/www/drupal
sudo mv drupal-7.17/* drupal-7.17/.htaccess /var/www/drupal
sudo cp /var/www/drupal/sites/default/default.settings.php /var/www/drupal/sites/default/settings.php
sudo chown www-data:www-data /var/www/drupal/sites/default/settings.php
sudo mkdir /var/www/drupal/sites/default/files
sudo chown www-data:www-data /var/www/drupal/sites/default/files/
sudo service apache2 restart

2) install akiban module for drupal

sudo apt-get install -y git
git clone http://git.drupal.org/sandbox/posulliv/1835778.git akiban
cd akiban
git checkout 7.x
cd ../
sudo cp -R akiban /var/www/drupal/includes/database/.
sudo chown -R www-data:www-data /var/www/drupal/includes/database/akiban

3) tiny patch needs to be applied to drupal to not create 2 indexes that are not compatible with akiban (this is likely only temporary until we fix this)

sudo cp akiban/core.patch /var/www/drupal
cd /var/www/drupal
sudo patch -p1 < core.patch
cd

4) install drupal through browser (be sure to select akiban as the database driver)

5) after install and site configuration run the following SQL files

psql -h localhost -p 15432 drupal -f akiban/grouping.sql
psql -h localhost -p 15432 drupal -f akiban/gather_stats.sql

6) install devel module through drupal interface in browser
 
7) install drush for data generation
 
wget http://ftp.drupal.org/files/projects/drush-7.x-5.8.tar.gz
tar zxvf drush-7.x-5.8.tar.gz 
sudo ln -s drush/drush /usr/bin/drush
 
8) generate data with drush
 
drush generate-users 50000
drush generate-terms tags 1000
drush generate-vocabs 5000 
drush generate-menus 5000 
drush generate-content 100000 100