[Kamailio-Users] how to use 2 mysql servers?

[Jeremy McNamara]

BERGANZ François wrote:
>
> Hello,
>
>  
>
> I need to know how to use 2 mysql servers, if my first server go down...
>
>  
>
> Have you an idea?
>



Quite a few different ways depending on your ultimate goal.   I believe 
the simplest method would be to setup
a master-master replication between your two mysql servers. 


Then place both IP addresses in a single DNS A record, which gives you a 
round robin effect, but doesn't necessarily achieve 'high availability.'


A more complex situation would be ultramonkey (linux-ha) and/or some 
sort of mysql connection proxying environment.





Jeremy McNamara
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20081201/cc1b3b7f/attachment.htm