Geek Answers Handbook

Is Redis the best option for scaling SignalR over SQL Server and does each transition to a backup resource?

In the David Fowler blog, SQL Server has been added to the list of scaling providers for the service bus.

I am implementing Redis on our Windows servers. Based on what I know about Redis, I assume it will be significantly faster than using SQL Server - is this a fair guess?

If so, how is Windows Redis implementing fault tolerance?

+6
source share
2 answers

Based on what I know about Redis, I assume it will be significantly faster than using SQL Server - is this a fair guess?

It will be faster than SQL Server because it is optimized for memory-based operations, but its speed is not the only advantage. Support for advanced structures provides greater flexibility when working with different scenarios.

If so, how is Windows Redis implementing fault tolerance?

In the download section, there is a link to the unofficial redis port based on windows, which, however, is not intended for production use. The official version of redis supports replication and sentinel has an automatic switch to another resource, but it’s hard to say what state these functions are in the Windows port. In general, I would not recommend using redis on a Windows computer, but rather use a virtual machine with a linux distribution and run it there.

+4
source
  • Redis ~ x200 is faster than SQL, mainly because it is built into memory and the protocol is designed for speed.
  • If that helps, Redis Cloud is now offered on Windows Azure, and HA is a built-in service feature.

Disclosure - I am a co-founder and CTO of Garantia Data, a Redis Cloud service company.

+9
source

More articles:


All Articles