OK, here's my problem:

I have a script which accesses the DB, and which can be started in the
background from my TG web application (The script also uses my app's
model).  I want to prevent this script from being simultaneously
executed more than once.  Problem is, the web app may be replicated
across a number of load-balanced servers.  So, what mechanism can I use
to prevent simultaneous execution.  The only things shared by my
replicated apps would be the DB server, and memcached.

Does SQLObject contain any facilities at all for setting up these sort
of locks (other than discreet test and set operations on a DB row)?
Does memcached?

Thanks,

Stuart


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---

Reply via email to