-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathrun_pxc_tests.sh
executable file
·86 lines (63 loc) · 2.17 KB
/
run_pxc_tests.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
#!/bin/bash
# Import tests
. ./test_defs.sh
#
# Cleanup anything previous
vagrant destroy -f
# # Use Single node environment for baseline
rm -f Vagrantfile
ln -s Vagrantfile.pxc Vagrantfile
vagrant up --provider=aws
sleep 30
# Baseline tests (remove wsrep settings here manually)
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_INNODB"
echo "PXC 1 node Innodb Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/baseline_innodb.txt
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_MYISAM"
echo "PXC 1 node MyISAM Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/baseline_myisam.txt
vagrant ssh node1 -c "$CLEANUP"
# Single node tests (put wsrep settings back and restart mysql)
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_INNODB"
echo "PXC 1 node Innodb Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/pxc_1_innodb.txt
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_MYISAM"
echo "PXC 1 node MyISAM Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/pxc_1_myisam.txt
vagrant ssh node1 -c "$CLEANUP"
# Startup the other nodes
echo "Bootstrapping"
./bootstrap.sh
#Master/Slave cluster tests
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_INNODB"
echo "Master/Slave Innodb Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/ms_innodb.txt
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_MYISAM"
echo "Master/Slave MyISAM Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/ms_myisam.txt
vagrant ssh node1 -c "$CLEANUP"
#
# # 3 Node Writer tests
#
vagrant ssh node1 -c "$PREPARE_INNODB"
echo "Multi Writer Innodb Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/multi_innodb_1.txt &
vagrant ssh node2 -c "$RUN_TEST" -- > results/multi_innodb_2.txt &
vagrant ssh node3 -c "$RUN_TEST" -- > results/multi_innodb_3.txt
sleep 10;
vagrant ssh node1 -c "$CLEANUP"
vagrant ssh node1 -c "$PREPARE_MYISAM"
echo "Multi Writer MyISAM Test"
vagrant ssh node1 -c "$RUN_TEST" -- > results/multi_myisam_1.txt &
vagrant ssh node2 -c "$RUN_TEST" -- > results/multi_myisam_2.txt &
vagrant ssh node3 -c "$RUN_TEST" -- > results/multi_myisam_3.txt
sleep 10;
vagrant ssh node1 -c "$CLEANUP"
#
# # vagrant destroy -f