Slow down tiger,<br><br>Take my advice with a grain of salt as I'm not a database guru.<br><br>Test your DB replication with the different setups to see what fits best for your needs.<br><br>Some of them are simply mysql<--->mysql master/slave replication (like most tutorials on the internet), some are block level replication e.g. <a href="http://docs.sun.com/source/mysql-refman-5.1/ha-overview.html">http://docs.sun.com/source/mysql-refman-5.1/ha-overview.html</a><br>
<br>Master Master with heartbeat means there will be 1 ip address shared between the two. If the primary master fails, heartbeat takes over after 10 seconds or whatever you configure it. Asterisk will still be looking up on 'that-one-ip-address' and heartbeat will make sure there's a master database for you to look up. In this case it's the secondary master that has kicked in with it's new IP address that asterisk expects to find.<br>
<br>Take an sqldump every hour from the slave, it can always catch up to the master after the dump. Best not to use the master - because of table locking you'll end up with problems/complaints if someone is trying to update, althouth that would depend on the size of your dataset. We have binary blogs in our databases for web content that the application uses, so doing a mysqldump on the master is literally suicide-*chink*-*chink*-your-wrists.<br>
<br>Your best to ask a real database expert though, as my experience is limited.<br><br>I do however recommend you test on amazon and break as much stuff as you can because it's a very useful resource - being able to run up a server in a couple of minutes.<br>
<br><br>Cheers<br>Chris<br><br><br><br><div class="gmail_quote">On Tue, Nov 3, 2009 at 12:35 PM, Frederic Jean <span dir="ltr"><<a href="mailto:makafre@gmail.com">makafre@gmail.com</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 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:<div class="im"><br><br>- One master database is setup on its own server and all writing (inserts and updates) operations are done through it.<br>
</div>
- Second master database is replicated as in Chris comment (Master Master). Web data could be fetched from this server as well.<div class="im"><br>- Each Asterisk server would need a local slave mysql database for all read statements.<br>
</div>
- Each Asterisk local slave database updates itself on a regular interval from the Masters using mysql_multi<div class="im"><br>- Setup of a DUNDi lookup server (as in JR Richardson's "Using DUNDi with a cluster of Asterisk servers" paper).<br>
<br></div>Is this something "standard" in a HA Asterisk solution? Has anybody tried something similar?<br>Any comments are appreciated!<br><br>Fred<div><div></div><div class="h5"><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" target="_blank">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>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>
<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>
</div></div><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><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">www.omnium.net.au</a><br><br>Communications, Internetworking, Software Design & Prototyping<br>
Consultant<br><a href="http://www.mrvoip.com.au">www.mrvoip.com.au</a><br><br>Open Source Software Projects<br>Founder<br><a href="http://www.opencsta.org">www.opencsta.org</a><br><a href="http://www.nursepaging.com">www.nursepaging.com</a><br>
<br>======================<br><br>