[Freeswitch-users] FreeSWITCH Core - Cassandra Database

[Lloyd Aloysius]

Core Dev'e preferred database is PostgreSQL. I will choose PostgreSQL.

There are so many issues with depends on one data centers. The
more critical now a days is weather cause lots of issues.

I want to distribute freeswitch, minimum two data centers and two different
regions.

Does anyone have a PostgreSQL master-master replication working reliably?
Anything I need to consider using PostgreSQL master-master.

Thank you in advanced.

Lloyd

*
*
*  <http://www.sunteltech.ca/blog/>*


On Fri, Aug 2, 2013 at 8:12 AM, Patrick Lists <
freeswitch-list at puzzled.xs4all.nl> wrote:

> On 08/02/2013 05:12 AM, Nathan Neulinger wrote:
> > I've had good luck with a small deployment on percona as well, though
> there are a few minor issues (maybe stuff that can
> > be corrected):
> >
> > 1. When FS tries to create indexes on various tables that already exist,
> it winds up causing a bunch of
> > complaints/failures in the percona logs and creating various GAL_ dump
> files.
> >
> > 2. The external management of percona can be a mess. I tried running
> with Pacemaker/Corosync and really didn't have good
> > luck with it failing over the floating IP properly, so I switched things
> back over to Keepalived, which I'm using for
> > the freeswitch instances.
>
> For the floating IP to follow to the new box, on a *2* node setup, you
> need to disable quorum and add a constraint in your pacemaker/corosync
> config so the resource (PerconaDB) follows the floating IP. Something like:
>
> $ pcs property set no-quorum-policy=ignore
> $ pcs constraint colocation add PerconaDB ClusterIP INFINITY
> $ pcs constraint order ClusterIP then PerconaDB
>
> And this example helps to prevent resources to move around when the
> failed node comes back online. Make sure the 'resource-stickiness' value
> is higher than the 'prefers' one:
>
> $ pcs constraint location PerconaDB prefers node-1=50
> $ pcs resource rsc defaults resource-stickiness=100
>
> I'm curious, did you use a shared filesystem (something like DRBD with
> GFS2/OCFS2) and regular Percona XtraDB on both nodes or did you use
> Percona XtraDB Cluster?
>
> Regards,
> Patrick
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130802/c280f21c/attachment.html