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 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
|
#!/bin/bash
set -eu -o pipefail
MYSQL_VERSION=8.2.0
MYSQL_IMAGE="mysql:$MYSQL_VERSION"
BENCH_IMAGE="mysql-bench"
source ~/.profile
cd $(dirname $0)
. ../../test/util.sh
. ../param.bash
# sometimes fail to pull images
# this is workaround
# https://github.com/containerd/nerdctl/issues/622
systemctl --user restart containerd
sleep 1
systemctl --user restart buildkit
sleep 3
systemctl --user status --no-pager containerd
systemctl --user status --no-pager buildkit
sudo nerdctl build -f ./Dockerfile -t $BENCH_IMAGE .
nerdctl build -f ./Dockerfile -t $BENCH_IMAGE .
sudo nerdctl pull --quiet $MYSQL_IMAGE
nerdctl pull --quiet $MYSQL_IMAGE
echo "===== Benchmark: mysql rootful via NetNS ====="
(
set +e
sudo nerdctl rm -f mysql-server
sudo nerdctl rm -f mysql-client
set -ex
sudo nerdctl run -d --name mysql-server -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=bench $MYSQL_IMAGE
sudo nerdctl run -d --name mysql-client $BENCH_IMAGE sleep infinity
SERVER_IP=$(sudo nerdctl inspect mysql-server | jq -r .[0].NetworkSettings.Networks.'"unknown-eth0"'.IPAddress)
sleep 30
sudo nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$SERVER_IP --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_common prepare
sudo nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$SERVER_IP --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_read_write run > mysql-rootful-direct.log
sudo nerdctl rm -f mysql-server
sudo nerdctl rm -f mysql-client
)
echo "===== Benchmark: mysql rootful via host ====="
(
set +e
sudo nerdctl rm -f mysql-server
sudo nerdctl rm -f mysql-client
set -ex
sudo nerdctl run -d -p 13306:3306 --name mysql-server -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=bench $MYSQL_IMAGE
sudo nerdctl run -d --name mysql-client $BENCH_IMAGE sleep infinity
sleep 30
sudo nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$HOST_IP --mysql-port=13306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_common prepare
sudo nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$HOST_IP --mysql-port=13306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_read_write run > mysql-rootful-host.log
sudo nerdctl rm -f mysql-server
sudo nerdctl rm -f mysql-client
)
echo "===== Benchmark: mysql client(w/o bypass4netns) server(w/o bypass4netns) via intermediate NetNS ====="
(
set +e
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
set -ex
nerdctl run -d --name mysql-server -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=bench $MYSQL_IMAGE
nerdctl run -d --name mysql-client $BENCH_IMAGE sleep infinity
SERVER_IP=$(nerdctl inspect mysql-server | jq -r .[0].NetworkSettings.Networks.'"unknown-eth0"'.IPAddress)
sleep 30
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$SERVER_IP --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_common prepare
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$SERVER_IP --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_read_write run > mysql-wo-b4ns-direct.log
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
)
echo "===== Benchmark: mysql client(w/o bypass4netns) server(w/o bypass4netns) via host ====="
(
set +e
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
set -ex
nerdctl run -d -p 13306:3306 --name mysql-server -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=bench $MYSQL_IMAGE
nerdctl run -d --name mysql-client $BENCH_IMAGE sleep infinity
sleep 30
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$HOST_IP --mysql-port=13306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_common prepare
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$HOST_IP --mysql-port=13306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_read_write run > mysql-wo-b4ns-host.log
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
)
echo "===== Benchmark: mysql client(w/ bypass4netns) server(w/ bypass4netns) via host ====="
(
set +e
systemctl --user stop run-bypass4netnsd
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
systemctl --user reset-failed
set -ex
systemd-run --user --unit run-bypass4netnsd bypass4netnsd
nerdctl run --annotation nerdctl/bypass4netns=true -d -p 13306:3306 --name mysql-server -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=bench $MYSQL_IMAGE
nerdctl run --annotation nerdctl/bypass4netns=true -d --name mysql-client $BENCH_IMAGE sleep infinity
sleep 30
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$HOST_IP --mysql-port=13306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_common prepare
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$HOST_IP --mysql-port=13306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_read_write run > mysql-w-b4ns.log
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
systemctl --user stop run-bypass4netnsd
)
echo "===== Benchmark: mysql client(w/ bypass4netns) server(w/ bypass4netns) with multinode ====="
(
set +e
systemctl --user stop run-bypass4netnsd
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
systemctl --user stop etcd.service
systemctl --user reset-failed
set -ex
systemd-run --user --unit etcd.service /usr/bin/etcd --listen-client-urls http://$HOST_IP:2379 --advertise-client-urls http://$HOST_IP:2379
systemd-run --user --unit run-bypass4netnsd bypass4netnsd --multinode=true --multinode-etcd-address=http://$HOST_IP:2379 --multinode-host-address=$HOST_IP
nerdctl run --annotation nerdctl/bypass4netns=true -d -p 13306:3306 --name mysql-server -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=bench $MYSQL_IMAGE
nerdctl run --annotation nerdctl/bypass4netns=true -d --name mysql-client $BENCH_IMAGE sleep infinity
SERVER_IP=$(nerdctl inspect mysql-server | jq -r .[0].NetworkSettings.Networks.'"unknown-eth0"'.IPAddress)
sleep 30
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$SERVER_IP --mysql-port=3306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_common prepare
nerdctl exec mysql-client sysbench --threads=4 --time=60 --mysql-host=$SERVER_IP --mysql-port=3306 --mysql-db=bench --mysql-user=root --mysql-password=pass --db-driver=mysql oltp_read_write run
nerdctl rm -f mysql-server
nerdctl rm -f mysql-client
systemctl --user stop run-bypass4netnsd
systemctl --user stop etcd.service
systemctl --user reset-failed
)
|