[Spce-user] Clustering

[Gavin Sweet]

Hi folks - 

 

A few further thoughts on this. 

 

We were looking at ngcp database, presumably this should not be replicated -
where it will be a master-master db config?

 

Following on from the original question below, has anyone had any experience
of the effectiveness of mysql replication in this scenario? There are
auto_increment parameters in the mysql replication configs that are supposed
to ensure no clashes of keys (e.g. CDR id I guess) - has anyone played with
this?

 

Thanks

Gavin

 

 

From: Skyler [mailto:skchopperguy at gmail.com] 
Sent: 14 December 2012 17:10
To: gavin.sweet at skyracktelecom.com
Cc: Andreas Granig; spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Clustering

 

Hi,

On Mon, Dec 3, 2012 at 10:22 AM, Gavin Sweet
<gavin.sweet at skyracktelecom.com> wrote:

Hi Andreas

Are there any databases or db tables that shouldn't be replicated in either
a master-master (cluster) or master-slave setup?

 

 If your servers are in different timezones, you will not want to replicate
the locations table.

 

I was wondering about the accounting data and what mechanisms there are for
guaranteeing you only use one set of CDR's ... I guess that with rate-o-mat
running on both your cluster nodes, you should be generating identical CDR
files on each node? So you just decide which node you're going to process
from and just pull one set of CDR's (as the accounting data would have
replicated over from the other node even if that handled a specific call
session)?

 

 Correct.

 


Thanks
Gavin 

 

Skyler

 

  _____  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1430 / Virus Database: 2634/5458 - Release Date: 12/14/12

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20130122/8f1cc37b/attachment.html>