How are rowstore tables persisted to disk?
Rowstore data is fully persistent on disk. Data updates on rowstore tables are performed in transaction blocks.
SingleStore rowstores include persistence with periodic snapshots of the in-memory data and a write-ahead transaction log stored on a file system to make them permanent.
The snapshot represents a consolidation of previous actions in the cluster, and the transaction log accumulates all actions taken after the last snapshot. When the SingleStore cluster restarts or recovers from a shutdown, rowstore data will be recovered and reloaded from the snapshots and logged back into memory. The in-memory state for the rowstore can be rebuilt without any data loss.