<div>For me OpenSIPS will do most of the work. Asterisk will only handle Hunt Groups/Queues, IVRs, and Voicemail when OpenSIPS forwards that traffic to Asterisk. And since I already have MySQL Cluster working in a redundant fashion I am not sure I want to try out MMM MySQL. I do like the idea of using DNS with hosts file and monitoring the MySQL service on the remote machine and if the service goes down then rewrite the IP in the hosts file. I will have to test that out.</div>
<div> </div>
<div>If anyone else has any experience I would love to add that to this thread.<br><br></div>
<div class="gmail_quote">On Tue, Nov 30, 2010 at 7:04 PM, Singer X.J. Wang <span dir="ltr"><<a href="mailto:wang@pythian.com">wang@pythian.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Most of the solutions there are too complex and not really suited for Asterisk's low usage. I would seriously consider using MySQL MMM and two MySQL servers in a master-master role. Have the asterisk server also serve as the MMM-Manager and its not that hard. You have automated failovers in MySQL in the 1-2 second range.<br>
<font color="#888888"><br>Singer</font>
<div>
<div></div>
<div class="h5"><br><br>
<div class="gmail_quote">On Tue, Nov 30, 2010 at 19:51, David Backeberg <span dir="ltr"><<a href="mailto:dbackeberg@gmail.com" target="_blank">dbackeberg@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div>On Tue, Nov 30, 2010 at 7:34 PM, Duane Larson <<a href="mailto:duane.larson@gmail.com" target="_blank">duane.larson@gmail.com</a>> wrote:<br>> I have MySQL Cluster set up for OpenSIPS which allows for the best Redundant<br>
> High-Availability. I was wondering if it's possible for Asterisk to also<br>> use multiple database servers for Realtime? Currently with Realtime I am<br>> only able to point to a single IP address for a database. If that database<br>
> server goes down that Asterisk is pointed to then Asterisk won't be able to<br>> do anything. Any options within Asterisk 1.8 to make it more fault tolerant<br>> when it comes to Realtime and databases?<br>
<br></div></div><a href="http://dev.mysql.com/doc/refman/5.0/en/ha-overview.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/ha-overview.html</a><br><br>It's a fair amount of work for what in my opinion is a minimal reward.<br>
If you've hardened everything else and this is the only single point<br>of failure left in your entire infrastructure, you should be able to<br>sleep well at night.<br><font color="#888888"><br>--<br></font>
<div>
<div></div>
<div>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank">http://www.api-digital.com</a> --<br>New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br></div></div>
<div>
<div></div>
<div class="h5"><pre>--
The best compliment you could give Pythian for our service is a referral.
</pre></div></div><br>--<br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>
Duane<br>*--*--*--*--*--*<br>--<br>