alyx, 3 months ago

@jemal Oh, are you sure it requires MySQL? I have several Ghost blogs running on MariaDB and I haven’t noticed anything wrong (yet?).

jemal, 3 months ago

@alyx Yeah, for 5.0+ they require it - ghost install won't work without it. 😕

https://forum.ghost.org/t/when-will-mysql-8-be-mandated-which-ver/29228/2

alyx, 3 months ago

@jemal uhoh 😰
But then yeah I would recommend what the other reply said, launch a docker container so you can throw everything away easily 👌

jemal, 3 months ago

@alyx That's what I'm considering - I've been burned by Docker so much in local dev that I'm nervous about running it on a server.

alyx, 3 months ago

@jemal Uh I can imagine. For how long do you want to test things out? Depending on that, I can give you the command to run it, so you don’t have to figure it out yourself (says the person that actually runs ghost on the wrong DB lol)

jemal, 3 months ago

@alyx I think I'm going to try and set it up locally and get that going before taking down a server - if only so i can get a feel for the RAM/CPU usage. But I'll take any tips you've got!

alyx, 3 months ago

@jemal Three solutions comes up to my mind if it's just a temp thing to try Ghost:

• Use fly.io and pay a really cheap price to run both the DB and Ghost you want, though, if you don't like Docker, it won't be fun for you. Not the easiest way for sure.
• Even if Ghost says it requires MySQL, it seems like it's working fine so far with MariDB, so it might be worth trying it out? Worst that can happen is Ghost won't run

alyx, 3 months ago

@jemal And let me craft the commands locally, or even better, a docker-compose file so you can run it easily ❤️

alyx, 3 months ago

@jemal Do you have a preference between "docker run" commands or a "docker-compose.yml" file?

"docker run" will requires to run the commands I will provide, while having a docker-compose.yml file will do everything for you after doing "docker compose up”

Sorry for all the questions, we can do this later if you'd like.
Hey you know what, I’ll provide both and pick whichever haha

jemal, 3 months ago

@alyx Well, I don't have a preference, but don't go to any trouble! Whichever is easier is probably better at this point! Thanks for all the help!

alyx, 3 months ago

@jemal I really don't mind, I'm bored and it makes me happy to help someone ☺️ I'll send that in a few minutes after some testing.

alyx, 3 months ago

@jemal lol i fell in the rabbit hole of running my own Gist service, but the commands are ready haha

alyx, 3 months ago

@jemal Here's the docker run commands
(Sorry I made a mistake in the previous one)

https://gist.alyx.pink/?fab92fbe60493a9b#Erh39rSc69kygXF6ibXkJ6qG9BKLZ91cL1WUPPmRgpRY

And I'm doing the docker-compose right now :)

alyx, 3 months ago

@jemal And boom the second one with "docker compose” https://gist.alyx.pink/?4685c6c4673aa41b#D9pC56HYnuvGM6Koc8iq7B35ikfHysVEWbm9nUpREVVX

Let me know if you have any issues, I'm really happy to help ❤️ And if you don't want to run any of that, no worries, it's totally ok it just took some time from me and it was fun to do hehe

pwaring, 3 months ago

@jemal If you just want to try Ghost, there are Docker images available which might save you a lot of trouble? Otherwise you'll have to configure either MariaDB or MySQL to listen on a different port, because by default they both use the same one (3306 - or you can configure them to use sockets). You might find some clashes though as commands like mysqldump are usually included in both packages.