Sql server scale out MessageBus #232

Closed
davidfowl opened this Issue Mar 8, 2012 · 17 comments

8 participants

@davidfowl
SignalR member

Cuz sql is everywhere!!!!!

@DamianEdwards DamianEdwards was assigned Mar 8, 2012
@DamianEdwards
SignalR member

That's different to SQL Server Query Notifications, which are based on Service Broker and still supported.

@ElanHasson

I am happy I was wrong :)

Less work now :)

@ElanHasson

@DamianEdwards I am interested in helping with this if you would like...

@ElanHasson

@Porkstone that is interesting.. I'll investigate it.

Thanks.

@davidfowl
SignalR member

Not sure if this is going to make it for 0.5. Currently at risk.

@ElanHasson

i have not been able to implement this as of yet..

@DamianEdwards @davidfowl said you had already started coding this..is that accurate? or do I own this task?

@pikou

+1

@paigecook

Is there any update on where this feature stands?

@davidfowl
SignalR member

0.6 which is months out.

@ElanHasson

@davidfowl I have to build this anyway. I really need it sooner than 0.6.

Is this just following the reddis MessageBus implementation?

Please provide me with some additional info so that i may get this going.

@davidfowl
SignalR member

@ElanHasson if you want to take a stab at it yes, start from the redis implementation. Here's the flow:

  • You can implement the IIdGenerator and generate ids using an identity column in some table (see redis)
  • Data comes through the bus (via Send) and you put it into the backplane (sql server)
  • When a change notification comes from the backplane you put it into the in memory bus (see redis)
@ElanHasson

ok. will do.

I'll make it auto setup and tare down the SSB stuffs like SqlDependency.

@dove

@ElanHasson how'd you get on? I'd also be interested in this. Would be happy to help if I can.

@davidfowl
SignalR member

We have a first cut of this here https://github.com/SignalR/SignalR/blob/master/SignalR.SqlServer/SqlMessageBus.cs. Definitely not ready for prime time as yet, but it'll definitely be ready for sometime in the 1.0 release.

@paigecook

This looks very promising. I pulled down the latest code and had to make a little tweak to the SqlReciever.cs to get this to work for me locally. It was having issues when my SignalR_Messages table was empty. You can see it here
https://github.com/paigecook/SignalR/blob/master/SignalR.SqlServer/SqlReceiver.cs

I know this is very early in development and will likely change a lot before it is ready for prime time, but wanted to provide the feedback. If you want a pull request let me know. Keep up the great work, excited about having SqlServer MessageBus support in SignalR.

@Xiaohongt Xiaohongt closed this Oct 5, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment