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