Abstract: Systems and methods are provided for receiving a request at a database system that includes a primary node and one or more standby nodes. When the request is determined to be a read-only request and the previous transaction has been replicated to the standby node, the request may be transmitted to one of the one or more standby nodes to perform the read-only operation to retrieve data of the request and transmitting the retrieved data. When the request is determined to be a read-only request and the previous transaction has not been replicated to the standby node, the read-only operation is performed to retrieve data of the request from the primary node and transmitting the retrieved data.

Abstract: System and methods are provided for modifying, at a server that is communicatively coupled to a database system that includes a primary node and one or more standby nodes, a class of an application program to route a request that is a read-only request to the database system to the one or more standby nodes of the database system. The application program may receive an input that executes an operation of the modified class of the application program. A read-only request may be transmitted to the database system for data to complete executing the operation of the modified class. The read-only request may be routed to one of the standby nodes to handle the read-only request for the data. The standby node may transmit the retrieved data to the server for the operation of the modified class to complete the execution of the operation for the application program.