~/talk

Upgrading to a newer major version of MariaDB

Talkat FOSDEM 2021 · on Saturday, 2021-02-06· at 10:30· D.mariadb· [databases]

speaker

name:Valerii Kravchuk

links:none on file

resources

video:https://youtu.be/1kLIXN2DoEo

slides:https://fosdem.org/2021/schedule/event/mariadb_upgrade/attachments/slides/4266/export/events/attachments/mariadb_upgrade/slides/4266/Upgrading_to_a_newer_major_version_of_MariaDB_FOSDEM_2021.pdf

summary

Claims that MariaDB lets you jump major versions rely on mysql-upgrade runs SQL fixes from a generated sql.c sequence and on its idempotent SQL-driven approach that tries to recreate or alter mysql. tables. It also documents limits: cannot fix engine/plugin or InnoDB corruption*, and it misses some migrations (old DATETIME internal format, virtual columns, Galera major-version mismatches). Known bugs affect events, roles and statistics; mysql-upgrade writes its progress to a file not the DB and may need --force to rerun. Always run it and check logs.

AI-written summary · about

chapters (4)

related talks