Our forum underwent a large infrastructure change and now it’s not performing well. I migrated the database to be a managed database at digitalocean, I put S3 assets on a minio instance with cloudflare in front of it. I also re-deployed the discourse with a smaller vm but still enough resources to…

[图片] Eviepayne: underwent a large infrastructure change and now it’s not performing well. I migrated the database to be a managed database at digitalocean so reverse that? though perhaps others have tried this and will chime in with tips to improve that kind of setup.

Why is this unsupported? discourse has the options in the app.yml for external databases? I’m trying to scale a large server.

My bad, let me remove that for now :+1:

[图片] Eviepayne: I migrated the database to be a managed database at digitalocean How close is the managed database to your instance? Are they in the same network?

yeah the server is also DO. right now im going to do a bone-stock install with the supported guide and import the database I’ll see what happens then.

Is there a way to manually run those database migrations?

[图片] Eviepayne: I also re-deployed the discourse with a smaller vm but still enough resources to handle the load. But it sounds like your postgres server isn’t enough to handle the load? How big is your database? How much ram does your postgres server have? [图片] Eviepayne: I also re-depl…

Even a simple bare install isn’t working haven’t even restored the database at all. did a discourse-setup on a clean VM, and the registration isn’t working. Attempted to restore via commandline and discourse restore doesn’t list the backups. Edit: worked after a second complete rebuild.

在优化方面遇到困难

支持

renato (Renato Atilio) 2025 年3 月 29 日 17:33 6

托管数据库离您的实例有多近？它们在同一个网络中吗？

话题		回复	浏览量
Slow performance due to per query latency connecting to database? Self-hosting	9	818	2018 年9 月 11 日
Are there any commands that will speed up the site? Support	19	2267	2020 年12 月 2 日
PostgreSQL runaway IO Self-hosting	37	3098	2021 年3 月 17 日
Connection timed out while connecting to upstream on AWS Self-hosting hosting	12	3870	2016 年6 月 28 日
Long loading times for user summary page with slow database Self-hosting unsupported-install	19	1850	2023 年7 月 13 日

在优化方面遇到困难

相关话题