- would you consider a virtual IP and possibly MySQL Multi-Master Manager?<br><a href="http://mysql-mmm.org/">http://mysql-mmm.org/</a><br><br clear="all">--<br>Singer XJ Wang, Senior System and Database Administrator<br>The Pythian Group - love your data<br>
<a href="http://www.pythian.com">http://www.pythian.com</a><br>Desk: (613) 565-8696 x298<br>Cell: (613) 266-3763<br><br>
<br><br><div class="gmail_quote">On Tue, Nov 30, 2010 at 19:45, Mike <span dir="ltr"><<a href="mailto:list@net-wall.com">list@net-wall.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">The only thing I found workable, is to use a hostname (i.e. asterisk_sql) and update /etc/hosts according to which SQL server is up or down.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">It’s a bit of a hassle, and it would be easier if Asterisk supported fallback SQL servers, but once done it works well.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Mike</span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a> [mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>] <b>On Behalf Of </b>Duane Larson<br>
<b>Sent:</b> Tuesday, November 30, 2010 7:34 PM<br><b>To:</b> Asterisk Users Mailing List - Non-Commercial Discussion<br><b>Subject:</b> [asterisk-users] Asterisk with MySQL Cluster</span></p><div class="im"><p class="MsoNormal">
</p><p>I have MySQL Cluster set up for OpenSIPS which allows for the best Redundant High-Availability. I was wondering if it's possible for Asterisk to also use multiple database servers for Realtime? Currently with Realtime I am only able to point to a single IP address for a database. If that database server goes down that Asterisk is pointed to then Asterisk won't be able to do anything. Any options within Asterisk 1.8 to make it more fault tolerant when it comes to Realtime and databases?</p>
</div></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>
<pre>--
The best compliment you could give Pythian for our service is a referral.