[Asterisk-Users] howto write CDRs on two mysql servers

[Max W Blackmer Jr]

> -------- Original Message --------
> Subject: Re: [Asterisk-Users] howto write CDRs on two mysql servers
> From: Matthew Boehm <mboehm at cytelcom.com>
> Date: Thu, June 09, 2005 1:47 pm
> To: Mark Musone <mmusone at gmail.com>, Asterisk Users Mailing List -
> Non-Commercial Discussion <asterisk-users at lists.digium.com>
>
> Mark Musone wrote:
> > why not just use mysql replication to the second one?
>
>   Replication does not solve the issue of "redundancy". If the master
> goes down, so do the updates to the slave.
>
> -Matthew
>

Replication can be set up to go bothways in a 2 server scenario for
MySQL. This would solve your replication issue for 2 servers. More
servers can be set up in a loop configuration for 3 or more servers.
There is one problem with this method if one MySQL goes down updates
are not passed around the loop. but as soon as the loop is
reestablished the updates are passed around the loop to bring the other
servers up to date.

You might also consider DNS round robin to distribute initial
connections to MySQL.  A better solution is to use a load balancer that
tracks to see if the servers are alive and balance against the load on
each server.

Cheers

Max W. Blackmer, Jr.