Ghost LXC: Migrate from unsupported MariaDB to MySQL 8

[benjaminkjh]

🌟 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.

[tremor021]

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

[benjaminkjh]

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.

[tremor021]

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