Updating Percona Server

MySQL & MariaDB Other MySQL® Questions
1

Hello, I’m relatively new to Percona and MySQL server and I was curious. I see the docs on upgrading from one major version of the server software to another. But what about incremental/security updates?

Is it recommended that you do a dump and reinstall the software?

Thanks!

2

Yes, the best practice is mysqldump, software reinstall and restore in case of major version upgrade

3

Hi,

For the minor version upgrade like PS 5.1.70 to 5.1.71, you generally no need to dump/reload the databases. You can simply move from one binary to another. But when you are doing major version upgrade like PS 5.1 to 5.5 then you have to consider many things. Check below links.

[URL]Percona Server for MySQL 8.0 - Documentation — Percona Server 8.0 Documentation
[URL]Percona Server for MySQL 8.0 - Documentation — Percona Server 8.0 Documentation

So I would suggest, as a safer side in any case, it is always recommended to take a backup before upgrade the MySQL.