run-multiconfig

#!/bin/bash

set -u

usage()
{
cat << EOF
usage: $0 options

WARNING: Do not run this script on a working MySQL server. It will stop & start the service and put
put lots of load on the server.

WARNING: The -c (clean) option deletes binary logs and InnoDB logs and may result in data loss.

This script runs through a directory containing one or more mysqld config files. For each file it 
goes through the following steps:
- stops the server, 
- deletes the ib_logs and binlogs 
- restarts the server with the config file passed to --defaults-file
- runs ./run-sysbench 

Once complete it shuts down MySQL and aggregates the sysbench results in a CSV file.

OPTIONS:
   -H   remote host. sets remote options.
   -i   MySQL pid file (required)
   -d   Config directory      				[./conf]
   -s   MySQL socket       				[/tmp/mysql.sock]
   -u   MySQL username					   [root]
   -p   MySQL password
   -w   ReadWrite mode (on/off)    		[on]
   -o   Timeout for each sysbench run  				[60]
   -r   Directory to print results to  				[./results]
   -t   List of thread counts to iterate 						[4 8 16 32 64 128 256]
   -c	Delete binlogs and ib_logfiles when complete (on/off)	[off]
EOF
}


pid=
dir=/tmp/conf
socket=/tmp/mysql.sock
user=root
password=$(egrep ^password /root/.my.cnf | head -1 | cut -f2 -d=)
readwrite=on
timeout=60
resultsdir=./results
threads="8,16,32,64,128"
clean=off
params=

while getopts H:i:d:h:s:u:p:w:o:r:t:c: name
do
  case $name in
    H) hostname="$OPTARG";;
    i) pid="$OPTARG";;
    d) dir="$OPTARG";;
    s) socket="$OPTARG"
    params="$params -s $socket";;
    u) user="$OPTARG"
    params="$params -u $user";;
    p) password="$OPTARG"
    params="$params -p $password";;
    w) readwrite="$OPTARG"
    params="$params -w $readwrite";;
    o) timeout="$OPTARG"
    params="$params -o $timeout";;
    r) resultsdir="$OPTARG"
    params="$params -r $resultsdir";;
    t) threads="$OPTARG"
    params="$params -t $threads";;
    c) clean="$OPTARG";;
    ?) usage
    exit;;
  esac
done

if [[ -z $pid ]]
then
  usage
  exit 1
fi

if [ -n "$hostname" ]
then
  # remote settings
  skiprestart=1
  clean=off
fi

# Have we got any config files to process?
for f in $(find $dir -t file -iname "*.cnf"); do

  # Stop mysql if running
  if [ -e $pid ]; then
    printf "#### Shutting down MySQL \n"
    sudo kill $(sudo cat $pid)
    while [ -e $pid ]; do
      printf "#### Waiting for MySQL to end. \n"
      sleep 2
    done
    printf  "#### MySQL ended. \n"
  fi
    
  # Fire up MySQL with this config and then give it some time to warm up
  printf "#### Starting MySQL with $f \n"
  sudo mysqld_safe --defaults-file=$dir/$f &
  while [ ! -e $pid ]; do
    printf "#### Waiting for MySQL to start. \n"
    sleep 2
  done
  printf  "#### MySQL started. \n"
  
  # Run sysbench passing through some params
  printf "Running run-sysbench with $params \n"
  ./run-sysbench $params
  
done

# Aggregate the results into a results.csv file
./aggregate-results -r $resultsdir > $resultsdir/results.csv

# Stop mysql if running
if [ -e $pid ]; then
  printf "#### Shutting down MySQL \n"
  sudo kill $(sudo cat $pid)
  while [ -e $pid ]; do
    printf "#### Waiting for MySQL to end. \n"
    sleep 2
  done
  printf  "#### MySQL ended. \n"
  
  if [ "$clean" == "on" ]; then
    # Delete the bin log and innodb logs so they can be recreated
    sudo rm -f $(cat $dir/$f | grep innodb_log_group_home_dir | \
    sed -e 's/innodb_log_group_home_dir//' -e 's/ //g' \
    	-e 's/=//')/ib_*
    sudo rm -f $(cat $dir/$f | grep log-bin | sed \
  	-e 's/log-bin//' -e 's/ //g' -e 's/=//')*
  fi
fi
exit 1