Databases
StackOverflow2013
Postsdbo
PODistributed Concurrency Control
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODistributed Concurrency Control
    primarykey
    data
    text
    <p>I've been working on this for a few days now, and I've found several solutions but none of them incredibly simple or lightweight. The problem is basically this: We have a cluster of 10 machines, each of which is running the same software on a multithreaded ESB platform. I can deal with concurrency issues between threads on the same machine fairly easily, but what about concurrency on the same data on different machines? </p> <p>Essentially the software receives requests to feed a customer's data from one business to another via web services. However, the customer may or may not exist yet on the other system. If it does not, we create it via a web service method. So it requires a sort of test-and-set, but I need a semaphore of some sort to lock out the other machines from causing race conditions. I've had situations before where a remote customer was created twice for a single local customer, which isn't really desirable.</p> <p>Solutions I've toyed with conceptually are:</p> <ol> <li><p>Using our fault-tolerant shared file system to create "lock" files which will be checked for by each machine depending on the customer</p></li> <li><p>Using a special table in our database, and locking the whole table in order to do a "test-and-set" for a lock record.</p></li> <li><p>Using Terracotta, an open source server software which assists in scaling, but uses a hub-and-spoke model.</p></li> <li><p>Using EHCache for synchronous replication of my in-memory "locks."</p></li> </ol> <p>I can't imagine that I'm the only person who's ever had this kind of problem. How did you solve it? Did you cook something up in-house or do you have a favorite 3rd-party product?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAnony-Mousse
    1. USBob Gettys
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODistributed Concurrency Control
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODistributed Concurrency Control
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODistributed Concurrency Control
      1. This table or related slice is empty.
      1. VTUpMod
    1. CORather than test-and-set, could the responsibility for ensuring that there are not any duplicate be moved into the service that creates new customers?
      singulars
      1. PODistributed Concurrency Control
      1. USJohn Channing
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload