Please guide me on it.
Percona mysql upgradation MYSQL 5.6 to MYSQL5.7 is compatible for Ubuntu 20.04?
Currently MYSQL 5.6 running on below version:
mysql Ver 14.14 Distrib 5.6.34-79.1, for debian-linux-gnu (x86_64) using readline 6.3
VERSION=“14.04.5 LTS, Trusty Tahr”
PRETTY_NAME=“Ubuntu 14.04.5 LTS”
Highly thankfully in advance.
Percona Server 5.6 was not compiled for Ubuntu 20.04 but last version you can get PS 5.6 is for Ubuntu 18.04 that you can get from Download Percona Server for MySQL 5.6 .
You can still try compiling yourself for 20.04 but you might find some challenges along the way
Latest PS 5.7 is compiiled for Ubuntu 18.04 and 20.04 which you can get from Download Percona Server for MySQL 5.7
So if you need to Upgrade to 5.7 and Ubuntu 20.04 you might need to multiple OS and PS upgrades to get there.
Your software is extremely old in many ways. The best solution for you is to set up a brand new Ubuntu 22.04, install MySQL 8, and do a logical dump from your old 5.6 and import that into your new 8.0.