The road to ACID transactions in Cassandra 6

Cassandra 6.0, set to release later this year, introduces strictly serializable cross-partition ACID transactions through a new feature called Accord, representing a major evolution from the database's eventual consistency roots in 2013. The article demonstrates how to set up a three-node Cassandra cluster to test transactional workloads across four options: no transactions, BATCH updates, Lightweight transactions, and Accord transactions. While Cassandra has evolved from a schemaless NoSQL database to a SQL-like ACID transactional system, it maintains its characteristic query-based table modeling approach due to its lack of joins and automatic sharding.