MySQL / MariaDB DBA

Percona Toolkit

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.

This is 19 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples