[Kamailio-Users] mysql loadbalancing

[Alex Balashov]

Iñaki,

On 01/21/2010 04:23 PM, Iñaki Baz Castillo wrote:

> Does such mysql proxy allow prepared statements? They are stored in the
> server, this is, when the MySQL client connects it creates the prepared
> statements in the MySQL server.
> If the MySQL servers restarts it looses the prepared statements so the client
> must react and re-create them. But in the case of a mysql proxy this task
> should take place in the proxy itself, right? Do mysql proxy implement it?

My understanding is that MySQL proxy is a "low-level" proxy that plumbs 
data interchange via MySQL's internal binary protocol, not a 
higher-level representation of the RDBM backend's interface.

It is also my understanding that it creates "sticky" sessions to 
whatever MySQL server is being interacted with.  The meaning of "load 
balancing" is not that every query or statement is executed on a 
different server.  But I could be wrong.

Cheers,

-- Alex

-- 
Alex Balashov - Principal
Evariste Systems LLC

Tel    : +1 678-954-0670
Direct : +1 678-954-0671
Web    : http://www.evaristesys.com/