Migration from Oracle to MariaDB with no application change
summary
Case study of a live Oracle→MariaDB migration that preserves application code: applications using JDBC switch simply by changing connection strings and run under sql_mode=oracle; SQLines and custom analyzers identify incompatible SQL; MariaDB is patched (sql_yacc.yy edits, TO_CHAR implementation via DATE_FORMAT mapping, and ROWNUM as virtual column with cur_rownum) and test suites compare every DML result to Oracle; QMatrix handles full+incremental sync for cutover; patches are upstreamed and parts land in MariaDB 10.6.
AI-written summary · about
chapters (4)
related talks
24mTips and Tricks for Migrating from Oracle to MariaDB
21mSwitching from MySQL/Percona to MariaDB
47mOn the past, present and future of Open Source databases
41mMariaDB The New MySQL
23mSamsung Groupware(Knox Portal), Microservices-based Migration to MariaDB & Zero Downtime Upgrade
40mMySQL at Scale: Booking MariaDB to MySQL Migration
06mMigration Consideration Oracle to PostgreSQL
27mState of MariaDB