[Kamailio-Users] mysql loadbalancing

[Olle E. Johansson]

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