Re: [Kamailio-Users] mysql loadbalancing

Hello,

On 1/21/10 4:38 PM, BERGANZ François wrote:

Hello,

I need to know if Kamailio can change Mysql Server if there is a problem with a mysql server ?

kamailio does auto-reconnect if the connection is dropped for some reason, e.g., if you restart mysql everything should go on normally when it is back again.

What i do for redundancy is using two replicated mysql servers with shared ip, so when one is down the other takes on the ip and kamailio (re)connects automatically to backup server.

Can Kamailio do loadbalancing between 2 mysql servers which are duplicate ?

For that is maybe better to use the solution developed by mysql specialists, the mysql proxy: http://forge.mysql.com/wiki/MySQL_Proxy

Cheers, Daniel