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@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@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] De la part de Olle E. Johansson Envoyé : vendredi 22 janvier 2010 08:19 À : Iñaki Baz Castillo Cc : users@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@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users