Using average replication latency to influence routing query transactions

A data processing system, comprising:

• a first site configured to process data;
• a second site configured to process data;
• a transaction replay program configured to send a copy of data from the first site to the second site;
• and
• a processor configured to:
• define a maximum replication latency threshold and a reset threshold for the system,
• estimate a replication latency of a workload in the system, and
• switch the system to an acute replication latency state when the estimated replication latency rises above the maximum replication latency threshold and switch out of the acute replication latency state when the estimated replication latency falls below the reset threshold.

A method of operating a system of independent processing sites, comprising:

• defining, using a processor, a maximum replication latency threshold and a reset threshold of the system;
• estimating a replication latency of a workload in the system;
• switching the system to a first replication latency state when the estimated replication latency rises above the maximum replication latency threshold;
• and
• switching the system out of the first replication latency state to a second replication latency state when the estimated replication latency falls below the reset threshold.