MySQL Forums
Forum List  »  Router & Proxy

Re: Problem to Read Mysql Proxy Backend Addresses
Posted by: Chris Calender
Date: April 20, 2010 04:58PM

Are you specifying an admin script?

In the newer versions of the proxy, you must specify an administration script to be used when users connect to the administration interface.

So for example, you can download the two scripts (copy/paste) on the following page (save the first as "admin.lua" and the second one as "reporter.lua"):

http://dev.mysql.com/doc/refman/5.0/en/mysql-proxy-using-admin.html

And then you would invoke the proxy as follows:

shell> mysql-proxy --admin-lua-script=admin.lua --admin-password=password \ ยป
--admin-username=root --proxy-backend-addresses=127.0.0.1:3306 -proxy-lua-script=reporter.lua

Using these two scripts will allow you to use the following functions:

show querycounter
show myerror
show proxy processlist
SELECT * FROM backends

(Note that I did edit the above to change --backend-addresses to --proxy-backend-addresses or there would be an error. I've submitted a bug report about this as well, to have it updated in the documentation.)

http://bugs.mysql.com/bug.php?id=53013



Edited 1 time(s). Last edit at 04/20/2010 05:25PM by Chris Calender.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem to Read Mysql Proxy Backend Addresses
2221
April 20, 2010 04:58PM


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.