MySQL 8.4LTS and Textpattern

phiw13 · 2024-10-16 12:04:50

Are there any possible issues or weird gotchas that could hide in a little corner? I expect one hosting service we use to upgrade sooner rather than later.

I ~~installed~~ upgraded locally and at first glance everything works as expected on two different test sites, both public side and admin side. Users can log in and change their passwords, creating, saving editing articles happens as it should as far as the DB is concerned, dito for creating and editing categories, editing forms and pages, etc. Uploading then editing metadata for images and files just works.

Creating a new site (Textpattern install process) was flawless. Creating new users was OK, I could modify the password for those users directly in the DB as before (localhost does not have a mail server configured).

Oh and BTW, I downloaded installed MySQL 8.4.2LTS. Of course, two days later, MySQL 8.4.3LTS was released… (</sigh>).

jakob · 2024-10-16 13:29:38

I’ve been using mysql@8.4 locally via homebrew (currently 8.4.2) for quite a while and not observed any problems at all. Not sure if/how this differs from the LTS version.

phiw13 · 2024-10-16 23:56:39

Thanks. That’s reassuring.

From what I understand, all 8.4.x is the current long term support version (LTS). Pete would know for sure I think.

PS – The Homebrew package omits in LTS in the name as it would fit better fit their versioning schemes.

gaekwad · 2024-10-17 09:40:20

phiw13 wrote #338023:

From what I understand, all 8.4.x is the current long term support version (LTS). Pete would know for sure I think.

You’re correct, on both counts. See endoflife.date/mysql for info.

Oracle MySQL 8.4.0 landed in spring 2024, Percona have their ‘remix’ on GA, so it’s getting traction. There are ~18 months of mainline support remaining in MySQL 8.0, not that it makes much difference in how it’s deployed in the real world since unsupported PHP (see endoflife.date/php for info) is rampant.

phiw13 wrote #338021:

Are there any possible issues or weird gotchas that could hide in a little corner? I expect one hosting service we use to upgrade sooner rather than later.

None that I’ve found. I’ve been running Percona-flavoured MySQL 8.4 since late August 2024 and it’s been fine. There’s a MySQL 8.4 tracking issue with some bedtime reading, if that’s your thing.

bici · 2024-10-17 15:55:15

My Web host informed us yesterday of their new Configuration :

PostgreSQL 11/14 → PostgreSQL 17
MariaDB 10.6 → Percona MySQL 8.4
Ruby 3.2 → Ruby 3.3
System Python 2.7 → Python 3.9
Default PHP 7.3 → PHP 8.3
Apache 2.4.6 → Apache 2.4.57
Kernel 3.10.0 → Kernel 5.14.0

I am assuming this will mean a smooth transition to TXP 4.9

gaekwad · 2024-10-17 16:39:47

bici wrote #338025:

MariaDB 10.6 → Percona MySQL 8.4

In theory, this should be fine, but it’s brave on their part. (Edit: I’m curious why they haven’t gone MariaDB 10.6 to MariaDB 11.4, I’m sure there are good reasons.) There are subtle differences in the architecture of MariaDB and Percona, and differences in names for the various binaries that run things, but it should be smooth sailing. I literally only looked at MariaDB recently as it has ARM64 support (this was prior to Percona releasing 8.4.0 packages with ARM64 support, the compile from source route is pretty hellish for Persona stuff and I’m not that brave where deadlines are looming).

Default PHP 7.3 → PHP 8.3

Wheeeee! That’s a big jump. Are they only offering PHP 8.3, or is that the newest of a few versions?

Apache 2.4.6 → Apache 2.4.57

Nothing to see here. Apache 2.4.0 came out 12 years ago and they keep it simmering nicely.

Kernel 3.10.0 → Kernel 5.14.0

My instinct is telling me they’ve gone from…either CentOS or Red Hat to…Rocky or Alma Linux. Am I close?

Last edited by gaekwad (2024-10-17 16:42:15)

phiw13 · 2024-10-17 23:25:59

gaekwad wrote #338026:

My instinct is telling me they’ve gone from…either CentOS or Red Hat to…Rocky or Alma Linux. Am I close?

Alma Linux (coming from CentOS).

And yes PHP 8.3 will be (for now) the only option installed by default. Users can always add/install their own, afaik. I am assuming the underlying system libraries are not an issue. Your favourite PHP 5.23 might be difficult to set up.

Existing/current users can stay on the their current configuration for a while. The New Shinny Thing will require migration to the new iron.

bici · 2024-10-18 00:30:42

phiw13 wrote #338027:

Alma Linux (coming from CentOS).

And yes PHP 8.3 will be (for now) the only option installed by default. Users can always add/install their own, afaik. I am assuming the underlying system libraries are not an issue. Your favourite PHP 5.23 might be difficult to set up.

Existing/current users can stay on the their current configuration for a while. The New Shinny Thing will require migration to the new iron.

Shared servers will be running on AlmaLinux 9 instead of CentOS 7.

gaekwad · 2024-10-18 13:43:58

phiw13 wrote #338027:

Your favourite PHP 5.23 might be difficult to set up.

Challenge accepted! When I get my head around ZTS and non-ZTS PHP compilation, I’ll check into PHP 5.23. It sounds wild!

I’m still thankful I didn’t lose a summer reading (or writing) a book on a non-existent / unreleased version of PHP – that could’ve been awkward.

Bloke · 2024-10-18 14:53:19

Haha, priceless.

Textpattern CMS

Textpattern CMS support forum

#1 2024-10-16 12:04:50