If you are self-hosted, what is the recommended database & version?
So I found this was updated recently - Supported node versions for self-hosted installs of Ghost - and since I last checked, it’s moved from Node v10 to v14 :o - must make a note to check this more often.
I cannot find where the database software is specified? In 2017, Debian (the upstream for Ubuntu) moved away from MySQL - the package default-mysql-server serves up MariaDB 10.3 for current stable. Versions of MariaDB up to v10.5 are largely compatible with MySQL up to v5.7.
Unfortunately, after these versions, the divergence is growing. Recent threads talk about the Ghost developers using MySQL v8.
It should be noted that the Ubuntu package system adds a mysql-server package - which defaults to MySQL, moving from 5.7 to 8.0 as you upgrade Ubuntu. It looks like this switch is not yet back-ported to Debian.
In light of this, I would appreciate a comment from the Ghost team on: If you are self-hosted, what is the recommended database & version?