| echo "Unknown option $key" |
| # install and configure mysql |
| # not prompting db password |
| debconf-set-selections <<MYSQL_PRESEED |
| mysql-server mysql-server/root_password password $DATABASE_PASSWORD |
| mysql-server mysql-server/root_password_again password $DATABASE_PASSWORD |
| mysql-server mysql-server/start_on_boot boolean true |
| apt-get install -y mysql-server |
| apt-get install -y libmysqld-dev |
| # disable mysql profile in apparmor |
| #sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/ |
| #sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld |
| # allows us not to access mysql without specifying password |
| password=$DATABASE_PASSWORD |
| bzr branch lp:~percona-dev/perconatools/tpcc-mysql |
| mysql -e "CREATE DATABASE $DB_NAME;" |
| mysql "$DB_NAME" < create_table.sql |
| mysql "$DB_NAME" < add_fkey_idx.sql |
| ./tpcc_load localhost "$DB_NAME" "$DATBASE_USER" "$DATABASE_PASSWORD" "$WAREHOUSES" |