Question
pt-online-schema-change versus native ALTER TABLE: how do their change paths differ?
Answer
Native ALTER TABLE runs inside the server via INSTANT, INPLACE or COPY algorithms; whether concurrent writes continue depends on operation, algorithm and product. pt-online-schema-change works externally, keeping a trigger-synced copy and then swapping it in. Prefer native when the change is instant or online. Applies to MySQL and MariaDB.