[Kamailio-Users] mysql loadbalancing

BERGANZ François francois at acropolistelecom.net
Fri Jan 22 08:38:18 CET 2010


I understand all solutions.
But for the mysql proxy, we need another server... but if the proxy is down,
it is the same problem in fact!




François BERGANZ



-----Message d'origine-----
De : users-bounces at lists.kamailio.org
[mailto:users-bounces at lists.kamailio.org] De la part de Olle E. Johansson
Envoyé : vendredi 22 janvier 2010 08:19
À : Iñaki Baz Castillo
Cc : users at lists.kamailio.org
Objet : Re: [Kamailio-Users] mysql loadbalancing


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
_______________________________________________
Kamailio (OpenSER) - Users mailing list
Users at lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
http://lists.openser-project.org/cgi-bin/mailman/listinfo/users





More information about the sr-users mailing list