var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to analyze mysql-proxy performance and how to improve it?
Recently, we installed mysql-proxy as our database proxy which backend servers are running as master-slave.
And also we using the lua script to make mysql-proxy working as failover of backends.
local s = proxy.global.backends
-- local s = proxy.global.backends
if s.state ~= proxy.BACKEND_STATE_DOWN then
proxy.connection.backend_ndx = 1
-- proxy.connection.backend_ndx = 2
-- os.execute("/bin/mail firstname.lastname@example.org -s 't66 mysqld is dow' <<<'mysqld is down'")
proxy.connection.backend_ndx = 2
-- proxy.connection.backend_ndx = 1
But we met a significant problem of mysql-proxy performance is bad.
So my problem is how to analyze mysql-proxy performance and how to tune it?
Tags for this Thread