<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: external database jdbc url when using a postgres master-slave cluster in Workspace ONE Discussions</title>
    <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324454#M4583</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;*bump* Can anyone help with this? Or should i be asking in the vFabric forums?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 12 Aug 2013 12:25:34 GMT</pubDate>
    <dc:creator>MMAgeek</dc:creator>
    <dc:date>2013-08-12T12:25:34Z</dc:date>
    <item>
      <title>external database jdbc url when using a postgres master-slave cluster</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324453#M4582</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have read the document here &lt;A href="http://blogs.vmware.com/vfabric/2013/03/scaling-for-the-information-explosion-master-slave-cluster-with-vfabric-postgres-9-2-on-vsphere.html" title="http://blogs.vmware.com/vfabric/2013/03/scaling-for-the-information-explosion-master-slave-cluster-with-vfabric-postgres-9-2-on-vsphere.html"&gt;Scaling for the Information Explosion: Master-Slave Cluster with vFabric Postgres 9.2 on vSphere | VMware vFabric Blog -… &lt;/A&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;and the document that details how to setup workspace to use an external postgres DB but it is missing some config info when using a master-slave cluster&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;When i have set up the cluster should the jdbc url point to the master host? If the cluster fails over how does Workspace know to point at the secondary host? It doesnt appear that there is a dedicated cluster IP/hostname i can point to?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Or do i need to create a DNS CNAME that points to the master and change that manually in a failover event?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 13 Jul 2013 16:25:10 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324453#M4582</guid>
      <dc:creator>MMAgeek</dc:creator>
      <dc:date>2013-07-13T16:25:10Z</dc:date>
    </item>
    <item>
      <title>Re: external database jdbc url when using a postgres master-slave cluster</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324454#M4583</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;*bump* Can anyone help with this? Or should i be asking in the vFabric forums?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 12 Aug 2013 12:25:34 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324454#M4583</guid>
      <dc:creator>MMAgeek</dc:creator>
      <dc:date>2013-08-12T12:25:34Z</dc:date>
    </item>
    <item>
      <title>Re: external database jdbc url when using a postgres master-slave cluster</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324455#M4584</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I asked this question on the vfabric forums and received this answer from one of the postgres devs &lt;A _jive_internal="true" href="https://communities.vmware.com/thread/455006"&gt;https://communities.vmware.com/thread/455006&lt;/A&gt; &lt;/P&gt;&lt;P&gt;I thought i would repost it here in case anyone else finds it useful. I must admit I am finding the lack of documentation around some some horizon features slightly annoying. I will try this on our lab environment and see what happens.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;---------&lt;/P&gt;&lt;P style="margin: 2px; font-size: 12px; font-family: Arial, Helvetica, sans-serif; color: #333333;"&gt;Since 9.2.4, vPostgres appliance includes some scripts dedicated to this task, making your life far easier. So you don't need to do all those steps manually on the server side. More information here:&lt;/P&gt;&lt;P style="margin: 2px; font-size: 12px; font-family: Arial, Helvetica, sans-serif; color: #333333;"&gt;&lt;A class="jive-link-external-small" href="http://blogs.vmware.com/dataplatforms/2013/07/new-replication-features-of-vfabric-postgres-9-2-4.html" style="font-style: inherit; font-family: inherit; color: #3399cc;"&gt;New replication features of vFabric Postgres 9.2.4 | Next-Generation Data Platforms Blog - VMware Blogs&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin: 2px; font-size: 12px; font-family: Arial, Helvetica, sans-serif; color: #333333;"&gt;Then for managing a switchover to a slave in case of a master failure, JDBC has some basic implementation in its code that has been introduced one year ago with commit 39b085d and you can specify multiple URLs like that:&lt;/P&gt;&lt;P style="margin: 2px; font-size: 12px; font-family: Arial, Helvetica, sans-serif; color: #333333;"&gt;jdbc:postgresql://host1:port1,host2:port2/test&lt;/P&gt;&lt;P style="margin: 2px; font-size: 12px; font-family: Arial, Helvetica, sans-serif; color: #333333;"&gt;Connection is chosen in round-robin fashion until success. There is no documentation about that though... I'll ping the jdbc devs to correct that. If you are using an older version of JDBC, you should switch to another solution, like a tomcat layer.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 21 Aug 2013 08:29:58 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324455#M4584</guid>
      <dc:creator>MMAgeek</dc:creator>
      <dc:date>2013-08-21T08:29:58Z</dc:date>
    </item>
    <item>
      <title>Re: external database jdbc url when using a postgres master-slave cluster</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324456#M4585</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Appears that this doesnt work with Workspace, I am unable to specify multiple servers in the JDBC URL field. Looks like I'll be logging a call with VMware Support&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 10 Oct 2013 09:04:05 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/external-database-jdbc-url-when-using-a-postgres-master-slave/m-p/1324456#M4585</guid>
      <dc:creator>MMAgeek</dc:creator>
      <dc:date>2013-10-10T09:04:05Z</dc:date>
    </item>
  </channel>
</rss>

