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
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 ?! |