A comprehensive guide to database high availability patterns, redundancy strategies, and failover mechanisms for mission-critical applications