External IP in Azure when clustered

[Alocaurd]

I made a cluster in Azure with 4 nodes using the latest logical master-master replication successfully.

However, in Azure, i need to set the external RTP and SIP IP address in the variables, but it looks like that information is replicated, so one IP is applied to all servers. Is there another way around this?

 

[Neyamt]

You need to exclude v_sip_profile_settings table to not be sync in the cluster. I have done this solution using asynchronization clustering methods between two server as active/active (Not membership solution of the FusionPBX). because it will not be unavailable after discontinuing subscription of the membership.

 

[ardyhash]

@Alocaurd, any chance you're open to sharing notes/documentation about how you went about setting up a cluster?
@Neyamt sounds like you've got some real world experience with clustering, any and all resources you can point me to regarding a highly available or load balanaced FusionPBX cluster would be greatly appreciated.

 

[DigitalDaz]

You do not need to exclude tables from the replication, see the following post, you can include local files that are local to the server to set the local ips:

Fusion on Google Cloud Compute or AWS

Instead of using redundant servers and all that entails, has anyone tried running using NFS using something like Google Cloud Compute? I am wondering how well the DB works on a busy server since NFS is inherently slower than local hard drives. It seems to me that would be a good way to do...

www.pbxforums.com

 

[Alocaurd]

Thanks @DigitalDaz

I was actually able to get this done via the hostname field in the vars table.

 

[Alocaurd]

@ardyhash My cluster is setup using PGLogical for the database replication. I am only replicating FusionPBX, not freeswitch, so this cluster is not load balancing or anything like that, just a few machines in Azure with the traffic manager routing registrations to whatever server is up for that domain. Lots of information out there on Logical master/master replication, or sign up as a member with Fusionpbx and Mark's advanced class goes through the whole process for you to follow!