Upgrading from 5.5 to 10.2
As part of a Cloudera upgrade, I need to update our MariaDB instance fromthe current version 5.5.68 to 10.2. We are running RHEL 7.9.
I was wondering if anyone can share or direct me to installation steps to help me understand 1. Where best to download the installation files? 2. Whether I can upgrade to 10.2 directly, or if I need to pass via 10.1 or other?
Any help appreciated.
Answer Answered by Daniel Black in this comment.
There are repositories for 10.2 for RHEL7 that can be used to install the MariaDB-10.2 code.
Copy the datadir (/var/lib/mysql by default) to your new server. If there is any /etc/my.cnf or /etc/my.cnf.d files on the previous Cloudera release copy these over to the new server too if they container non-default values. Some options may have changed, but the error log on startup will clearly show this if it has changed. There are some documents related to upgrading to read though what has changed in the major versions.
No intermediate upgrade version is required.