[asterisk-users] Realtime replication!!!!!

[Tilghman Lesher]

On Tuesday 25 March 2008 20:43:49 Edgar Guadamuz wrote:
> 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.

Actually, MySQL supports dual-master replication, so both machines may be
both the master, slaving queries from the other, which keeps them both
balanced, and it won't matter which one goes down.  For more on that, I invite
you to read MySQL documentation, as this really isn't on-topic for this list.

-- 
Tilghman