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/02 12:15
This archive was generated by hypermail 2.2.0 : 2008/10/02 12:32 CEST