Design an infrastructure scaling plan and propose solutions for eliminating SPOFs (Single Points of Failure), including analysis of potential bottlenecks as user volume grows
Choose 1–2 from the following performance challenges:
Query Optimization: Insert a large volume of test data (100K–1M rows), measure query performance, and apply indexes
Server Tuning: Define target TPS and adjust server and database connection pool settings (e.g., maxThreads, HikariCP)
Zero-Downtime Deployment: Implement a deployment strategy using Blue-Green deployment or Nginx to avoid service interruption
Concurrency Handling: Prevent data conflicts under concurrent user access using optimistic/pessimistic locking or atomic queries
Event-Driven Architecture: Refactor one feature into an asynchronous, event-driven structure using internal pub/sub or a message queue