Controlling azure worker roles concurrency in multiple instance

Posted by NER1808 on Stack Overflow See other posts from Stack Overflow or by NER1808
Published on 2011-01-13T18:07:53Z Indexed on 2011/01/13 23:53 UTC
Read the original article Hit count: 330

Filed under:

Azure

|

sql-azure

|

azure-worker-roles

I have a simple work role in azure that does some data processing on an SQL azure database. The worker basically adds data from a 3rd party datasource to my database every 2 minutes. When I have two instances of the role, this obviously doubles up unnecessarily. I would like to have 2 instances for redundancy and the 99.95 uptime, but do not want them both processing at the same time as they will just duplicate the same job. Is there a standard pattern for this that I am missing? I know I could set flags in the database, but am hoping there is another easier or better way to manage this. Thanks

© Stack Overflow or respective owner

Related posts about Azure

Azure Mobile Services: what files does it consist of?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Azure Mobile Services is a platform that provides a small set of functionality consisting of authentication, custom data tables, custom API’s, scheduling scripts and push notifications to be used as the back-end of a mobile application or if you want, any application or web site. As described in my… >>> More
Windows Azure: Backup Services Release, Hyper-V Recovery Manager, VM Enhancements, Enhanced Enterprise Management Support

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This morning we released a huge set of updates to Windows Azure. These new capabilities include: Backup Services: General Availability of Windows Azure Backup Services Hyper-V Recovery Manager: Public preview of Windows Azure Hyper-V Recovery Manager Virtual Machines: Delete Attached… >>> More
Azure - Part 4 - Table Storage Service in Windows Azure

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
In Windows Azure platform there are 3 storage we can use to save our data on the cloud. They are the Table, Blob and Queue. Before the Chinese New Year Microsoft announced that Azure SDK 1.1 had been released and it supports a new type of storage – Drive, which allows us to operate NTFS files on the… >>> More
Azure - Unable To Get SQL Azure Invitation Code!

as seen on Stack Overflow - Search for 'Stack Overflow'
Scenario I'm trying to convert my Silverlight Business Application over to the cloud with the help of Azure. I have been following this link from Brad Abrams blog. Both the links to Windows Azure and SQL Azure crash out in Google Chrome, they work in Internet Explorer, but it's literally one of… >>> More
Problem in working with async and await?

as seen on Programmers - Search for 'Programmers'
I am trying to upload files to Azure Blob Storage and after successful upload adding the filename to a list for my further operation. When i am doing synchronous it works fine but when i am doing async the error occured. Error : Collection was modified; enumeration operation may not execute. foreach(var… >>> More

Related posts about sql-azure

Windows Azure Learning Plan - SQL Azure

as seen on SQL Blog - Search for 'SQL Blog'
This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here. This one deals with Security for Windows Azure. Overview and Training Overview and general information about SQL Azure - what it is, how it works, and where you… >>> More
Which ORM to use with SQL Azure?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just wondering what everyones thoughts on what ORM to use for SQL Azure? I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future… >>> More
Is MARS available in sql-Azure

as seen on Stack Overflow - Search for 'Stack Overflow'
Is MARS available in sql-Azure >>> More
SQL Azure table size

as seen on Stack Overflow - Search for 'Stack Overflow'
In mssql2005 when i want to get size of table in MBs, i use EXEC sp_spaceused 'table'. Is there any way to get space used by particular table in SQL Azure using some query or API? >>> More
Calling SQL Azure's stored procedure in silverlight

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a silverlight application to call the SQL Azure's stored procedure and show the data. I use the service to call stored procedure, and it is working when it is run at VS 2008. But when I integrate in php page, the data is not shown. I think the service is not running. How can I call SQL Azure… >>> More