[Kamailio-Users] mysql loadbalancing

[Daniel-Constantin Mierla]

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

-- 
Daniel-Constantin Mierla
* http://www.asipto.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100121/842589ee/attachment.htm>