SQ56
A company's Cloud SQL instance fails over to the standby. The application experiences 30 seconds of connection errors. Which improvement most reduces failover impact?
- ASwitch to manual failover only
- BUse connection pooling with retry logic and short timeouts
- CRemove the failover replica
- DIncrease the Cloud SQL machine type
Show answerHide answer
Answer: B
Connection pooling with retries and appropriate timeouts allows the application to gracefully handle the brief connection disruption during failover. Increasing size doesn't improve failover speed. Removing the replica eliminates HA.