Or you use cloud technology that allows that at more modest budgets -> standard service offering on most of them. But thats not our call! I agree it can be very expensive in some cases -> as SAN replication of the type you mention is very very expensive.If you have database on that scale, then you run multiple replication nodes live. You run on a SAN and have multiple hot nodes ready to go.
CAMC are not at that scale nor have that kind of budget,
And totally agree with this -> DBA's are the key to good business. And many organisations (inclding one I work for now) seem to think the profession isn't needed which is quite quite nuts. Has lead on a current project to them having numerous security weaknesses that I have to write up this week. I have the most respect for DBA's as in one case on a project ~ 8 years ago, they stopped a hardware upgrade project costing near half a million for that app instance alone (they had multiple instances of same system, so total cost would have been millions for ALL instances) to be scrapped as the reason for long transaction times was not the database hardware, it was locks in the 3 page SQL transaction across the database causing a commit delay. They fixed that, suddenly the app performed without any hardware upgrade with transaction times in milliseconds instead of seconds. It staggered the then management that the vendor they selected for their systems didn't have a DBA able to spot that contention in their (admittedly complex) code. DBA's save millions in some organisations for sure!I ended up managing Database professionals during my last years in computer employment. The one thing I learnt is that a good DBA costs and is worth their weight in gold. There are a lot who claim to be very capable but the real experts need to be paid well, not something every business is willing to do.