search

OrchardCMS / OrchardCore

Orchard Core is an open-source modular and multi-tenant application framework built with ASP.NET Core, and a content management system (CMS) built on top of that framework.
https://orchardcore.net
BSD 3-Clause "New" or "Revised" License
7.22k stars 2.34k forks source link

Add SQL Server distributed services #16149

Open Piedone opened 1 month ago

Piedone commented 1 month ago

Is your feature request related to a problem? Please describe.

Currently, you need Redis for multi-node hosting. This complicates the hosting infrastructure, and ideally, we wouldn't need Redis.

Describe the solution you'd like

When using SQL Server, we could also use the Distributed SQL Server Cache for distributed caching instead. Currently, that doesn't necessarily work out of the box.

Similarly, we could have distributed locking and a message bus implementation with SQL Server (Orchard 1 actually has that). Maybe also a Data Protection store, but I consider that less of an issue, since there are alternatives for that already (Azure Blob, and you can use the local file system too if you map it to a shared drive).

Describe alternatives you've considered

Hisham's Garnet module covers a similar aim with Garnet, but that also needs a separate service.

hishamco commented 1 month ago

I might be interested in this, but for messaging we could use Azure Bus

Piedone commented 1 month ago

That can be a solution that works for certain use cases, but this is specifically about not having to set up any further external service.

github-actions[bot] commented 1 month ago

We triaged this issue and set the milestone according to the priority we think is appropriate (see the docs on how we triage and prioritize issues).

This indicates when the core team may start working on it. However, if you'd like to contribute, we'd warmly welcome you to do that anytime. See our guide on contributions here.