|
using this as test.lua
require("oltp_common")
function prepare_statements()
– empty
end
function event()
con:query("START TRANSACTION READ ONLY")
print(con:query_row("select variable_value from information_schema.global_variables where variable_name='hostname'"))
con:query("COMMIT")
end
and with that command line:
sysbench test.lua --mysql-host=127.0.0.1 --mysql-port=6611 --mysql-user=... --mysql-password=... --mysql-db=sbtest --threads=20 --events=20 run
I can see that the service with master_accept_reads=true indeed gets routed to the master. Whereas the service without that line gets routed to the slaves.
Must be a bug in the reporting then. See attachment rw2.txt
|