About the Tool
The MariaDB Migration Tool (mariadb-migrator) is a local, intelligent orchestrator designed to make moving from MySQL (8.0/8.4) to MariaDB 11.x (LTS) or MariaDB Cloud completely predictable, repeatable, and auditable.
Rather than manually uploading DDL files and waiting for an email, the new tool runs directly in your environment. Before moving a single byte of data, the tool’s dedicated Assess & Plan mode inspects your source database, validates network stability, and maps out your exact migration journey. It automatically generates a comprehensive, predictive user_assessment_report.txt locally, allowing your DBAs to preview exactly how schemas, users, and privileges will seamlessly port over.
Once the assessment is clear, the tool provides four distinct migration pathways—ranging from offline parallel streaming to continuous zero-downtime online replication—all executable via a friendly interactive menu or a non-interactive CI/CD orchestrator CLI.
Assessment and Orchestration Capabilities
The tool analyzes your source database and automatically handles or flags the following:
Security & User Porting
Legacy Hashes
Preserves mysql_native_password authentication hashes.
Modern Plugins
Safely provisions temporary passwords with PASSWORD EXPIRE for caching_sha2_password users.
Role Mapping
Automated detection and recreation of MySQL roles.
Schema & Compatibility Assessment
Data Types
Flags compatibility roadblocks (e.g., hidden JSON columns).
Replication Integrity
Validates proper binlog formats and network connectivity.
Validation
Built-in SHA-256 integrity checksums and automated row-count validation.
Performance & Automation
Parallel Execution
Table loads and chunking of large tables in parallel worker sessions.
Restartable
Within-run auto-retries on transient errors
Validations
Row-count or byte validation after every load
Day-One Performance
Injects an automated ANALYZE TABLE phase to rebuild optimizer statistics before traffic cutover.
Self-Bootstrapping
Automatically creates its own local Python virtual environment for immediate use.
Four Migration Pathways
No matter your maintenance window or infrastructure size, the tool adapts to your requirements:
Serial Streaming Copy (one_step)
Direct network pipe for predictable, standard maintenance windows.
Best for: Small to mid databases, simple topology, the fastest path when downtime is acceptable.
Parallel Streaming Copy (two_step)
High-speed, multi-threaded load chunking for massive datasets.
Best for: When schema and data benefit from independent tuning, or when parallel data load matters and running from a independent tools server.
Offline Staged Copy (staged)
Phase-driven load for air-gapped systems or complex cloud shifts (e.g., AWS RDS to MariaDB Cloud).
Best for: Air-gapped environments, scheduled maintenance windows, or coordinated multi-team cutovers.
Continuous Replication (binlog)
Online snapshotting and continuous log replication for near-zero downtime cutovers.
Best for: Production cutovers where downtime must be measured in seconds, not hours.
Ready to Make the Switch?
Start your MariaDB migration today and unlock the full potential of your data!
Migration Guides
Oracle to MariaDB
MySQL to MariaDB
PostgreSQL to MariaDB
MariaDB on Amazon RDS to MariaDB Cloud
COMING SOON