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. 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.