Multiple Server Installation/Design Question.

From: Ozz Nixon <ozznixon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple Server Installation/Design Question.
Date: 2010-02-15 16:01:51
Message-ID: 9C81F0B6-DE77-44C5-B414-CDF8EE19CAC4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have been experimenting with the product, nicely done! I would like
to implement it in a live scenario now, however, I have questions.

I have 2 Data Centers, 1 with 2 ISPs and 1 with 1 ISP. I would like to
setup the product to replicate from 1 center to another - as close to
real-time as possible. I am sure I can find the steps to do this,
however, any information would be nice.

The question is, the Data Center with 2 ISPs, has a common Drive Array
[NFS based] and I would like to install the "engine" on each Blade
Server, however, have the same database files used by the engines. Is
this possible?

Details of Data Center #1:
ISP #1 - Windows Server, 1TB Drive - All Internal.

Details of Data Center #2:
ISP #2 - Windows Server, 4TB Drive Array - NFS Mount
ISP #3 - Linux Server, same 4TB Drive Array - NFS Mount

-- If Windows is an issue, I can easily put these on Linux (running
CentOS 5).

* My first task will be to implement a few tables with minimal
changes occurring, replicating between the two Centers, but again DC2
has 2 Internet Feeds. -- Think of the environment as a Wiki. Mostly
searches, with few changes or add.

* The next project after this one will be a Message Forum solution -
so it will have more writes then the Wiki solution - but still be a
search/view environment.

Unfortunately, I need to have a solution in testing this week - due
to the heavy snow storms up north, today is the first day I have had
access to the Internet to start asking question.

Thanks,
Ozz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Krol 2010-02-15 16:04:14 Re: vacuum analyze GROWS db ?!
Previous Message Tom Lane 2010-02-15 15:50:45 Re: vacuum analyze GROWS db ?!