Database failover involves trade-offs and costs including replication lag, split-brain risk, switchover windows and connection storms, transaction integrity, and cascading impacts.