When a component fails, traffic must route to a backup. This is failover.
Manual failover: Human intervention. Slow. Use for planned maintenance.
Automatic failover: Health checks detect failure. Traffic reroutes automatically. You need this for high availability.
Database failover is tricky. Promoting a replica to primary risks data loss if replication lagged. Know your RPO (Recovery Point Objective): how much data loss is acceptable.