mysqlsct

mysqlsct is a benchmark tool to test strict consistency read, supports MySQL MGR,PolarDB,Aurora,TiDB,etc

Another, mysqlsct support to test short connection mode and remain qps mode with custom query.

Get the source codes

git clone https://github.com/sunashe/mysqlsct.git

Compile mysqlsct

yum install mariadb-devel.x86_64 -y
cmake .
make

Usage

mysqlsct \
--host-rw=127.0.0.1 \
--host-ro=127.0.0.1 \
--port-rw=3407 \
--port-ro=3408 \
--user=sunashe \
--password=**** \
--iterations=100000 \
--table-cnt=1 \
--table-size=1000 \
--concurrency=1 \
--database=sct \
--sc-gap-us=0 \
--report-interval=2 \
--test-mode=sct

e.g.

--host-rw=127.0.0.1 \
--host-ro=127.0.0.1 \
--port-rw=3407 \
--port-ro=3408 \
--user=sunashe \
--password=**** \
--iterations=100000 \
--table-cnt=1 \
--table-size=1000 \
--concurrency=1 \
--database=sct \
--sc-gap-us=0 \
--report-interval=2 \
--test-mode=sct

Input parameters: 
host-rw: 127.0.0.1
host-ro: 127.0.0.1
database: sct
port-rw: 3407
port-ro: 3407
user: sunashe
password: ****
iterations: 100000
table-cnt: 1
table-size: 1000
sc-gap-us: 0
report-interval: 2
detail-log: 0
concurrency: 1
###########################################
Strict consistency tps: 1896, failed qps: 0
Strict consistency tps: 2511, failed qps: 0
Strict consistency tps: 2624, failed qps: 0
Strict consistency tps: 2574, failed qps: 0
Strict consistency tps: 2607, failed qps: 0
Strict consistency tps: 2545, failed qps: 0
...
Strict consistency tps: 2529, failed qps: 0
Strict consistency tps: 2515, failed qps: 0
Strict consistency tps: 2171, failed qps: 0
Test strict consistency cnt: 100000, failed cnt: 0

parameter specification

$ ./mysqlsct --help
Usage: mysqlsct [OPTIONS]
-?      --help          Display this help and exit.
-v      --version       Output version information and exit.
-h      --host-rw       mysql RW node host.
-H      --host-ro       mysql RO node host.
-D      --database      mysql database.
-P      --port-rw       mysql RW node port.
-O      --port-ro       mysql RO node port.
-u      --user  mysql user.
-p      --password      mysql password.
-i      --iterations    number of times to run the tests.
-T      --table-cnt     number of tables to test.
-t      --table-size    table size.
-s      --sc-gap-us     time(us) to sleep after write.
-r      --report-interval       periodically report intermediate statistics with a specified interval in seconds.
-k      --detail-log    print detail error log.
-c      --concurrency   number of threads to use.
-m      --test-mode     test mode. now support sct and shortct
-R      --port          mysql port for shortct mode
-o      --host          mysql host for shortct mode
-K      --skip-prepare skip data prepare.
-f      --sleep-after_fail sleep ms after sct failed
--qps           the qps you want to remain in test
--test-time     the totol time in remain_qps mode

To test short connection mode, you should ensure that the query in 'short_connection_querys.txt' can be executed correctly in the database.

mysqlsct \
--host=127.0.0.1 \
--port=3306 \
--user=sunashe \
--password=**** \
--iterations=100000 \
--concurrency=1 \
--database=sct \
--report-interval=2 \
--test-mode=shortct

To test remain qps mode, you should ensure that the query in 'short_connection_querys.txt' can be executed correctly in the database.

mysqlsct \
--host=127.0.0.1 \
--port=3306 \
--user=sunashe \
--password=**** \
--iterations=100000 \
--concurrency=1 \
--database=sct \
--report-interval=2 \
--qps=1000 \
--test-time=60 \
--test-mode=rqps