Ghost LXC: Migrate from unsupported MariaDB to MySQL 8 #958

Closed
opened 2026-02-04 22:20:27 +03:00 by OVERLORD · 3 comments
Owner

Originally created by @benjaminkjh on GitHub (May 15, 2025).

🌟 Briefly describe the feature

Update the Ghost LXC installation script to use MySQL 8 instead of MariaDB

📝 Detailed description

Ghost CMS officially supports MySQL 8 as the sole database backend for production environments. The current Ghost LXC script in this repository utilizes MariaDB, which is not officially supported and may lead to compatibility issues. To ensure alignment with Ghost’s supported configurations and to prevent potential issues with future releases, the script should be updated to install and configure MySQL 8.

Ghost documentation - What databases are supported in production?

💡 Why is this useful?

Utilizing MySQL 8, as officially recommended by the Ghost team, ensures full compatibility with current and future versions of Ghost. This change helps prevent potential issues related to unsupported database behavior and aligns the LXC setup with Ghost’s documented requirements.

Originally created by @benjaminkjh on GitHub (May 15, 2025). ### 🌟 Briefly describe the feature Update the Ghost LXC installation script to use MySQL 8 instead of MariaDB ### 📝 Detailed description Ghost CMS officially supports MySQL 8 as the sole database backend for production environments. The current Ghost LXC script in this repository utilizes MariaDB, which is not officially supported and may lead to compatibility issues. To ensure alignment with Ghost’s supported configurations and to prevent potential issues with future releases, the script should be updated to install and configure MySQL 8. [Ghost documentation - What databases are supported in production?](https://ghost.org/docs/faq/supported-databases) ### 💡 Why is this useful? Utilizing MySQL 8, as officially recommended by the Ghost team, ensures full compatibility with current and future versions of Ghost. This change helps prevent potential issues related to unsupported database behavior and aligns the LXC setup with Ghost’s documented requirements.
OVERLORD added the enhancement label 2026-02-04 22:20:27 +03:00
Author
Owner

@tremor021 commented on GitHub (May 16, 2025):

Reading their docs suggest doing a full database dump and loading it in fresh mysql db

this would mean that you will have to spin up a new LXC with MySQL running, transfer the db and load it up into the database...

https://forum.ghost.org/t/how-to-migrate-from-mariadb-10-to-mysql-8/29575

Also its a 3 year old "breaking change", obviously its not breaking anything. If breakage happens, we will update the script

@tremor021 commented on GitHub (May 16, 2025): Reading their docs suggest doing a full database dump and loading it in fresh mysql db this would mean that you will have to spin up a new LXC with MySQL running, transfer the db and load it up into the database... https://forum.ghost.org/t/how-to-migrate-from-mariadb-10-to-mysql-8/29575 Also its a 3 year old "breaking change", obviously its not breaking anything. If breakage happens, we will update the script
Author
Owner

@benjaminkjh commented on GitHub (May 16, 2025):

This would be the approach for existing installations, but for new users of the script, it would be better if the script just used MySQL in the first place.

@benjaminkjh commented on GitHub (May 16, 2025): This would be the approach for existing installations, but for new users of the script, it would be better if the script just used MySQL in the first place.
Author
Owner

@tremor021 commented on GitHub (May 16, 2025):

Correct. This implies that users on old version of the script are left to dry and need to be able to manually do the migration

@tremor021 commented on GitHub (May 16, 2025): Correct. This implies that users on old version of the script are left to dry and need to be able to manually do the migration
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/ProxmoxVE#958