im working with four app servers and two database instances (3DNS and BigIP determine what app server a user is directed to based on usage etc). Two app servers per database node. The database instances stay synchronized using replication.

However, when a new user first visits the application it uses SSO to get a their identification and automatically registers that user. This is a problem if say the user opens two browser at the same time , both pointing to my application. The app will try to register the user on both databases, then when replication runs it will throw a unique constraint exception.

Is there any way to manage database access in this type of architecture so that certain tables, like user registration, can only be accessed if a flag has been obtained?

thanks, any suggestions would be helpful.


Yes, with row-level locking, however I am not sure if this question is appropriate for SF or should be moved to SO? Seems like an app architecture thing, regardless of the underlying setup and/or hardware.

| improve this answer | |
  • cheers will move – cdugga Nov 16 '10 at 17:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.