On this page
The replication process forms an essential part of a disaster recovery (DR) plan.
SingleStore replicates data in the following situations.
The diagram below shows what happens when an async alert is raised at the partition level.
With high availability redundancy-2 replication, you can specify, using the CREATE DATABASE, RESTORE DATABASE and ALTER DATABASE commands, whether replication from master to replica partitions is synchronous or asynchronous.
Synchronous replication is usually no more than ten to twenty percent slower than asynchronous replication.
If a database is using synchronous replication and its replica partition fails to respond within five seconds, the replica partition switches to asynchronous replication; this allows the replica partition to not block the current and future replication transactions.
The replica partition becomes responsive.
The master partition becomes responsive, if it was previously unresponsive.
When the replica partition resumes failover, it switches to synchronous replication.
When you use the REPLICATE DATABASE command, you can only replicate asynchronously.
Last modified: September 8, 2022