No. CFLOCK (and all other tags) run locally on each server, and are not aware of
other CFLOCKS on other CF servers.
If you want them to all wait in line, the best solution may be to use a CFTRANSACTION
around your table check to block the other servers out of that DB table/row till your
DB timestamp has been updated.
-Cameron
I have 3 mirrored servers accessing the same SQL-Server DB. They
are all running an agent that retrieves news and weather. For
redundantcy, They are each running the agent. I have set up a
table that keeps track of the last time the agent ran and each
server will check the table first before trying to run the agent.
If the agent has ran in the last 30 min it will abort.
These servers will all be synched up, and as such, they will
be trying to run these agents at the exact same time. So I thought
I would just put a cflock around the read and make the servers
get in line and the first one to the server wins.
Heres the question: Will this work? Will this lock reads by other
servers?
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
