Geek Answers Handbook

Transactional Priority / Deactivation

I need to organize events and tasks for external systems in a reliable / transactional way. Using things like MSMQ or ActiveMQ seems very enticing, but the transactional part becomes complicated (MSDTC, etc.).

We could use a database (SQL Server 2005+, Oracle 9+) and achieve simplified transactional support, but part of the queue becomes more ugly.

No route seems so beautiful and filled with unpleasant errors and extremes.

Can anyone offer practical guidance on this?

Think about it: an E / C / A or a scheduled task engine that wakes up so often and sees if there are scheduled tasks to be completed at that time (i.e., the date the next launch has passed, but the expiration date has not yet been reached).

+5
source share
6 answers

our system has 60 computers, each of which performs 12 tasks (threads) that should "get the next job." In general, this amounts to 50 thousand jobs per day. do the math from how many transactions per minute and realize the task time is a variable, so you can get several "pop events" at the same time.

MSMQ. : . , 2 . .

: MSMQ , , .

Deal breaker: , , , - " BLUE-" " ". !

B: Q SQL 2005.

, 200 . , . "" , .

catch: SQL, . , . 2 SQL , . :

SELECT TOP 1 @Id = callid
FROM callqtbl WITH (READPAST, XLOCK)
where 1=1 ORDER BY xx,yy
+5

, MSMQ , - SCope , , . , ActiveMQ, , MSMQ , .

, , .NET , MSMQ (, , )

nServiceBus: www.nservicebus.com

: http://code.google.com/p/masstransit/

, Oren Eini , . , , MSMQ, MSMQ.

: http://ayende.com/Blog/archive/2008/08/01/Rhino.Queues.Storage.Disk.aspx

, SQL Server 2005 , SQL Server Service Broker, SQL Server, , , SSB .

, , , nSErviceBus. Udi Dahan , , , , . : http://tech.groups.yahoo.com/group/nservicebus/

+4

Quartz.Net - .

+1

, MSMQ . , "Service Broker" SQL Server - " SQL", "csmba" , SQL Server, .

+1

Is there a WebSphere MQ (MQ Series) option? Supports transactional messaging.

0
source

You can look at the Oracle function called Extended Queue

0
source

More articles:


All Articles