OrchardCore icon indicating copy to clipboard operation
OrchardCore copied to clipboard

Add SQL Server distributed services

Open Piedone opened this issue 1 month ago • 3 comments

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.

Piedone avatar May 23 '24 22:05 Piedone