Re: MySQL health checks (server monitoring).

From: Unai Rodriguez <me#u-journal.org>
Date: Thu, 02 Oct 2008 20:20:24 -0600

Dear Marcus/Patrick,

Yeah, I actually agree :-) Also, I found about MySQL proxy yesterday through google. It sounds really promising.

The fact is, I am dealing with systems that are already in production status and I have been relying in HAProxy for more than a couple of years with EXCELLENT results.

MySQL proxy is in ALPHA status, and that makes my a little bit uneasy. I do think that tagging something as "alpha" does not necessarily mean that it is too unstable (i.e. GMAIL is still in BETA, heheh), but I need something rock solid.

I saw from previous discussion that Willy was suggesting to create a script hooked to inetd (http://www.formilux.org/archives/haproxy/0710/0053.html) and some other guys were suggesting the php page as well.

I think I will stick to one of these solutions for the moment. I will look into mysql proxy in the near future for sure.

Thank you all so much!
unai

On Thu, 2 Oct 2008 12:15:03 +0200, "Patrick Viet" <patrick.viet#gmail.com> wrote:

> It indeed makes much more sense to me too to use MySQL proxy.
> 
> Patrick
> 
> On Thu, Oct 2, 2008 at 11:51 AM, Marcus Herou
> <marcus.herou#tailsweep.com> wrote:

>> Hi.
>> Just a stupid thought but I think you should use MySQL proxy
>> (http://forge.mysql.com/wiki/MySQL_Proxy) instead of you are

> loadbalancing

>> queries (not insert/update/delete etc)
>>
>> Kindly
>>
>> //Marcus
>>
>> On Thu, Oct 2, 2008 at 11:36 AM, Unai Rodriguez <me#u-journal.org>

> wrote:


>>>

>>> Dear All,

>>>

>>> I am trying to load balance 2 mysql servers using HAProxy.

>>>

>>> Is there a built-in way to check mysql server status (something like
>>> smtpchk or ssl-hello-chk, not just opening tcp connections to port

> 3306)?


>>>

>>> If there is none, any suggestions on what would be a good approach?

>>>

>>> I was thinking of having a PHP page that performs a small query against

>>> the
>>> mysql database and displays OK or ERROR. Then, I should be able to use

> the


>>> httpchk. Any thoughts?

>>>

>>> Thank you!

>>> unai

>>>
>>>
>>
>>
>>
>> --
>> Marcus Herou CTO and co-founder Tailsweep AB
>> +46702561312
>> marcus.herou#tailsweep.com
>> http://www.tailsweep.com/
>> http://blogg.tailsweep.com/
>>
Received on 2008/10/03 04:20