Migrating from other databases to MariaDB

on YouTube ↗16m

" summary

Procedure for migrating proprietary databases to MariaDB presents a tested, versioned path: analyze query logs with SQLLines, dump or copy data, run mariadb-upgrade and switch connectors. MariaDB adds Oracle compatibility (SQL_MODE=ORACLE in 10.3) plus SEQUENCES and packages so DBS Bank’s core apps run SQL queries unchanged after migration; MySQL 5.7 is drop-in while MySQL 8.0 needs a dump due to storage-layout changes; SQL_MODE=MSSQL appears in 10.2.3 for basic SQL Server syntax.

AI-written summary · about

" chapters (9)

1. 0:00Introduction to migration
2. 3:48Migrating ANSI compliant databases
3. 5:02Migrating from MySQL
4. 7:05Migrating from Oracle
5. 9:09Oracle compatibility features
6. 11:40Oracle-specific functions
7. 13:29Migrating from SQL Server
8. 14:47Collaborative migration process
9. 15:40Q&A and support

" related talks

• 24mTips and Tricks for Migrating from Oracle to MariaDBAnders Karlsson · MariaDB OpenWorks 2023
• 21mSwitching from MySQL/Percona to MariaDBPramod Mahto · MariaDB OpenWorks 2023
• 41mMariaDB The New MySQLColin Charles · HighLoad++ 2012
• 47mOn the past, present and future of Open Source databasesKaj Arnö · Shift Dev 2019
• 40mMySQL at Scale: Booking MariaDB to MySQL MigrationPep Pla, Mohammed Gaafar · Percona Live 2022
• 27mState of MariaDBMichael Widenius · O'Reilly MySQL Conference & Expo 2011
• 17mState of MariaDBMichael Widenius · Percona Live 2022
• 27mMariaDB’s Path to Google Cloud with SADA SystemsBrian Suk, Assoc. CTO, Sada · MariaDB OpenWorks 2023