[Kamailio-Users] mysql loadbalancing

[Olle E. Johansson]

22 jan 2010 kl. 00.33 skrev Iñaki Baz Castillo:

> El Jueves, 21 de Enero de 2010, Olle E. Johansson escribió:
>> I would suggest that you make sure that the mysql server that is restarted
>> gets the prepared statements before you open it for access from the
>> outside world.
> 
> This is not possible. A prepared statement is created by a DB client once per 
> connection. This is: is 4 different clients use the same prepared statements 
> against the same MySQL server, all of them must declare all the prepared 
> statements in their specific connection to the database.


You see, I did not know.
Then LUA is your best friend. The proxy will hide the fact that it's a new connection to your application, so the proxy in itself needs to take care of it.

/O