Mechanisms for handling writes in distributed database system

A non-transitory computer-readable medium having program instructions stored thereon that are capable of causing a computer system to implement a log tailer that performs operations comprising:

• receiving a write request to perform a first write to write a base record to a database table of a database as part of a database transaction;
• generating one or more additional records to write based on dependencies associated with the base record, wherein the one or more additional records include a set of updates to a set of indexes built on the database table;
• buffering, in a memory buffer allocated in association with the database transaction, the base record and the one or more additional records as a first plurality of records;
• issuing, to a log owner of a database system that includes the log tailer, the first plurality of records as a single batch to the log owner via a single network request to update a transaction log based on the first write and insert the first plurality of records into a memory structure of the log owner;
• and
• receiving, from the log owner, a response indicating whether the log owner successfully updated the transaction log and inserted the first plurality of records.

A system, comprising:

• at least one processor;
• and
• memory having program instructions stored thereon that are executable by the at least one processor to implement a log tailer that performs operations comprising:
• replaying database operations logged in a transaction log that is managed by a log owner of a database system that includes the log tailer;
• receiving a write request to perform a first write to write a base record to a database table of a database as part of a database transaction;
• generating one or more additional records to write as a result of having to write the base record, wherein the one or more additional records include a set of updates to a set of indexes built on the database table;
• buffering the base record and the one or more additional records in a memory buffer as a first plurality of records;
• issuing the first plurality of records as a single batch to the log owner via a single network request to update the transaction log based on the first write;
• and
• receiving, from the log owner, a response indicating whether the transaction log was successfully updated.