MySQL Forums
Forum List  »  Quality Assurance

How to analyze mysql-proxy performance and how to improve it?
Posted by: ma hao
Date: October 21, 2011 03:37PM

Hi,

Recently, we installed mysql-proxy as proxy to transfer query request to backend servers which are working as master-slave. And also we use lua script to make it working as failover.

{code}
function connect_server()
local s = proxy.global.backends[1]
-- local s = proxy.global.backends[2]

if s.state ~= proxy.BACKEND_STATE_DOWN then
proxy.connection.backend_ndx = 1
-- proxy.connection.backend_ndx = 2
else
-- os.execute("/bin/mail hao.1.ma.ext@nsn.com -s 't66 mysqld is dow' <<<'mysqld is down'")
proxy.connection.backend_ndx = 2
-- proxy.connection.backend_ndx = 1
end
end
{code}

But we met a significant performance problem about mysql-proxy.

After deployed our service response very slow.

So please any body tell me how to do tuning work or performance testing on mysql-proxy?

BR
Ma Hao

Options: ReplyQuote


Subject
Views
Written By
Posted
How to analyze mysql-proxy performance and how to improve it?
2209
October 21, 2011 03:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.