Issue
How to upgrade MySQL/MariaDB managed by the Governor through several versions?
Solution
- 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.
- 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 --installwhere
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
Comments
0 comments
Please sign in to leave a comment.