I have just realised that my Ghost installation is running on MariaDB.
What are the pitfalls if I leave my installation on MariaDB for a little longer?
Potential breaking changes with every new update or release.
For now everything works fine but I will refrain from updating going forward until I move to MYSQL.
The longer you leave it, the harder it will be - a few have done the migration recently and documented it:
- https://forum.ghost.org/t/how-to-upgrade-to-mysql-8/
- https://forum.ghost.org/t/how-to-migrate-from-mariadb-10-to-mysql-8
- https://forum.ghost.org/t/debian-stable-upgrade-mariadb-to-mysql8
I’ve done it on a couple of dev servers, and four production servers that have a mix of fifteen Ghost blogs, and some other software that also uses the database.
Do it on a test box first - and take an initial backup / snapshot of everything, follow the instructions, take notes and write up your experience
2 Likes
Thanks, gang. Appriciated.
MySQL is FOSS. Moreover, Ghost has a small development team, and maintaining Ghost for multiple databases is a costly endeavour.
Resources are used to introduce new features. However, since Ghost is open source, you are free to modify the code to support another database.
1 Like