On 2020-03-09 09:57:37 +0100, Laurenz Albe wrote:
> On Sun, 2020-03-08 at 21:13 +0100, Peter J. Holzer wrote:
> > But to be fair, a master/slave setup a la patroni isn't immune against
> > "writing junk" either: Not on the hardware level (either of the nodes
> > may have faulty hardware, and you
Am 05.03.20 um 13:07 schrieb Laurenz Albe:
There is a closed-source implementation that you can buy:
https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/
But multi-master replication is complicated to get right, and
an applicatoin that uses it has to be specifically designed
On Sun, 2020-03-08 at 21:13 +0100, Peter J. Holzer wrote:
> But to be fair, a master/slave setup a la patroni isn't immune against
> "writing junk" either: Not on the hardware level (either of the nodes
> may have faulty hardware, and you may not notice it until too late), and
> more importantly,
On Fri, 2020-03-06 at 10:56 -0600, Ron wrote:
> > > > 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
## Andrew Kerber (andrew.ker...@gmail.com):
> The nice point of oracle
> dataguard is that it is a block by block copy, while all of the Postgres
> Multi-Master and master-slave replication solutions work by SQL capture.
https://www.postgresql.org/docs/12/warm-standby.html#STREAMING-REPLICATION
On 2020-03-06 15:55:27 +0100, Laurenz Albe wrote:
> On Fri, 2020-03-06 at 03:25 -0600, Ron wrote:
> > > 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
> >
On 3/6/20 01:25, Ron wrote:
> On 3/5/20 6:07 AM, Laurenz Albe wrote:
>> On Thu, 2020-03-05 at 07:45 +, 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,
Yup, if you need true shared storage, Oracle RAC is still the only solution
out there, All the other multi-master solutions work by capturing the sql
statements themselves. And properly configured it RAC is indeed part of an
HA solution. Any time you have everything in a single data center, as
On 3/6/20 8:55 AM, Laurenz Albe wrote:
On Fri, 2020-03-06 at 03:25 -0600, Ron wrote:
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
>
> If you have mirrored disks, and you write junk (e.g, because of
> a flaw in a fibre channel cable, something I have witnessed),
> then you have two perfectly fine copies of the junk.
>
Few years ago didn't this happen to Salesforce where a firmware bug corrupted
the Disk, resulting in
On Fri, 2020-03-06 at 03:25 -0600, Ron wrote:
> > 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
On 3/5/20 6:07 AM, Laurenz Albe wrote:
On Thu, 2020-03-05 at 07:45 +, 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
On Thu, 2020-03-05 at 17:06 +, Virendra Kumar wrote:
> Failover is easy but failback is little bit tricky.
> I have implemented failback by doing following steps:
>
> 1. Start original primary which will be doing crash recovery. It should be
> designed in such a way that once it is up
, March 5, 2020 5:37 PM
To: Daulat Ram ; pgsql-general@lists.postgresql.org
Subject: Re: Real application clustering in postgres.
On Thu, 2020-03-05 at 07:45 +, Daulat Ram wrote:
> Is there any possibility/options to setup a real application clustering in
> Postgres as in Oracle we have
switchover method for Dataguard. How we can do in Postgres.
Thanks,
-Original Message-
From: Laurenz Albe
Sent: Thursday, March 5, 2020 5:37 PM
To: Daulat Ram ; pgsql-general@lists.postgresql.org
Subject: Re: Real application clustering in postgres.
On Thu, 2020-03-05 at 07:45 +
On Thu, 2020-03-05 at 07:45 +, 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 does
16 matches
Mail list logo
