Re: Real application clustering in postgres.

Ron <ronljohnsonjr@xxxxxxxxx> · Fri, 6 Mar 2020 03:25:31 -0600

    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.