vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| >From: "Art S. Kagel" <art.kagel@gmail.com> ><SNIP> > >I knew that ;-) > >What I clearly missed what that the dude might be trying to implement >a distributed locking mechanism. Something Oracles particularly >expert <gag gag gag> at. ;-) > I guess I missed your sarcasm. ;-) (Oracle's locking is of no use, here....) Uhm, yeah Posix Compliant semaphores would be a good start. The idea that the OP had with using a database would work if you wanted to implement the semaphores using database tables for a backing store. (Storing the lock requests, and the locks in two different tables.) Here you're not actually locking the resource, but trusting that your BPs all comply and use the centralized locking service. To take it a step further, you could then put a lock manager (would have to run as root) on each of your linux/unix servers that you wanted to secure resources. Then you'd be able to actually lock the files. The only catch is that there's a small window of time where the lock manager releases a file and the application takes control that a different non-compliant process could take control of the file resource. (Small window, but it could be exploited.) Its an interesting problem ... __________________________________________________ _______________ http://liveearth.msn.com |