|
Load balancing method
|
TF level: Not specified or NONE
|
TF level: CONNECTION
|
TF level: SESSION
|
|---|---|---|---|
|
Not specified
|
▪ No failover or switchover support
▪ No load balancing (Basic connectivity)
|
▪ Transparent failover (session state not preserved)
▪ Transparent switchover
▪ Workload in primary server only
▪ No load balancing
|
▪ Transparent failover (session state preserved)
▪ Transparent switchover
▪ Workload in primary server only
▪ No load balancing
|
|
WRITE_MOSTLY (default)
|
▪ No transparent failover support
▪ Transparent switchover
▪ Workload in primary server only
▪ No load balancing
|
▪ Transparent failover (session state not preserved)
▪ Transparent switchover
▪ Workload in primary server only
▪ No load balancing
|
▪ Transparent failover (session state preserved)
▪ Transparent switchover
▪ Workload in primary server only
▪ No load balancing
|
|
READ_MOSTLY
|
▪ No transparent failover support
▪ Transparent switchover
▪ Workload in primary and secondary servers
▪ Load balancing
|
▪ Transparent failover (session state not preserved)
▪ Transparent switchover
▪ Workload in primary and secondary servers
▪ Load balancing
|
▪ Transparent failover (session state preserved)
▪ Transparent switchover
▪ Workload in primary and secondary servers
▪ Load balancing
|
|
LOCAL_READ
(ODBC connections only)
|
▪ No transparent failover support
▪ Transparent switchover
▪ Reads and writes executed locally on primary server by using SMA connection
▪ Reads executed locally on secondary server by using SMA connection, writes executed on primary server by using network connection
|
▪ Transparent failover (session state not preserved
▪ Transparent switchover
▪ Reads and writes executed locally on primary server by using SMA connection
▪ Reads executed locally on secondary server by using SMA connection, writes executed on primary server by using network connection
|
▪ Transparent failover (session state preserved
▪ Transparent switchover
▪ Reads and writes executed locally on primary server by using SMA connection
▪ Reads executed locally on secondary server by using SMA connection, writes executed on primary server by using network connection
|