pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedClustering of pgsql 9.2
5+ messages / 3 participants
[nested] [flat]
* Clustering of pgsql 9.2
@ 2015-01-15 05:24 shyamkant.dhamke@wipro.com
2015-01-15 06:52 ` Re: Clustering of pgsql 9.2 Devrim Gündüz <devrim@gunduz.org>
2015-01-15 07:39 ` Re: Clustering of pgsql 9.2 Scott Whitney <scott@journyx.com>
0 siblings, 2 replies; 5+ messages in thread
From: shyamkant.dhamke@wipro.com @ 2015-01-15 05:24 UTC (permalink / raw)
To: pgsql-admin
Dear All,
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) clustering be 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?
Please help me in providing details.
Regards
Shyamkant
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Clustering of pgsql 9.2
2015-01-15 05:24 Clustering of pgsql 9.2 shyamkant.dhamke@wipro.com
@ 2015-01-15 06:52 ` Devrim Gündüz <devrim@gunduz.org>
1 sibling, 0 replies; 5+ messages in thread
From: Devrim Gündüz @ 2015-01-15 06:52 UTC (permalink / raw)
To: shyamkant.dhamke@wipro.com; +Cc: pgsql-admin
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) clustering be 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
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Clustering of pgsql 9.2
2015-01-15 05:24 Clustering of pgsql 9.2 shyamkant.dhamke@wipro.com
@ 2015-01-15 07:39 ` Scott Whitney <scott@journyx.com>
2015-01-15 07:52 ` Re: Clustering of pgsql 9.2 shyamkant.dhamke@wipro.com
1 sibling, 1 reply; 5+ messages in thread
From: Scott Whitney @ 2015-01-15 07:39 UTC (permalink / raw)
To: Devrim Gündüz <devrim@gunduz.org>; +Cc: shyamkant.dhamke@wipro.com; pgsql-admin
<p dir="ltr">Looks like a large size database. However, I would be concerned about the throughput on a SAN. Also, you didn't specify the replication/failover stuff.</p>
<p dir="ltr">So...never replicate or fail over to the same hardware. I disagree with the concept of databases on SANs (and we can open THAT discussion in another thread). I will pretty well tell you 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.</p>
<p dir="ltr">However, you are talking HA and failover (those are separate) and replication (also separate).</p>
<p dir="ltr">I would love to advise you on this list where the Big Brains are watching.</p>
<p dir="ltr">So...</p>
<p dir="ltr">What's your 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>
?</p>
<br/><div class="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;"><blockquote style=""><p dir="ltr">Hi,
<br>
<br>
On Thu, 2015-01-15 at 05:24 +0000, shyamkant.dhamke@wipro.com wrote:
<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 failover server
<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 Clustering Software (VCS) clustering be used for clustering REDHAT OS?
<br>
>
<br>
> 2. How the SAN disk can be used to store the data centrally? Can this be used as QUORAM disk?
<br>
>
<br>
> 3. Is there any service for Postgres Database service clustering?
<br>
<br>
http://www.gunduz.org/download.php?dlid=208
<br>
<br>
This presentation gives you an overview about how to setup Red Hat High
<br>
Availability Addon (formerly Red Hat Cluster Suite) 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, Red Hat Certified Engineer
<br>
Twitter: @DevrimGunduz , @DevrimGunduzTR
<br>
<br>
</p>
</blockquote></div>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Clustering of pgsql 9.2
2015-01-15 05:24 Clustering of pgsql 9.2 shyamkant.dhamke@wipro.com
2015-01-15 07:39 ` Re: Clustering of pgsql 9.2 Scott Whitney <scott@journyx.com>
@ 2015-01-15 07:52 ` shyamkant.dhamke@wipro.com
0 siblings, 0 replies; 5+ messages in thread
From: shyamkant.dhamke@wipro.com @ 2015-01-15 07:52 UTC (permalink / raw)
To: scott@journyx.com; devrim@gunduz.org; +Cc: pgsql-admin
Thanks Scott again. Please find my comments below. As I am not big brain like you all experts . Also let me know how to compute IOPs for this ?
From: Scott Whitney [mailto:scott@journyx.com]
Sent: Thursday, January 15, 2015 1:09 PM
To: Devrim Gündüz
Cc: Shyamkant Dhamke (WT01 - BAS); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Clustering of pgsql 9.2
Looks like a large size database. However, I would be concerned about the throughput on a SAN. Also, you didn't specify the replication/failover stuff.
Shyamkant = This will be the failover scenario.
So...never replicate or fail over to the same hardware. I disagree with the concept of databases on SANs (and we can open THAT discussion in another thread). I will pretty well tell you 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.
However, you are talking HA and failover (those are separate) and replication (also separate).
I would love to advise you on this list where the Big Brains are watching.
So...
What's your primary server?
Primary & Secondary servers the RedHAT Enterprise 6.0 with Postgres SQL 9.3
Why does it need to replicate?
There is no replication required. We want to achieve HA by storing the data on central server & clustering primary & secondary servers
Is PITR an option?
I do not know about PITR
Is PITR a necessity?
I do not know about PITR
How many servers are involved?
Only 02 servers (Primary & secondary)
What's your bandwidth between master and slave(s)?
1 G
On Thu, Jan 15, 2015 at 12:54 AM, Devrim Gündüz <devrim@gunduz.org<mailto:devrim@gunduz.org>> wrote:
Hi,
On Thu, 2015-01-15 at 05:24 +0000, shyamkant.dhamke@wipro.com<mailto: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) clustering be 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Clustering of pgsql 9.2
@ 2015-01-15 05:56 Scott Whitney <scott@journyx.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Whitney @ 2015-01-15 05:56 UTC (permalink / raw)
To: shyamkant.dhamke@wipro.com; +Cc: pgsql-admin
<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 from The Implementation Guys. That's me. I/O for any database is an issue, and when I hear any db talking to a SAN, I get a bit leery. Couple that with replication, HA and failover?</p>
<p dir="ltr">If you could explain a bit more about what you're trying to accomplish, what expected performance should be, how that SAN is actually utilized, and such, I might be able to provide some experience on the issue.</p>
<br/><div class="cm_quote" style=" color: #787878">On Wed, Jan 14, 2015 at 11: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;"><blockquote style="">
<div class="WordSection1">
<p class="MsoNormal">Dear All,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">We have following environment for database clustering at production environment:</p>
<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 and failover server</p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman"">
</span></span>SAN disk is available </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Now I need help on following</p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l1 level1 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">Veritas Clustering Software (VCS) clustering be used for clustering REDHAT OS?</span></p>
<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 store the data centrally? Can this be used as QUORAM disk?</span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l1 level1 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></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Please help me in providing details.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Regards</p>
<p class="MsoNormal">Shyamkant</p>
</div>
</blockquote></div>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2015-01-15 07:52 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-01-15 05:24 Clustering of pgsql 9.2 shyamkant.dhamke@wipro.com
2015-01-15 06:52 ` Devrim Gündüz <devrim@gunduz.org>
2015-01-15 07:39 ` Scott Whitney <scott@journyx.com>
2015-01-15 07:52 ` shyamkant.dhamke@wipro.com
2015-01-15 05:56 Re: Clustering of pgsql 9.2 Scott Whitney <scott@journyx.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox