public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jacob Biesinger <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: serializable master and non-serializable hot standby: feasible set up?
Date: Wed, 16 Oct 2024 12:28:04 -0700
Message-ID: <CAHYXj6f0X4CU+xzTZRHmA_0b+99CnLUHu8fabbPVW4XL1qw0yQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAHYXj6eE0jMyeM-c-szjzDLVB6WSD=bYH3KiCgZ2s8f3Z_HV9Q@mail.gmail.com>
	<[email protected]>

On Tue, Oct 15, 2024 at 9:23 PM Laurenz Albe <[email protected]>
wrote:

> On Tue, 2024-10-15 at 16:27 -0700, Jacob Biesinger wrote:
> > *would you* expect to be able to stand up a `repeatable read` replica
> against a
> > `serializable` master? My expectation is that you'd simply change the
> setting in
> > a .conf file on the replica and be good to go; is there something that
> would make
> > this process really difficult / impossible?
>
> I expect that to work fine, at least I cannot think of a problem with such
> a setup.
> But I have been wrong before, so test it.
>

The setup (serializable master, repeatable read replica) definitely works
-- we've been running that way for over a year now. I guess I'm really
asking "how would you go about getting the replica into the appropriate
state?" Would you expect to have to downgrade the master's isolation level
as I describe? Or would you expect to be able to stand up the replica using
a modified conf file initially?

Thanks as always for your help!

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: serializable master and non-serializable hot standby: feasible set up?
  In-Reply-To: <CAHYXj6f0X4CU+xzTZRHmA_0b+99CnLUHu8fabbPVW4XL1qw0yQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox