21 jan 2010 kl. 22.23 skrev Iñaki Baz Castillo:
El Jueves, 21 de Enero de 2010, Olle E. Johansson escribió:
21 jan 2010 kl. 16.38 skrev BERGANZ François:
Hello,
I need to know if Kamailio can change Mysql Server if there is a problem with a mysql server ? Can Kamailio do loadbalancing between 2 mysql servers which are duplicate ?
I've been using mysql proxy for that and it worked fine with kamailio.
Does such mysql proxy allow prepared statements? They are stored in the server, this is, when the MySQL client connects it creates the prepared statements in the MySQL server. If the MySQL servers restarts it looses the prepared statements so the client must react and re-create them. But in the case of a mysql proxy this task should take place in the proxy itself, right? Do mysql proxy implement it?
I've never used prepared statements, so I don't know.
The mysql proxy has support for LUA, so with a bit of hacking you can do whatever you want, but I just used the transparent proxy part.
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. I created scripts that stopped access until we knew that a restarted server was in sync with the replication with the rest of the world, which is more or less the same situation.
/O