Lemmy Administration

11 readers

1 users here now

Anything about running your own Lemmy instance. Including how to install it, maintain and customise it.

Be sure to check out the docs: https://join-lemmy.org/docs/en/administration/administration.html

If you have any problems, describe them here and we will try to help you fixing them.

founded 4 years ago

MODERATORS

nutomic@lemmy.ml

Is it possible to run a Lemmy instance with a MySQL backend? (lemmy.ml)

submitted 1 year ago by JuxtaposedJaguar@lemmy.ml to c/lemmy_admin@lemmy.ml

1 comments fedilink hide all child comments

I'm thinking about setting up my own (bare metal) Lemmy instance to play around with it, but it seems to require PostgreSQL. Everything else on my system uses MySQL, and I don't really want to run 2 separate database services. I guess I would also be fine with using an SQLite file, but that's not ideal.

Has anyone managed to set up a Lemmy instance with MySQL instead of PostgreSQL? Are you aware of any PostgreSQL to MySQL or SQLite compatibility layers?

top 1 comments

sorted by: hot top controversial new old

[–] sinnerdotbin@lemmy.ca 2 points 1 year ago

Only PostgreSQL at the moment. I also don't believe it currently supports SSL connection to Postgres so you'll want to run it on the same machine or have a tunnel to your DB.

There is zero chance you'll get it running on anything else without significant code change.