MySQL / MariaDB DBA

Upgrade, Patching & Migration

Question

In-place versus logical upgrade: what differs, and when should each be used?

Answer

An in-place upgrade starts the newer server on existing data files. A logical upgrade reloads exported schema and data into a fresh instance. Use in-place for supported paths and tested compatibility; use logical migration for cleaner transformation or rollback isolation. Applies to MySQL and MariaDB.

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

More MySQL / MariaDB DBA topic samples