Flyway

Advanced capabilities now supported for MariaDB and Percona in Flyway


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 
auto-generation 

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). 

 


Didn't find what you were looking for?