MySQL 5.7 is now EOL. If you are not ready to move to MySQL 8.0 or commit to a relationship with Oracle, now’s the time to move to open source MariaDB Server.

MySQL 5.7 Extended Support from Oracle ends in October 2023 (source 1, source 2). For those of you that initially selected MySQL to retain some degree of vendor neutrality and affinity towards open source, the Oracle track of migration to MySQL 8.0 and on to Oracle Heatwave and Oracle Cloud may not suit you, and you may want to consider a switch to MariaDB Server. Obviously, not all migrations are the same level of effort. Thanks to compatibility with MySQL protocols, it’s easy to make the switch to MariaDB Server and gain the added benefits of Oracle compatibility features, open source columnar storage and enhanced features such as MaxScale database proxy, advanced audit capabilities, and temporal tables.

This blog walks you through how to do an in-place migration from MySQL 5.7.43 to MariaDB Server 10.6.14. The commands and instructions shown work for any version of MariaDB Server 10.6.14 and greater, and work for both MariaDB Community Server and MariaDB Enterprise Server. It will give you some general pointers on how to perform a database migration project and two options for migrating tables with partitions. Plus, it goes through upgrading an environment that has database replication running.

…