[asterisk-users] Realtime +Mysql +Failover

[Dovid B]

You can have a MySQL Cluster.

----- Original Message ----- 
From: "David Thomas" <punknow at gmail.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion" 
<asterisk-users at lists.digium.com>
Sent: Wednesday, December 13, 2006 8:36 PM
Subject: Re: [asterisk-users] Realtime +Mysql +Failover


> On 12/13/06, Rob Schall <rschall at callone.net> wrote:
>> Hoping someone out there has run into this or has some ideas for us.
>>
>> We currently have asterisk set up with Realtime (using mysql) for its
>> extensions,sip and voicemail files.
>>
>> The problem we are trying to solve, is one of a failover mechanism. What
>> if our mysql server went down.
>>
>> Can Realtime be set up with a secondary mysql server to get its data
>> from. We can set up mysql to sync with its fellow server, and maybe when
>> it goes down, it couldn't make any changes (write), but either way, you
>> could still get the extension info, etc, so your phones would still
>> survive a mysql outage.
>>
>> Any ideas?
>> Thanks,
>> Rob
>
> I don't think Realtime can be setup with a secondary server (someone
> please correct me if I'm wrong).
>
> Two possibilities come to mind...
>
> 1. You can run MySQL in an HA arangement with on box as the hot standby.
> 2. If you can allow for ocassional asterisk reloads, you could use
> Realtime Static
>
> Regards,
> David
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>