streaming replication different versions

Started by Marc Millasover 4 years ago4 messagesgeneral
Jump to latest
#1Marc Millas
marc.millas@mokadb.com

Hi,

on release 10, I remember reading something like: streaming replication is
NOW upward compatible.
which could be understood as: its possible to have a master in rel 10 and a
slave in rel 11.

Can someone confirm (or not !) this ?

if true, is the following scheme possible:
a master and a slave in same rel (10/11/12/13/14?)
1) stopping the slave
2) upgrading the slave to rel+1
3) restarting the slave
4) stopping the master and promoting the slave
5) upgrading the ex master
6) restarting it as slave
bingo version upgrade without stopping production.

what about the time line of the upgraded slave (step 2 ) ??

thanks,

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

#2Thomas Kellerer
shammat@gmx.net
In reply to: Marc Millas (#1)
Re: streaming replication different versions

Marc Millas schrieb am 06.10.2021 um 13:43:

on release 10,  I remember reading something like: streaming replication is NOW upward compatible.
which could be understood as: its possible to have a master in rel 10 and a slave in rel 11.

No, that's not possible.

For streaming replication both servers must run the same major versions.

#3Guillaume Lelarge
guillaume@lelarge.info
In reply to: Thomas Kellerer (#2)
Re: streaming replication different versions

Le mer. 6 oct. 2021 à 13:46, Thomas Kellerer <shammat@gmx.net> a écrit :

Marc Millas schrieb am 06.10.2021 um 13:43:

on release 10, I remember reading something like: streaming replication

is NOW upward compatible.

which could be understood as: its possible to have a master in rel 10

and a slave in rel 11.

No, that's not possible.

For streaming replication both servers must run the same major versions.

You're right for physical replication. But it works for logical
replication, which was released in version 10.

--
Guillaume.

#4Marc Millas
marc.millas@mokadb.com
In reply to: Guillaume Lelarge (#3)
Re: streaming replication different versions

it does work well for logical replication.
still its sad that it doesnt work for physical replication as, then, how to
ensure continuous availability for generic apps ??

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Wed, Oct 6, 2021 at 5:03 PM Guillaume Lelarge <guillaume@lelarge.info>
wrote:

Show quoted text

Le mer. 6 oct. 2021 à 13:46, Thomas Kellerer <shammat@gmx.net> a écrit :

Marc Millas schrieb am 06.10.2021 um 13:43:

on release 10, I remember reading something like: streaming

replication is NOW upward compatible.

which could be understood as: its possible to have a master in rel 10

and a slave in rel 11.

No, that's not possible.

For streaming replication both servers must run the same major versions.

You're right for physical replication. But it works for logical
replication, which was released in version 10.

--
Guillaume.