Advanced capabilities now supported for MariaDB and Percona in Flyway
Published 09 January 2024
We have now added advanced capabilities support for MariaDB and Percona Server for MySQL in Flyway.
MariaDB is an open-source fork of MySQL, that claims “improved performance, more cutting-edge features and better support to handle complex large datasets” (For more information, please visit mariadb.org). Percona Server for MySQL is another fork of MySQL targeting the customers who are interested in a “free, fully compatible enhanced open-source drop-in alternative for MySQL that facilitates better performance, more scalability, and instrumentation” (percona.com/mysql).
In 2023, we released full support for MySQL advanced capabilities in Flyway, but we only had foundational support for MariaDB and Percona in Flyway Community and Teams. To improve our coverage of the MySQL market, we have now released advanced capabilities for the two forks in Flyway Enterprise.
Flyway Enterprise users will now be able to create new projects, compare differences in versions, auto-generate migration scripts, create their own custom code analysis rules, run comparisons and generate change and drift reports with MariaDB and Percona.
A quick glimpse of what we now offer for our Maria DB and Percona customers is outlined below:
DevOps practice | Features | MariaDb | Percona |
Version control | Object-level history | ✔ | ✔ |
Versioned migrations | ✔ | ✔ | |
Migration script | Schema changes (DDL) | ✔ | ✔ |
Static data changes (DML) | On roadmap | On roadmap | |
Continuous integration | Build validation | ✔ | ✔ |
Unit testing | ✔ | ✔ | |
Code analysis | ✔ | ✔ | |
Repeatable deployments | Automated script deployment | ✔ | ✔ |
Change reports | ✔ | ✔ | |
Drift detection | ✔ | ✔ |
Further details regarding supported features can be found here. For checking compatibility with specific MariaDB or Percona versions please refer to our documentation page here. To get started with Flyway Desktop to create projects with MySQL or its forks, please see this video.
Thank you for taking the time to read about our latest release, if you would like to reach out to discuss anything above, please feel free to email me (prajakta.tamhankar@red-gate.com).