ALGORITHM=INSTANT on Aurora: Which ALTER TABLE Operations Are Truly Zero-Downtime

In a high-availability Aurora MySQL environment, minimizing downtime during schema changes is paramount. Traditional ALTER TABLE operations often require table locks, blocking reads and writes for the duration of the operation. This is unacceptable for applications with stringent uptime requirements