Hi Chris, thanks for the great tip.<br><br>This means each Asterisk could be updated based on the 2 master databases.<br><br>So to resume it all:<br><br>- One master database is setup on its own server and all writing (inserts and updates) operations are done through it.<br>
- Second master database is replicated as in Chris comment (Master Master). Web data could be fetched from this server as well.<br>- Each Asterisk server would need a local slave mysql database for all read statements.<br>
- Each Asterisk local slave database updates itself on a regular interval from the Masters using mysql_multi<br>- Setup of a DUNDi lookup server (as in JR Richardson's "Using DUNDi with a cluster of Asterisk servers" paper).<br>
<br>Is this something "standard" in a HA Asterisk solution? Has anybody tried something similar?<br>Any comments are appreciated!<br><br>Fred<br><br><br><div class="gmail_quote">On Mon, Nov 2, 2009 at 7:14 PM, Chris Mylonas <span dir="ltr"><<a href="mailto:chris@mrvoip.com.au">chris@mrvoip.com.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Fred,<br><br><br>I suggest running a few Amazon AWS servers for a few hours at 8.5c per hour per server and do some testing. It's the Master Master thing you want on the HA servers with the DBs.<br>
<br>MySQL slaves can only have 1 master.<br>
You can get around this by using mysql_multi on the same host to run several slaves (mysql servers on different PIDs & ports i.e. 3307,3308,3309 etc.)<br><br><br>Hope this helps you a little bit,<br>Chris<br><br><br>
<br><br><div class="gmail_quote"><div><div></div><div class="h5">On Tue, Nov 3, 2009 at 8:49 AM, Frederic Jean <span dir="ltr"><<a href="mailto:makafre@gmail.com" target="_blank">makafre@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
<br>Hello all, I just joined the mailing list.<br><br>I need to setup a HA * solution with 2 ultramonkey servers, 5 * servers and a realtime mysql data repository.<br>It's my first time at doing such a setup after several years playing with Asterisk, so this is what I figured out<br>
up to now;<br><br>- One master database is setup on its own server and all writing (inserts and updates) operations are done through it.<br>- Each Asterisk server would need a local slave mysql database for all read statements.<br>
- Database replication would occur for each * slave on a regular interval.<br>- Setup of a DUNDi lookup server (as in JR Richardson's "Using DUNDi with a cluster of Asterisk servers" paper).<br><br>I really want to make sure that there is no SPOF in the solution.<br>
<br>I am however not feeling confident about this database distribution, is that the way to go? How to add a hot/cold standby mysql server?<br>Does this solution make sense? any suggestions or tips before going further?<br>
<br>Best regards,<br>Fred<br><br>
<br></div></div>_______________________________________________<br>
--Bandwidth and Colocation Provided by <a href="http://www.api-digital.com--" target="_blank">http://www.api-digital.com--</a><br>
<br>
asterisk-ha-clustering mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering</a><br></blockquote></div><br><br clear="all"><br>-- <br>======================<br>
<br>Chris Mylonas<br><br>Web Systems Administrator<br>Omnium Research Group<br>College Of Fine Arts<br>University of NSW<br><a href="http://www.omnium.net.au" target="_blank">www.omnium.net.au</a><br><br>Communications, Internetworking, Software Design & Prototyping<br>
Consultant<br><a href="http://www.mrvoip.com.au" target="_blank">www.mrvoip.com.au</a><br><br>Open Source Software Projects<br>Founder<br><a href="http://www.opencsta.org" target="_blank">www.opencsta.org</a><br><a href="http://www.nursepaging.com" target="_blank">www.nursepaging.com</a><br>
<br>======================<br><br>
<br>_______________________________________________<br>
--Bandwidth and Colocation Provided by <a href="http://www.api-digital.com--" target="_blank">http://www.api-digital.com--</a><br>
<br>
asterisk-ha-clustering mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering</a><br></blockquote></div><br>