#this will start primary 
./setup-prim.sh
#this will start secondary and will do replication setup
./setup-sec.sh
sleep 10
#this will create schema, alter schema in secondary with storage=duckdb and populate sysbench tables with 8 table x 10 millioon rows
./prepare.sh
sleep 10
#This will generate load on primary with 48 threads, update-key with autocommit. Note, se
mariadb --socket=/secondary/data/mysql.sock -e "stop replica sql_thread;"
sleep 10
./run-key-txn.sh
sleep 30
/test-data/repl-build/mariadb-11.4.13-linux-x86_64/bin/mariadb --socket=/secondary/data/mysql.sock -e "SELECT run_in_duckdb('PRAGMA force_checkpoint');"
sleep 10
#./start-all-monitor.sh
#start sql_thread to start the 
mariadb --socket=/secondary/data/mysql.sock -e "start replica sql_thread;"
GTID_IO_VAL=$(mariadb --socket=/secondary/data/mysql.sock  -e "SHOW REPLICA STATUS\G" | grep "Gtid_IO_Pos:" | awk '{print $2}')
echo $GTID_IO_VAL
start_time=$(date +%s.%N)
mariadb --socket=/secondary/data/mysql.sock -e "SELECT MASTER_GTID_WAIT('$GTID_IO_VAL');show replica status \G" 
end_time=$(date +%s.%N)
duration=$(echo "$end_time - $start_time" | bc)
echo "Transaction time in secondary in: $duration seconds"
#./stop-all-monitor.sh
mariadb --socket=/primary/data/mysql.sock -e "shutdown;"
sleep 20
mariadb --socket=/secondary/data/mysql.sock -e "shutdown;"
sleep 10