We have an MVC5 application that is using using SingalR. The app is currently behind load balancer and we have a garden of servers. So, we are using the scaleout mechanism via SQL server backplane to make sure all nodes get the same notification. It is working well.
In the meantime, we have some operations that we are executing externally that would need to send a message to our servers. The operations are happening inside SQL server. So, I am thinking to have some kind of timer that keeps monitoring a table and when a certain condition occurs, it would broadcast the message. This can work but the timer need to occur on web apps and keeps pinging the db to check.
It feels wrong. Is there an alternative to that?
The SQL backplane is a black box. It would be great to write a record there and let SignalR carry it over..
Thanks,
question from:
https://stackoverflow.com/questions/66048067/external-messaging-signalr-db-webserver 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
