Selective forwarding for multi-statement database transactions

A method, comprising:

• receiving, at a read-only node for a database, a write statement as part of a transaction started at the read-only node, wherein the read-only node is configured to perform only read statements;
• sending, by the read-only node, the write statement to a read-write node for the database, wherein the read-write node is a node distinct from the read-only node and configured to perform write statements;
• performing, by the read-write node, the write statement as a transaction to the database;
• receiving, by the read-only node, a read statement received as part of the transaction after the write statement;
• waiting, by the read-only node, to perform the read statement until after:
• receiving, at the read-only node, an acknowledgement of the performance of the write statement from the read-write node;
• and
• updating, by the read-only node, a read view of the database determined at the read-only node to include the write statement.

One or more non-transitory, computer-readable storage media, storing program instructions that when executed on or across one or more computing devices cause the one or more computing devices to implement:

• receiving, at a read-only node for a database, a write statement as part of a transaction started at the read-only node, wherein the read-only node is configured to perform only read statements;
• sending, by the read-only node, the write statement to a read-write node for the database, wherein the read-write node is a node distinct from the read-only node and configured to perform write statements;
• receiving, by the read-only node, a read statement received as part of the transaction after the write statement;
• waiting, by the read-only node, to perform the read statement until after:
• receiving, at the read-only node, an acknowledgment that the write statement was performed as part of a read-write node transaction to the database;
• and
• updating, by the read-only node, a read view of the database determined at the read-only node to include the write statement.