Apache Cassandra Topics

Syniti Data Replication supports use of Apache Cassandra for:

  • Refresh replications, as a source and target
  • Mirroring replications,as a target.

When setting up Apache Cassandra for use with Syniti Data Replication, there are no specific settings required, other than adequate database permissions.

Use of Primary Keys

Syniti Data Replication manages INSERT, UPDATE and DELETE operations using primary keys to identify records. For Cassandra, this works as follows:

  • Cassandra partition keys are used as primary keys for inserting/updating/deleting data in the Cassandra target.
  • Syniti DR does not store clustering key values for a table in the metadata.
  • If an insert is performed on a table with a primary key that already exists in a table, Cassandra does not throw a primary key violation error, rather it overwrites the existing row with the new values.
  • If replicating using Refresh with a Refresh Target Filter property in the Replication Properties, you must use a primary key column in the WHERE clause with an “=” or “IN” operator. This is because arbitrary WHERE clauses are not supported in CQL(Cassandra Query Language).

Further Resources