Textpattern CMS

#37 2025-05-08 09:17:55

Algaris

Member

From: England

Registered: 2006-01-27

Posts: 569

Re: Adventures in Linux Land

I’m looking to upgrade from Percona Server 8.0 to 8.4 on my Debian server. After doing some research I found these instructions.

Is this a good way to upgrade to new versions or are there better ways of doing so? I’m very new to Percona Server and still finding my feet.

1. Backup my.cnf so it doesn’t get overwritten.

2. Stop the 8.0 Server.

sudo systemctl stop mysql

3. Switch to the Percona Repositories

sudo apt update
sudo apt install curl gnupg2 lsb-release
curl -0 https://repo.percona.com/apt/percona-release_latest.generic_all.deb \
  -o percona-release_latest.deb
sudo apt install ./percona-release_latest.deb
sudo apt update
sudo percona-release setup ps-84-lts

4. Install Percona Server 8.4

sudo apt install percona-server-server

5. Merge any custom settings from your old my.cnf into the new one. Watch out for changed defaults in InnoDB parameters and removed plugins (e.g. mysql_upgrade is gone in 8.4) — you may need to switch to the new component-based equivalents.

6. Start the upgrade

sudo systemctl restart mysqld

7. Post-Upgrade Checks

• Connect and run a few SELECT VERSION() / SHOW VARIABLES LIKE 'version%'; to confirm 8.4.

• Run CHECK TABLE …; or pt-table-checksum across schemas to verify data integrity.

——

Edit

Okay, after some further digging I found the Percona Docs page. Percona Docs: Upgrade using the Percona repositories

Still, if anyone has any general advice when upgrading Percona, best practices, gotchas, etc. that would be useful to know.

Last edited by Algaris (2025-05-08 10:53:25)

#38 2025-05-08 11:12:44

gaekwad

Server grease monkey

From: People's Republic of Cornwall

Registered: 2005-11-19

Posts: 4,350

GitHub

Re: Adventures in Linux Land

That’s pretty much the route I take with Percona MySQL from vendor repo, albeit a little less belt-and-braces. A few observations / considerations:

• The Debian / Ubuntu packages are pretty resilient and battle-tested, and from memory (don’t quote me on this) the handful of in-place upgrades I’ve done from Percona MySQL 8.0 to 8.4 kept the configs intact.
• Consider xtrabackup for enhanced backups: www.percona.com/mysql/software/percona-xtrabackup
• If you’re getting into backups beyond box-ticking, consider PHPBU if you’re running PHP on your server. There’s no support for xtrabackup yet but mysqldump does the job just fine.

The Textpattern servers are running Percona MySQL and an in-place upgrade happened on two of the VPSes, short of a reboot when I bumped Ubuntu to 22.04 there was no downtime. The next iteration of Textpattern VPS won’t be using Ubuntu at all, but will use Percona MySQL. An upcoming demo server VPS will have multiple MySQL-like instances from 3x vendors, and that involves compiling from source…which takes a veeeery long time. Worth it, but not something that can be rushed.

---

Textpattern CMS demo – tech updates

Code is Poetry; Text is Pattern.

#39 2025-05-08 11:15:41

gaekwad

Server grease monkey

From: People's Republic of Cornwall

Registered: 2005-11-19

Posts: 4,350

GitHub

Re: Adventures in Linux Land

gaekwad wrote #339681:

The Textpattern servers are running Percona MySQL and an in-place upgrade happened on two of the VPSes, short of a reboot when I bumped Ubuntu to 22.04 there was no downtime.

gaekwad wrote #338037:

For me, I don’t do in-place upgrades.

I don’t typically do in-place upgrades. There was a rats nest and I had security concerns, so needs must.

Last edited by gaekwad (2025-05-08 11:16:16)

---

Textpattern CMS demo – tech updates

Code is Poetry; Text is Pattern.