<font face="verdana,sans-serif">Core Dev'e preferred database is </font><span style="font-family:verdana,sans-serif">PostgreSQL</span><font face="verdana,sans-serif">. I will choose PostgreSQL.</font><div><font face="verdana, sans-serif"><br>
</font></div><div><font face="verdana, sans-serif">There are so many issues with depends on one data centers. The more critical now a days is weather cause lots of issues.</font></div><div><font face="verdana, sans-serif"><br>
</font></div><div><font face="verdana, sans-serif">I want to distribute freeswitch, minimum two data centers and two different regions. </font></div><div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">Does anyone have a </font><span style="font-family:verdana,sans-serif">PostgreSQL </span><font face="verdana, sans-serif">master-master replication working reliably? Anything I need to consider using </font><span style="font-family:verdana,sans-serif">PostgreSQL </span><font face="verdana, sans-serif">master-master.</font></div>
<div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">Thank you in advanced.</font></div><div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">Lloyd<br>
</font><div><br></div><div><div>
<div><font face="verdana, sans-serif" color="#cc6600" size="1"><b><br></b></font></div><div><font face="verdana, sans-serif" color="#cc6600" size="1"><b> <a href="http://www.sunteltech.ca/blog/" target="_blank"></a></b></font></div>
</div>
<br><br><div class="gmail_quote">On Fri, Aug 2, 2013 at 8:12 AM, Patrick Lists <span dir="ltr"><<a href="mailto:freeswitch-list@puzzled.xs4all.nl" target="_blank">freeswitch-list@puzzled.xs4all.nl</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On 08/02/2013 05:12 AM, Nathan Neulinger wrote:<br>
> I've had good luck with a small deployment on percona as well, though there are a few minor issues (maybe stuff that can<br>
> be corrected):<br>
><br>
> 1. When FS tries to create indexes on various tables that already exist, it winds up causing a bunch of<br>
> complaints/failures in the percona logs and creating various GAL_ dump files.<br>
><br>
> 2. The external management of percona can be a mess. I tried running with Pacemaker/Corosync and really didn't have good<br>
> luck with it failing over the floating IP properly, so I switched things back over to Keepalived, which I'm using for<br>
> the freeswitch instances.<br>
<br>
</div>For the floating IP to follow to the new box, on a *2* node setup, you<br>
need to disable quorum and add a constraint in your pacemaker/corosync<br>
config so the resource (PerconaDB) follows the floating IP. Something like:<br>
<br>
$ pcs property set no-quorum-policy=ignore<br>
$ pcs constraint colocation add PerconaDB ClusterIP INFINITY<br>
$ pcs constraint order ClusterIP then PerconaDB<br>
<br>
And this example helps to prevent resources to move around when the<br>
failed node comes back online. Make sure the 'resource-stickiness' value<br>
is higher than the 'prefers' one:<br>
<br>
$ pcs constraint location PerconaDB prefers node-1=50<br>
$ pcs resource rsc defaults resource-stickiness=100<br>
<br>
I'm curious, did you use a shared filesystem (something like DRBD with<br>
GFS2/OCFS2) and regular Percona XtraDB on both nodes or did you use<br>
Percona XtraDB Cluster?<br>
<br>
Regards,<br>
Patrick<br>
<div><div><br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div>
</div>