# Create ext4 RAID

sudo mdadm --create --verbose /dev/md0 --level=10 --raid-devices=4 \
   --name=mysql /dev/sdb /dev/sdc /dev/sdd /dev/sde
sudo mkdir /mysql-ext4
sudo mkfs.ext4 /dev/md0
sudo mount -o rw,relatime /dev/md0 /mysql-ext4
sudo mkdir /mysql-ext4/msb
sudo chown revin.revin /mysql-ext4/msb

# Create Percona XtraDB Cluster 5.7.18 standalone on ext4
env SANDBOX_BINARY=/home/revin/mysql make_sandbox 5.7.180 -- \
  --upper_directory=/mysql-zfs/data/msb --my_clause=innodb_buffer_pool_size=1G \
  --my_clause=innodb_log_file_size=8G --my_clause=innodb_flush_method=O_DIRECT \
  --my_clause=innodb_doublewrite=1 --my_clause=binlog_format=ROW \
  --my_clause=innodb_autoinc_lock_mode=2 --my_clause=bind-address=0.0.0.0 \
  --my_clause=default-storage-engine=InnoDB --my_clause=innodb_flush_log_at_trx_commit=0 \
  --my_clause=wsrep_provider=/home/revin/mysql/5.7.180/lib/libgalera_smm.so \
  --my_clause=wsrep_cluster_name=zfs --my_clause=wsrep_cluster_address=gcomm:// \
  --my_clause=wsrep_sst_method=xtrabackup-v2 --my_clause=wsrep_sst_auth=msandbox:msandbox \
  --my_clause=wsrep_node_name=zfs01 --my_clause=wsrep_node_address=10.128.0.2

# Create RAID10 ZFS pool
sudo zpool create -f mysql-zfs -o ashift=12 mirror /dev/sdb /dev/sdc mirror /dev/sdd /dev/sde
sudo zfs set recordsize=16k mysql-zfs
sudo zfs set atime=off mysql-zfs
sudo zfs set logbias=throughput mysql-zfs
sudo zfs set primarycache=metadata mysql-zfs
sudo zfs set compression=lz4 mysql-zfs
sudo zpool add -f mysql-zfs log mirror /dev/nvme0n1 /dev/nvme0n2
sudo zfs create -o recordsize=128K mysql-zfs/logs
sudo zfs create -o recordsize=16K mysql-zfs/data
sudo mkdir -p /mysql-zfs/logs/innodb
sudo mkdir -p /mysql-zfs/data/msb
sudo chown revin.revin /mysql-zfs/logs/innodb
sudo chown revin.revin /mysql-zfs/data/msb

# Create Percona XtraDB Cluster 5.7.18 standalone on ext4
env SANDBOX_BINARY=/home/revin/mysql make_sandbox 5.7.180 -- \
  --upper_directory=/mysql-zfs/data/msb --my_clause=innodb_buffer_pool_size=1G \
  --my_clause=innodb_log_file_size=8G --my_clause=innodb_flush_method=O_DIRECT \
  --my_clause=innodb_log_group_home_dir=/mysql-zfs/logs/innodb \
  --my_clause=innodb_doublewrite=1 --my_clause=binlog_format=ROW \
  --my_clause=innodb_autoinc_lock_mode=2 --my_clause=bind-address=0.0.0.0 \
  --my_clause=default-storage-engine=InnoDB --my_clause=innodb_flush_log_at_trx_commit=0 \
  --my_clause=wsrep_provider=/home/revin/mysql/5.7.180/lib/libgalera_smm.so \
  --my_clause=wsrep_cluster_name=zfs --my_clause=wsrep_cluster_address=gcomm:// \
  --my_clause=wsrep_sst_method=xtrabackup-v2 --my_clause=wsrep_sst_auth=msandbox:msandbox \
  --my_clause=wsrep_node_name=zfs01 --my_clause=wsrep_node_address=10.128.0.2

# sysbench tests
time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
	--mysql-db=test --mysql-host=127.0.0.1 --mysql-port=57190 --tables=8 \
	--table-size=20000000 --auto-inc=off --threads=8 --time=0 \
	--rand-type=pareto oltp_read_only prepare && \
sleep 300 && \
time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
	--mysql-db=test --mysql-host=127.0.0.1 --mysql-port=57190 --tables=8 \
	--table-size=20000000 --auto-inc=off --threads=8 --time=1800 \
	--rand-type=pareto oltp_read_write run && \
sleep 300 && \
time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
	--mysql-db=test --mysql-host=127.0.0.1 --mysql-port=57190 --tables=8 \
	--table-size=20000000 --auto-inc=off --threads=8 --time=1800 \
	--rand-type=pareto oltp_update_index run && \
sleep 300 && \
time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
	--mysql-db=test --mysql-host=127.0.0.1 --mysql-port=57190 --tables=8 \
	--table-size=20000000 --auto-inc=off --threads=8 --time=1800 \
	--rand-type=pareto oltp_read_only run && \
sleep 300 && \
time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
	--mysql-db=test --mysql-host=127.0.0.1 --mysql-port=57190 --tables=8 \
	--table-size=20000000 --auto-inc=off --threads=8 --time=1800 \
	--rand-type=pareto oltp_read_only cleanup