Filter
Top Products
Starting and Setting Up RTR
2.12 How RTR Selects Processing-states (Roles) for Nodes
The SHOW PARTITION command on each backend node is as follows:
Backend partitions on node BRONZE in group "test" at Mon Mar 22 14:52:32 1999
Partition name: p1
Facility: RTR$DEFAULT_FACILITY State: pri_act
Low bound: 0 High bound: 4294967295
Active servers: 0 Free servers: 1
Transaction presentation: active Last Rcvy BE: gold
Active transaction count: 0 Transactions recovered: 0
Failover policy: fail_to_standby Key range ID: 16777217
Master router: silver Relative priority: 1
Features: Shadow,NoStandby,Concurrent
Backend partitions on node GOLD in group "test" at Mon Mar 22 14:54:12 1999
Partition name: p1
Facility: RTR$DEFAULT_FACILITY State: sec_act
Low bound: 0 High bound: 4294967295
Active servers: 0 Free servers: 1
Transaction presentation: active Last Rcvy BE: bronze
Active transaction count: 0 Transactions recovered: 0
Failover policy: fail_to_standby Key range ID: 16777216
Master router: silver Relative priority: 2
Features: Shadow,NoStandby,Concurrent
The following description shows how sequence numbers are initially assigned in a
simple partition with two backends named Bronze and Gold, and a router named
Silver.
Router
Backend A
Backend B
1
2
3
4
6
7
8
5
1. A partition (with shadowing enabled) is started on node Bronze.
2. The partition on Bronze obtains sequence number 1 from the router and
becomes the primary.
3. Another server on the same partition (with the same attributes) is started on
Gold.
4. The partition on Gold obtains sequence number 2 from the router and
becomes the secondary.
5. Node Bronze crashes and reboots (the partition sequence number on Bronze
is reset to 0). The partition on Gold goes into Remember.
6. When the server starts, The partition on Bronze obtains sequence number 3
from the router and becomes the secondary, Gold now becomes the primary.
7. The network connection from node Silver to node Gold fails. The partition on
Bronze becomes the primary. The partition on node Gold loses quorum and is
in a wait-for-quorum state.
Starting and Setting Up RTR 2–19