From Newsgroup: comp.arch

According to David Brown <david.brown@hesbynett.no>:

Setting up a database server along with a couple of read-only
replications is harder. Adding a writeable failover secondary is harder >still. Making sure that everything works /perfectly/ when the primary
goes down for maintenance, and that everything is consistent afterwards,
is even harder. Being sure it still all works even while the different >parts have different versions during updates typically means you have to >duplicate the whole thing so you can do test runs. And if the database >server is not open source, your license costs will be absurd, compared
to what you actually need to provide the service - usually just one
server instance.

Clouds do nothing to help any of that.

AWS provides a database service that does most of that. You can spin
up databases, read-only mirrors, failover from one region to another,
staging environments to test upgrades. They offer MySQL and
PostgreSQL, as well as Oracle and DB2.

It's still a fair amount of work, but way less than doing it all yourself.
--
Regards,
John Levine, johnl@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly
--- Synchronet 3.20a-Linux NewsLink 1.114

From Newsgroup: comp.arch

On 17/10/2024 04:35, John Levine wrote:

According to David Brown <david.brown@hesbynett.no>:

Setting up a database server along with a couple of read-only
replications is harder. Adding a writeable failover secondary is harder
still. Making sure that everything works /perfectly/ when the primary
goes down for maintenance, and that everything is consistent afterwards,
is even harder. Being sure it still all works even while the different
parts have different versions during updates typically means you have to
duplicate the whole thing so you can do test runs. And if the database
server is not open source, your license costs will be absurd, compared
to what you actually need to provide the service - usually just one
server instance.

Clouds do nothing to help any of that.

AWS provides a database service that does most of that. You can spin
up databases, read-only mirrors, failover from one region to another,
staging environments to test upgrades. They offer MySQL and
PostgreSQL, as well as Oracle and DB2.

It's still a fair amount of work, but way less than doing it all yourself.

That's an additional service they provide - it's not an inherent part of
a cloud infrastructure. Still, it sounds like a useful service, and one
that I might find useful in the future.

--- Synchronet 3.20a-Linux NewsLink 1.114