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-boun...@lists.kamailio.org [mailto:users-boun...@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
