asterisk users - Mar 2008 - Realtime replication!!!!!

Hi list
 what do you think is the best way to replicate an asterisk  mysql realtime
database  ,
i'm setting up  a cluster , and i obviously need to ensure the database high
availability
i've been reading about DRBD and the internal replication functionality of
mysql , but i dont really know if its the proper solution, i'm looking for
advices on how to replicate the mysql realtime database
so then when the main server is down , the second replace it .

any help would be gr8

Best regards

-- 
Cheikhou DIAW
+225 02175082
+225 22414039
msn: deuteryon at hotmail.com
e-mail:deuteryon at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080326/4aa39840/attachment.htm

I am trying DB replication with MySQL. I have two nodes, and Linux-HA
running on both of them. The first idea is simply have the master
database in one server, where both nodes send the SQL queries and in
the other node a second DB replicated from the first one. In the case
of the master database fails, Linux-HA should promote the second
database to the master state.

On Tue, Mar 25, 2008 at 6:33 PM, Cheikhou DIAW <deuteryon at gmail.com>
wrote:
>
> Hi list
>  what do you think is the best way to replicate an asterisk  mysql realtime
> database  ,
> i'm setting up  a cluster , and i obviously need to ensure the database
high
> availability
> i've been reading about DRBD and the internal replication functionality
of
> mysql , but i dont really know if its the proper solution, i'm looking
for
> advices on how to replicate the mysql realtime database
> so then when the main server is down , the second replace it .
>
> any help would be gr8
>
> Best regards
>
> --
> Cheikhou DIAW
> +225 02175082
> +225 22414039
> msn: deuteryon at hotmail.com
> e-mail:deuteryon at gmail.com
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>

>  what do you think is the best way to replicate an asterisk  mysql realtime
> database  ,
> i'm setting up  a cluster , and i obviously need to ensure the database
high
> availability
> i've been reading about DRBD and the internal replication functionality
of
> mysql , but i dont really know if its the proper solution, i'm looking
for
> advices on how to replicate the mysql realtime database
> so then when the main server is down , the second replace it .
I won't call it "best way" but I am using two-way master-slave
repliaction of
MySQL.

                            __Yehavi: