On Tue, Oct 15, 2024 at 9:23 PM Laurenz Albe <laurenz.a...@cybertec.at> 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!
