Can MySQL be a version later than 8?

Developer help Self-hosting
1

I’ve just updated to Ghost v6.0.

Can MySQL be a version later than 8? or does it have to set to a specific 8 version? If so, which version? 8.0? 8.1?

Or is the spec “at least 8.0”?

2

The spec is “8” - though that means anything from the “8.x” version, really.

MySQL 9 will work, but show a warning in the Ghost settings.

I’d personally go with the current LTS, 8.4.

1 Like
3

There are two ways to get at this question: Will it run, preferably without warnings that annoy me too much?

And:

Am I maximizing the chances that my database is well tested and I won’t hit random annoying edge cases that won’t get swiftly fixed because no one on the dev team is impacted or can easily replicate?

The answer to the first one is probably yes.

The answer to the second one is no. If you choose to run a newer version of MySQL (or to run MariaDB), you aren’t maximizing your chances of everything working and bugs being swiftly squashed. If it were me, unless I had a really compelling reason to run a newer version of MySQL than 8.whatever LTS, I wouldn’t.

In the last year, I’ve found and fixed Windows-only bugs that the core dev team couldn’t see or easily replicate because they all run Macs. I’ve been aggravated by an SQLite bug that isn’t present in MySQL, and it’s a lower priority since it only hits development. If you can match the configuration of Ghost Pro and/or what the dev team is using for development, you minimize the amount of this stuff that happens.

2 Likes