I am confused on a design architecture using a SQL server as a back-plane. My question is can I use Redis as a back-plane and also have SQL serving my user information separate from SignalR messages.
I am just very lost on where my SQL server database would fit into this diagram. Is it as simple as just adding my connection string in the web config and when the user needs to hit the db it does, but is always connected to Redis for SignalR? Or is that design architecture not possible because the backplane is the end point of all data being sent?
One last thing I would like to ask is if I end up just using SQL as my scale out design with signalr. If at some point the back-plane becomes a bottleneck, how does that scale? Is my only option to scale vertically or horizontally?
Please look at this new image of the diagram,
Yes, you can use Redis as the backplane for scaling out SignalR and also use SQL Server as your app database.
I'm sure you've looked at this site which explains the various ways to scale out SignalR. There's a multiple-step process described on the SQL Server page on how to configure a database and web apps to use to scale out SignalR.
SignalR is designed to be scaled out (horizontally) using one of three options mentioned in the URL above.