This illustration shows the two steps required for grabbing the token.
Step 1: Identify True Owner
The replication site acct_ny.ny.example.com
wants ownership of the row for the employee whose empno
is 100
.
The acct_ny.ny.example.com
site determines the current owner of the row by querying the headquarters database, which is acct_hq.hq.example.com
.
The acct_ny.ny.example.com
site determines that current owner for the row is the site acct_sf.sf.example.com
.
Step 2: Grab Ownership and Broadcast Change
The replication site acct_ny.ny.example.com
locks the row locally and synchronously updates both the acct_ny.ny.example.com
site and the acct_sf.sf.example.com
site, making the owner of the row acct_ny.ny.example.com
at both sites.
The acct_ny.ny.example.com
site asynchronously updates all other replication sites to make the owner of the row acct_ny.ny.example.com
.