|
Some remarks about my environment:
- master and 4 slaves, m5.2xlarge (8 vCPU, 32G RAM); running MariaDB Enterprise 10.6.14
- 1x MaxScale 23.03 configured with readwritesplit router in front, m5.4xlarge
- 4 benchmark drivers c5.xlarge (4 vCPU, 16G RAM), running sysbench oltp_read_write_split.lua
- 1x MaxScale 23.03 as BLR, m5.2xlarge
I think to reproduce this it is enough to have 1 MariaDB server, the MaxScale running BLR and the driver running sysbench1.1. All those processes can be colocated on the same hardware. If distributed then run the MariaDB server and sysbench on one host and MaxScale BLR on the other.
I used oltp_read_write_split.lua --write-percentage=10 (see here) but I guess oltp_read_write.lua is also ok since we don't use the second maxscale with readwritesplit.
Bring the MariaDB server and MaxScale online (both config files included). Point the BLR on the master and make sure it's replicating.
Load the data set; 10 tables with 1 mio rows each. This requires ~2.5GB in the datadir and the buffer pool. Adjust if you don't have that much space. Run as root:
sysbench /path/to/oltp_read_write.lua --mysql-socket={master-socket} --mysql-user=root --mysql-db=test --table-size=1000000 --tables=10 --threads=10 prepare
|
if this was successful, execute (again as root):
sysbench /path/to/oltp_read_write.lua --mysql-socket={master-socket} --mysql-user=root --mysql-db=test --table-size=1000000 --tables=10 --threads=32 --time=300 --rand-type=uniform --report-interval=10 --db-ps-mode=disable run
|
This assumes you run sysbench on the same host than MariaDB. If things go as expected you should see BLR hanging. If not, adjust the number of threads and/or the runtime.
If necessary you can also try oltp_read_write_split.lua with --write-percentage=10. It can be found here. Note: you must also use out copy of oltp_common.lua.
| 
BLR10.png
mariadb-bin.000001.gz
