SingleStore DB

Using Synchronous Replication and Synchronous Durability Together

You can use a database with both synchronous replication and synchronous durability enabled. In this case, database updates that you make using DDL and DML commands will commit after the following steps have completed:

  1. The updates are made, in-memory, on the master partitions.

  2. The updates on the master partitions are replicated to the replica partitions.

  3. The updates on the master partitions are written to disk.

  4. The updates on the replica partitions are written to disk.

Step two does not block step three; both steps can run in parallel.