Admin plugin is useless after install (0.7.0)

Asked by Oleksiy Kovyrin on 2009-04-19

Hello,

We're trying mysql-proxy in one of our projects as a simple fail-over mechanism for a set of mysql slaves. After installation we've tried to use MP's admin plugin and it looks like it is completely useless w/o a lua script that'd expose MP internals to admin user. We didn't find any default plugins and it looks kind of strange when you declare the change "switching from hardcoded stuff to a lua-based admin plugin" as something really cool and at the end it renders the plugin useless for all not-hardcore-mysql-plugin-developer users.

So, the question is: where could we find an admin lua script with basic monitoring functionality and why wasn't it included in the release?

Thanks,
Alexey

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Proxy Edit question
Assignee:
No assignee Edit question
Last query:
2009-04-28
Last reply:
2009-05-01
fmpwizard (diego-fmpwizard) said : #1

Hi Alexey,

What functionality were you looking for on the admin plugin?
And I agree, we should've included at least a simple lua script to use with it.

Thanks

On Sun, Apr 19, 2009 at 1:39 AM, Alexey Kovyrin
<email address hidden> wrote:
> New question #67892 on MySQL Proxy:
> https://answers.launchpad.net/mysql-proxy/+question/67892
>
> Hello,
>
> We're trying mysql-proxy in one of our projects as a simple fail-over mechanism for a set of mysql slaves. After installation we've tried to use MP's admin plugin and it looks like it is completely useless w/o a lua script that'd expose MP internals to admin user. We didn't find any default plugins and it looks kind of strange when you declare the change "switching from hardcoded stuff to a lua-based admin plugin" as something really cool and at the end it renders the plugin useless for all not-hardcore-mysql-plugin-developer users.
>
> So, the question is: where could we find an admin lua script with basic monitoring functionality and why wasn't it included in the release?
>
> Thanks,
> Alexey
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
http://www.fmpwizard.com

Oleksiy Kovyrin (kovyrin) said : #2

Some basic functionality like:
1) Number of queries processed, maybe some errors counters, etc, etc
2) Backends list with statuses and stats
3) Client connections list, with statuses and stats
etc

fmpwizard (diego-fmpwizard) said : #3

Hi Alexey,

For a very simple example you can see
http://datacharmer.blogspot.com/2009/01/mysql-proxy-is-back.html

and to extend that lua script, you can access from the admin plugin
all the information that the proxy plugin has access to as well.

> 1) Number of queries processed, maybe some errors counters, etc, etc

You can see http://forge.mysql.com/tools/tool.php?id=78 to get an idea
of how to implement it.

> 2) Backends list with statuses and stats
http://datacharmer.blogspot.com/2009/01/mysql-proxy-is-back.html

> 3) Client connections list, with statuses and stats

See http://www.chriscalender.com/?p=41

Thanks

Diego

On Tue, Apr 28, 2009 at 12:07 AM, Alexey Kovyrin
<email address hidden> wrote:
> Question #67892 on MySQL Proxy changed:
> https://answers.launchpad.net/mysql-proxy/+question/67892
>
>    Status: Answered => Open
>
> Alexey Kovyrin is still having a problem:
> Some basic functionality like:
> 1) Number of queries processed, maybe some errors counters, etc, etc
> 2) Backends list with statuses and stats
> 3) Client connections list, with statuses and stats
> etc
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
http://www.fmpwizard.com

fmpwizard (diego-fmpwizard) said : #4

Hi Alexey,

Here you will find a sample script to use

http://fmpwizard.blogspot.com/2009/04/how-do-i-use-mysql-proxy-admin-plugin.html

(well, two scripts that work together)

Enjoy!

On Tue, Apr 28, 2009 at 8:39 AM, fmpwizard
<email address hidden> wrote:
> Question #67892 on MySQL Proxy changed:
> https://answers.launchpad.net/mysql-proxy/+question/67892
>
>    Status: Open => Answered
>
> fmpwizard proposed the following answer:
> Hi Alexey,
>
> For a very simple example you can see
> http://datacharmer.blogspot.com/2009/01/mysql-proxy-is-back.html
>
> and to extend that lua script, you can access from the admin plugin
> all the information that the proxy plugin has access to as well.
>
>> 1) Number of queries processed, maybe some errors counters, etc, etc
>
> You can see http://forge.mysql.com/tools/tool.php?id=78 to get an idea
> of how to implement it.
>
>> 2) Backends list with statuses and stats
> http://datacharmer.blogspot.com/2009/01/mysql-proxy-is-back.html
>
>> 3) Client connections list, with statuses and stats
>
> See http://www.chriscalender.com/?p=41
>
> Thanks
>
> Diego
>
>
> On Tue, Apr 28, 2009 at 12:07 AM, Alexey Kovyrin
> <email address hidden> wrote:
>> Question #67892 on MySQL Proxy changed:
>> https://answers.launchpad.net/mysql-proxy/+question/67892
>>
>>    Status: Answered => Open
>>
>> Alexey Kovyrin is still having a problem:
>> Some basic functionality like:
>> 1) Number of queries processed, maybe some errors counters, etc, etc
>> 2) Backends list with statuses and stats
>> 3) Client connections list, with statuses and stats
>> etc
>>
>> --
>> You received this question notification because you are a member of
>> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>>
>
>
> --
> Diego Medina
> Web Developer
> http://www.fmpwizard.com
>
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
http://www.fmpwizard.com

Can you help with this problem?

Provide an answer of your own, or ask Oleksiy Kovyrin for more information if necessary.

To post a message you must log in.