Automatically changing a database system's redo transport mode to dynamically adapt to changing workload and network conditions

摘要

Techniques for automatically changing the mode used in a primary database system to transport redo to a standby database system in response to changing workload and network conditions. The techniques are implemented in a database system that has a constraining redo transport mode that can potentially constrain the rate at which the primary database system can process transactions and a nonconstraining redo transport mode which does not constrain the primary but has a higher probability of redo loss than the constraining redo transport mode. The techniques use the constraining redo transport mode as a measuring transport mode to determine whether a switch from one mode to the other is desirable either to increase the throughput of the primary database system or to decrease the probability of the loss of redo data.