> -------- Original Message -------- > Subject: Re: [Asterisk-Users] howto write CDRs on two mysql servers > From: Matthew Boehm <[EMAIL PROTECTED]> > Date: Thu, June 09, 2005 1:47 pm > To: Mark Musone <[EMAIL PROTECTED]>, Asterisk Users Mailing List - > Non-Commercial Discussion <asterisk-users@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. _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users