Your primary database is reaching capacity limits and you need to scale to handle three times the current load without any downtime. Describe your strategy for achieving this, including both vertical and horizontal scaling approaches.

Sample answer preview

Scaling a database to three times its current capacity with zero downtime requires a carefully orchestrated strategy that combines optimization, vertical scaling, and potentially horizontal scaling, each executed in stages with validation gates between them.