mariadb --socket=/primary/data/mysql.sock -e "DROP DATABASE IF EXISTS test; CREATE DATABASE test;"
sleep 10
BMK_HOME=/test-data/BMK
source $BMK_HOME/.bench
threads=48
cd $BMK_HOME/sb_exec/lua

$BMK_HOME/sysbench-1.1-mysql80-ssl111L-x64 $BMK_HOME/sb_exec/lua/OLTP_RW-index_updates-trx.lua   --db-driver=mysql --mysql-host=localhost --events=0 --time=300 --mysql-db=test --mysql-password=.userMDS00 --mysql-socket=/primary/data/mysql.sock --mysql-user=tester --threads=${threads} --rand-type=uniform --tables=8 --forced-shutdown=1 --table-size=10000000 --mysql-ssl=disabled --thread-init-timeout=0 --auto-inc=on create
sleep 30
$BMK_HOME/sysbench-1.1-mysql80-ssl111L-x64 $BMK_HOME/sb_exec/lua/OLTP_RW-index_updates-trx.lua   --db-driver=mysql --mysql-host=localhost --events=0 --time=300 --mysql-db=test --mysql-password=.userMDS00 --mysql-socket=/primary/data/mysql.sock --mysql-user=tester --threads=${threads} --rand-type=uniform --tables=8 --forced-shutdown=1 --table-size=10000000  --mysql-ssl=disabled --thread-init-timeout=0 --auto-inc=on prepare
PRIMARY_GTID=$(mariadb --socket=/primary/data/mysql.sock -N -e "SELECT @@global.gtid_binlog_state;")
start_time=$(date +%s.%N)
mariadb --socket=/secondary/data/mysql.sock -vvv -e "SELECT MASTER_GTID_WAIT('$PRIMARY_GTID');" 
end_time=$(date +%s.%N)
duration=$(echo "$end_time - $start_time" | bc)
echo "GTID sync caught up in: $duration seconds"
mariadb --socket=/secondary/data/mysql.sock -vvv -e "show replica status \G"
echo "altering schema in replica with storage=duckdb and removing autincrement"
mariadb --socket=/secondary/data/mysql.sock -e "source /test-data/repl-build/alter-sysbench-duckdb.sql;"