Workload capture and replay for replicated database systems

A method for implementation by one or more computer processors forming part of at least one computing device, method comprising:

• obtaining, by at least one computer processor, a workload capture file comprising execution context information generated based on execution of read statements and write statements in a database system, the workload capture file being replayable by the one or more computer processors to issue the read statements and the write statements based on the execution context information;
• generating, by at least one computer processor, a modified workload capture file by generating modified execution context information by associating routing information with read execution context information associated with one or more of the read statements of the obtained workload capture file, the modified workload capture file comprising hint based routing information defining a favored database for execution of the one or more read statements;
• and
• replaying, by at least one computer processor, the modified workload capture file by:
• generating at least one mutable read statement based on the modified workload execution information;
• issuing the at least one mutable read statement to a primary database system, the primary database system having an associated secondary database system;
• and
• determining, by the primary database system, based on the routing information, that the at least one mutable read statement is routable to the secondary database system for execution;
• routing, by the primary database system, responsive to determining that the at least one mutable read statement is routable to the secondary database system for execution, the at least one mutable read statement to the secondary database system for execution.