Orchestrator Read-only Replica

Orchestrator maintains a read-only replica of its read-write operational database, with the main purpose of improving performance. Some read-only workloads are directed towards the read-only replica, so as to optimize write-replica consumption. This allows data to be read and loaded faster, which, in turn, ensures the performance of your system.

As a result of this implementation, a slight delay between the write and read actions might occur. This is to be expected, and has no impact on data becoming available.

An example of this scenario is retrieving a queue item as soon as it was added: when performed from the interface, the new queue items might not be displayed instantly, as there is a slight asynchronicity between the operational database (where the item is written) and the replica (which is called for reading the item). You can, however, avoid this by using the Get transaction item activity instead of Get queue items, since the former includes the queue item in its response.

Retrieving queue items

Queue items data can be retrieved from the read-only replica.

You can enable this through the Features.Queues.QueryUseReadOnlyReplica parameter in the UiPath.Orchestrator.dll.config file. Details...

Orchestrator monitoring

Data used to display your monitoring views can be retrieved from the read-only replica.

You can enable this through the Monitoring.UseReadOnlyReplica parameter in the UiPath.Orchestrator.dll.config file. Details...