[Kamailio-Users] mysql loadbalancing

[Alex Balashov]

Ah, but alas, not all problems can be solved, or, for that matter, are  
necessarily worth solving as dictated by the Pareto Principle.

--
Sent from mobile device

On Jan 22, 2010, at 2:38 AM, BERGANZ François <francois at acropolistelecom.ne 
t> wrote:

> 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
>
>
> _______________________________________________
> 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