SingleStore DB

Aggregator Failover
Primary Cluster Master Aggregator Failure

If the master aggregator on the primary cluster fails, no changes to reference data or database schemas can be made. DML changes to distributed tables can be made through the child aggregators, and these changes are replicated to the secondary cluster.

If you can bring the master aggregator back online, replication of reference data and database schema changes will automatically continue. Otherwise, you can failover to a child aggregator using PROMOTE AGGREGATOR … TO MASTER.

Secondary Cluster Master Aggregator Failure

If the master aggregator on the secondary cluster fails, no changes to reference data or database schemas on the primary cluster will be replicated to the secondary cluster. DML changes to distributed tables can be made through the child aggregators on the primary cluster, and these changes are replicated to the secondary cluster.

If you can bring the master aggregator back online, replication of reference data and database schema changes from the primary cluster will automatically continue. Otherwise, you can failover to a child aggregator using PROMOTE AGGREGATOR … TO MASTER.