Обсуждение: Clustering of pgsql 9.2

<p dir="ltr">Let me begin by deferring to The Big Brains, but I am not sure there's enough in this to really advise you
fromThe Implementation Guys. That's me. I/O for any database is an issue, and when I hear any db talking to a SAN, I
geta bit leery. Couple that with replication, HA and failover?<p dir="ltr">If you could explain a bit more about what
you'retrying to accomplish, what expected performance should be, how that SAN is actually utilized, and such, I might
beable to provide some experience on the issue.<br /><div class="cm_quote" style=" color: #787878">On Wed, Jan 14, 2015
at11:27 PM, shyamkant.dhamke@wipro.com <<a
href="mailto:shyamkant.dhamke@wipro.com">shyamkant.dhamke@wipro.com</a>>wrote:</div><br /><div id="oldcontent"
style="background-color:rgb(255, 255, 255); background-position: initial initial; background-repeat: initial
initial;"><blockquotestyle=""><div class="WordSection1"><p class="MsoNormal">Dear All,<p class="MsoNormal"> <p
class="MsoNormal">Wehave following environment for  database clustering at production environment:<p
class="MsoListParagraph"style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">1.<span
style="font:7.0pt"Times New Roman"">       </span></span>Postgres is running on RedHat 6 enterprise edition for primary
andfailover server<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span
style="mso-list:Ignore">2.<spanstyle="font:7.0pt "Times New Roman"">       </span></span>SAN disk is available <p
class="MsoNormal"> <pclass="MsoNormal">Now I need help on following<p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l1level1 lfo2"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New
Roman"">      </span></span>What should be clustering software used for Redhat clustering ? Can <span
style="color:black">VeritasClustering Software (VCS) clustering be used for clustering REDHAT OS?</span><p
class="MsoListParagraph"style="text-indent:-.25in;mso-list:l1 level1 lfo2"><span style="mso-list:Ignore">2.<span
style="font:7.0pt"Times New Roman"">       </span></span><span style="color:black">How the SAN disk can be used to
storethe data centrally? Can this be used as QUORAM disk?</span><p class="MsoListParagraph"
style="text-indent:-.25in;mso-list:l1level1 lfo2"><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New
Roman"">      </span></span><span style="color:black">Is there any service for Postgres Database service
clustering?</span><pclass="MsoNormal"> <p class="MsoNormal">Please help me in providing details.<p
class="MsoNormal"> <pclass="MsoNormal">Regards<p class="MsoNormal">Shyamkant</div></blockquote></div> 

Hi,

On Thu, 2015-01-15 at 05:24 +0000, shyamkant.dhamke@wipro.com wrote:

> We have following environment for  database clustering at production environment:
>
> 1.       Postgres is running on RedHat 6 enterprise edition for primary and failover server
>
> 2.       SAN disk is available
>
> Now I need help on following
>
> 1.       What should be clustering software used for Redhat clustering ? Can Veritas Clustering Software (VCS)
clusteringbe used for clustering REDHAT OS? 
>
> 2.       How the SAN disk can be used to store the data centrally? Can this be used as QUORAM disk?
>
> 3.       Is there any service for Postgres Database service clustering?

http://www.gunduz.org/download.php?dlid=208

This presentation gives you an overview about how to setup Red Hat High
Availability Addon (formerly Red Hat Cluster Suite) with PostgreSQL,
which matches your needs.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

<p dir="ltr">Looks like a large size database. However, I would be concerned about the throughput on a SAN. Also, you
didn'tspecify the replication/failover stuff.<p dir="ltr">So...never replicate or fail over to the same hardware. I
disagreewith the concept of databases on SANs (and we can open THAT discussion in another thread). I will pretty well
tellyou that no one here has my IT/HA/OS experience. The Big Brains sure do know a whole lot more about PG, that's
certain.<pdir="ltr">However, you are talking HA and failover (those are separate) and replication  (also separate).<p
dir="ltr">Iwould love to advise you on this list where the Big Brains are watching.<p dir="ltr">So...<p
dir="ltr">What'syour primary server?<br /> Why does it need to replicate? <br /> Is PITR an option?<br /> Is PITR a
necessity?<br/> How many servers are involved?<br /> What's your bandwidth between master and slave(s)<br /> ?<br
/><divclass="cm_quote" style=" color: #787878">On Thu, Jan 15, 2015 at 12:54 AM, Devrim Gündüz <<a
href="mailto:devrim@gunduz.org">devrim@gunduz.org</a>>wrote:</div><br /><div id="oldcontent"
style="background-color:rgb(255, 255, 255); background-position: initial initial; background-repeat: initial
initial;"><blockquotestyle=""><p dir="ltr">Hi, <br /><br /> On Thu, 2015-01-15 at 05:24 +0000,
shyamkant.dhamke@wipro.comwrote: <br /><br /> > We have following environment for  database clustering at production
environment:<br /> > <br /> > 1.       Postgres is running on RedHat 6 enterprise edition for primary and
failoverserver <br /> > <br /> > 2.       SAN disk is available <br /> > <br /> > Now I need help on
following<br /> > <br /> > 1.       What should be clustering software used for Redhat clustering ? Can Veritas
ClusteringSoftware (VCS) clustering be used for clustering REDHAT OS? <br /> > <br /> > 2.       How the SAN disk
canbe used to store the data centrally? Can this be used as QUORAM disk? <br /> > <br /> > 3.       Is there any
servicefor Postgres Database service clustering? <br /><br /> http://www.gunduz.org/download.php?dlid=208 <br /><br />
Thispresentation gives you an overview about how to setup Red Hat High <br /> Availability Addon (formerly Red Hat
ClusterSuite) with PostgreSQL, <br /> which matches your needs. <br /><br /> Regards, <br /> -- <br /> Devrim GÜNDÜZ
<br/> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com <br /> PostgreSQL Danışmanı/Consultant,
RedHat Certified Engineer <br /> Twitter: @DevrimGunduz , @DevrimGunduzTR <br /><br /></blockquote></div>