Re:Leaving MySQL
by PikachuEXE on Monday December 06, 2021 @01:44AM
(#29456920)
I have written an article about upgrading PSQL with no/low downtime with Logical Replication. (More like a note to my future self)
See if you can understand enough of it and consider doing it again for next upgrade. (I have done that for 12 > 13)
So to be honest I see that article (linked below) and I think "Yeah that's probably all right", but given this is for a Real Sytem With Serious People's Data, when faced with "take the downtime and do the offline data upgrade that _basically everyone does_" and "try to use logical replication to get a new database in the right state, knowing that logical replication doesn't copy _everything_ so I need to manually copy some stuff, and if I miss stuff I'm in a bad situation"...
I trust the pg people that tools do what are advertised, but it's a very high risk proposition
Re:Leaving MySQL
by psychoslave on Monday December 06, 2021 @02:32AM
(#29457168)
Maybe you could give a link to the post
Re:Leaving MySQL
by nikisweeting on Monday December 06, 2021 @02:31AM
(#29457162)
Whats the link?
I suppose https://dev.to/pikachuexe/postgresql-logical-replication-for... would be it.
Re:Leaving MySQL
by PikachuEXE on Monday December 06, 2021 @09:22PM
(#29468480)
This is what happen I don't have enough sleep...
I forgot to post the article link!
Thanks for posting it.
I think Postgres is really cool and has a lot of good reliability, but I've always wondered what people do for high availability. And yeah, pgbouncer being a thing bugs,
It feels like we're getting closer and closer to "vanilla pg works perfectly for the common worklfows" though, so tough to complain too much.