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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org