[asterisk-ha-clustering] New HA setup

[Frederic Jean]

Hi Chris, thanks for the great tip.

This means each Asterisk could be updated based on the 2 master databases.

So to resume it all:

- One master database is setup on its own server and all writing (inserts
and updates) operations are done through it.
- Second master database is replicated as in Chris comment (Master Master).
Web data could be fetched from this server as well.
- Each Asterisk server would need a local slave mysql database for all read
statements.
- Each Asterisk local slave database updates itself on a regular interval
from the Masters using mysql_multi
- Setup of a DUNDi lookup server (as in JR Richardson's "Using DUNDi with a
cluster of Asterisk servers" paper).

Is this something "standard" in a HA Asterisk solution? Has anybody tried
something similar?
Any comments are appreciated!

Fred


On Mon, Nov 2, 2009 at 7:14 PM, Chris Mylonas <chris at mrvoip.com.au> wrote:

> Hi Fred,
>
>
> 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.
>
> MySQL slaves can only have 1 master.
> 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.)
>
>
> Hope this helps you a little bit,
> Chris
>
>
>
>
> On Tue, Nov 3, 2009 at 8:49 AM, Frederic Jean <makafre at gmail.com> wrote:
>
>>
>> Hello all, I just joined the mailing list.
>>
>> I need to setup a HA * solution with 2 ultramonkey servers, 5 * servers
>> and a realtime mysql data repository.
>> It's my first time at doing such a setup after several years playing with
>> Asterisk, so this is what I figured out
>> up to now;
>>
>> - One master database is setup on its own server and all writing (inserts
>> and updates) operations are done through it.
>> - Each Asterisk server would need a local slave mysql database for all
>> read statements.
>> - Database replication would occur for each * slave on a regular interval.
>> - Setup of a DUNDi lookup server (as in JR Richardson's "Using DUNDi with
>> a cluster of Asterisk servers" paper).
>>
>> I really want to make sure that there is no SPOF in the solution.
>>
>> 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?
>> Does this solution make sense? any suggestions or tips before going
>> further?
>>
>> Best regards,
>> Fred
>>
>>
>> _______________________________________________
>> --Bandwidth and Colocation Provided by http://www.api-digital.com--
>>
>> asterisk-ha-clustering mailing list
>> To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering
>>
>
>
>
> --
> ======================
>
> Chris Mylonas
>
> Web Systems Administrator
> Omnium Research Group
> College Of Fine Arts
> University of NSW
> www.omnium.net.au
>
> Communications, Internetworking, Software Design & Prototyping
> Consultant
> www.mrvoip.com.au
>
> Open Source Software Projects
> Founder
> www.opencsta.org
> www.nursepaging.com
>
> ======================
>
>
> _______________________________________________
> --Bandwidth and Colocation Provided by http://www.api-digital.com--
>
> asterisk-ha-clustering mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-ha-clustering/attachments/20091102/30c2bcce/attachment.htm