Product Sheet: Active-Active Replication with Assure MIMIX HA
The Active-Active feature of Assure MIMIX HA facilitates replication between two or more active production servers by accessing the database using keyed replication rather than traditional positional replication.
Assure MIMIX HA Active-Active Replication supports replication between two active production servers for switch times measured in seconds and workload balancing.
Simply put, instead of using row numbers to update or delete replicated data in a target table, keyed replication uses the row’s unique key. That unique key is comprised of one or more fields in the table that uniquely identify each record. The use of keyed replication ensures that the data on all active servers is identical, even if the row numbers differ due to concurrent distributed insertions and deletions.