Switching from MySQL/Percona to MariaDB
summary
Live in-place migration from MySQL 5.7.41 → MariaDB 10.6.12 Enterprise demonstrates concrete steps: switch users to mysql_native_password, remove validate_password, drop incompatible partitions, convert JSON to LONGTEXT, replace MySQL packages with MariaDB, restore my.cnf.rpmsave, run mariadb-upgrade (re-run with --force) and drop corrupted sys/ina rows when needed. The demo reports specific errors and shows they resolve and the server boots as 10.6.12; also shows the MariaDB Migration Assessment Tool for pre-migration compatibility analysis.
AI-written summary · about
chapters (8)
- 0:00Intro
- 0:39Agenda
- 1:54When and Why Switch
- 3:14JSON Support in MariaDB
- 4:00Migration methodology
- 5:19Migration Steps at a glance
- 6:15mySQL 5.7 to MariaDB 10.6 migration demo
- 19:46Online Migration Assessment Tool
related talks
22mMigration from Oracle to MariaDB with no application change
16mMigrating from other databases to MariaDB
40mMySQL at Scale: Booking MariaDB to MySQL Migration
53mMariaDB Server 10.2: The Complete Guide
19mUpgrading to a newer major version of MariaDB
34mMySQL 8
38mRunning MySQL & MariaDB Server securely in 2019
41mMariaDB The New MySQL