Re:Zero downtime Postgres migration, done right
by Pxtl on Friday June 11, 2021 @03:40PM
(#27477563)
Well, Postgres is F/OSS, so I expect the solution to problems to be "lots of small tools"... but I see the same kind of herculean battle-plans for MS SQL Server work, and I get shocked. That is a paid product, what on Earth are we paying for?
Re:Zero downtime Postgres migration, done right
by marcosdumay on Friday June 11, 2021 @04:05PM
(#27477798)
> what on Earth are we paying for?
The same is the same for any relational DBMS: lock-in.
Re:Zero downtime Postgres migration, done right
by worewood on Friday June 11, 2021 @05:04PM
(#27478469)
You're paying for an "if something goes wrong and it's the software's fault you can sue us" license
Re:Zero downtime Postgres migration, done right
by senko on Friday June 11, 2021 @05:50PM
(#27478926)
You're not. Approximately 25% of SQL Server EULA text deals with ways in which the warranty is limited. The best the license gives you is your money back if you prove that it was the software's fault.
Of course, you can always sue. A $2T company. Good luck with that.
Re:Zero downtime Postgres migration, done right
by doctor_eval on Friday June 11, 2021 @06:05PM
(#27479069)
Went to post the same thing but HN had a little downtime burp.
Would only add that the main reason people buy these licenses, apart from familiarity, is so they can shift the blame if something goes wrong. Its all about ass covering.
Re:Zero downtime Postgres migration, done right
by salmo on Friday June 11, 2021 @06:14PM
(#27479147)
Well, this and
1) the illusion of "support" 2) OSS-fearing companies' love of indemnification
Re:Zero downtime Postgres migration, done right
by fridif on Friday June 11, 2021 @10:22PM
(#27480860)
it likely wasnt downtime and rather a "you are posting too many messages and we will pretend that the whole site is down rather than telling you"
Re:Zero downtime Postgres migration, done right
by afarrell on Friday June 11, 2021 @08:25PM
(#27480130)
You’re presumably paying for a relationship with someone who has expertise.
Re:Zero downtime Postgres migration, done right
by defaultname on Friday June 11, 2021 @03:54PM
(#27477690)
This is a complex task, fraught on any platform. Most systems base such clustering on a shared filesystem, which is obviously orthogonal to the shared nothing designs most try to pursue.
Re:Zero downtime Postgres migration, done right
by rigaspapas on Tuesday June 15, 2021 @06:05AM
(#27513166)
AWS can upgrade your database automatically, but with some downtime. AWS also provides DMS for migrations, which didn't work well in our case. So it was rather a simple problem at first, which turned to be a very complex one in the end.
Re:Zero downtime Postgres migration, done right
by 0xbadcafebee on Friday June 11, 2021 @05:18PM
(#27478636)
> Most modern rdbms/nosql database vendors
"Modern" = "not a traditional RDBMS". Expecting your 1983 Toyota Corolla to fly, regardless of the fact that it's now 2021, is unrealistic. But personal helicopters have been around for a while.
Most modern rdbms/nosql database vendors allow a rolling upgrade where you roll in new servers and roll out the old ones seamlessly.
Also the fact that AWS rds doesnt do this with zero downtime by default through automating it this way is also crazy. Why pay for hosted when the upgrade story is incomplete? Take downtime to upgrade a DB in 2021? Everyone must be joking.