6 ms·

Its insane that it has to be this complex and require third party software to accomplish… Most modern rdbms/nosql database vendors allow a rolling upgrade wher

by tbrock 5y ago

Its insane that it has to be this complex and require third party software to accomplish… 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.

Pxtl 5y ago
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?
- marcosdumay 5y ago
  > what on Earth are we paying for? The same is the same for any relational DBMS: lock-in.
- worewood 5y ago
  You're paying for an "if something goes wrong and it's the software's fault you can sue us" license
  - senko 5y ago
    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.
    - doctor_eval 5y ago
      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.
      - salmo 5y ago
        Well, this and 1) the illusion of "support" 2) OSS-fearing companies' love of indemnification
      - fridif 5y ago
        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"
  - afarrell 5y ago
    You’re presumably paying for a relationship with someone who has expertise.
defaultname 5y ago
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.
0xbadcafebee 5y ago
> 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.
rigaspapas 5y ago
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.

by tbrock 5y ago

Pxtl 5y ago

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?

marcosdumay 5y ago
> what on Earth are we paying for? The same is the same for any relational DBMS: lock-in.
worewood 5y ago
You're paying for an "if something goes wrong and it's the software's fault you can sue us" license
- senko 5y ago
  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.
  - doctor_eval 5y ago
    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.
    - salmo 5y ago
      Well, this and 1) the illusion of "support" 2) OSS-fearing companies' love of indemnification
    - fridif 5y ago
      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"
- afarrell 5y ago
  You’re presumably paying for a relationship with someone who has expertise.

defaultname 5y ago

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.

0xbadcafebee 5y ago

> 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.

rigaspapas 5y ago

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.