| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Real application clustering in postgres. |
| Date: | 2020-03-06 09:25:31 |
| Message-ID: | a3ba6d89-99cd-6344-28f3-427d60a738ef@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/5/20 6:07 AM, Laurenz Albe wrote:
> On Thu, 2020-03-05 at 07:45 +0000, Daulat Ram wrote:
>> Is there any possibility/options to setup a real application clustering in Postgres as in Oracle we have a RAC feature.
> No, and as far as I know nobody feels interested in providing it.
>
> RAC is a complicated architecture that doesn't do much good, so most
> people feel that it would be a waste of time and effort.
>
> RAC ist not really a scaling solution: because of the shared storage,
> you can only scale for more CPUs; I/O remains the bottleneck.
> RAC is not really a high availability solution: because of the shared
> storage, it has a sibgle point of failure.
This is utter nonsense. Dual redundant storage controllers connected to
disks in RAID-10 configurations have been around for *at least* 25 years.
Oracle got it's clustering technology from DEC, and I *know* that works.
Cluster members, storage controllers and disks have all gone down, while the
database and application keep on humming along.
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Schmid Andreas | 2020-03-06 11:04:50 | How to allow users to create and modify tables only in their own schemas, but with generic table owner |
| Previous Message | Laurenz Albe | 2020-03-06 08:59:33 | Re: Real application clustering in postgres. |