two servers replicated

  • Hi All,

    My scenario is two locations are there and this two different location

    servers are going too replicated.

    We are going to use the db servers as based on location. Example if users

    are accessing database which is located in India for them separate db server

    and users who are accessing database which is in USA for them separate

    database server. These both database will be replicated. If both location

    users are accessing single database is not a problem. If one link is down

    automatically another link will come up and users are able to access. If

    both links are up users are able to access to their database based on the

    location. Example if user is in India than he must be access only database

    which is in India.

    Here problem is if both links are up user can't access other location

    databases. What will happen if user in one location can access the database

    which is in another location? How to restrict users?

    Please suggest what complications we are going to face this type of

    situation.

  • The problem you described has nothing to do with replication but with software design. It is client-side responsibility to determine where to connect.


    * Noel

  • Other than replication;is there any way to do as per my doubt...

    can you please suggest

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply