How to upgrade MySQL/MariaDB with Governor over multiple versions

Issue

How to upgrade MySQL/MariaDB managed by the Governor through several versions?

Solution

1. Before switch, create a full database backup (including system tables), if you haven't one. This action will prevent data loss in case if something goes wrong.
2. In order to change MySQL version, you should run the following commands:

   # /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION
   # /usr/share/lve/dbgovernor/mysqlgovernor.py --install

   where MYSQL_VERSION is the target database server version that should be replaced with the value from the table below.

   Note: The upgrade should proceed in series, for example, for MariaDB 10.1 to 10.3:

   10.1 → 10.2;

   10.2 → 10.3.

   mysql51	MySQL v5.1
   mysql55	MySQL v5.5
   mysql56	MySQL v5.6
   mysql57	MySQL v5.7
   mysql80	MySQL v8.0 (requires MySQL Governor 1.2-37+)
   mariadb55	MariaDB v5.5
   mariadb100	MariaDB v10.0
   mariadb101	MariaDB v10.1
   mariadb102	MariaDB v 10.2
   mariadb103	MariaDB v 10.3 [requires MySQL Governor 1.2-36+; for cPanel - MySQL Governor 1.2-41+]
   mariadb104	MariaDB v 10.4 [requires MySQL Governor1.2-53+]
   mariadb105	MariaDB v 10.5 [requires MySQL Governor1.2-62+]
   mariadb106	MariaDB v 10.6 [requires MySQL Governor1.2-76+]
   percona56	Percona Server v 5.6

Useful links

MySQL Governor - Upgrading database server