Are Insert / update operations ACID?

General
1

Below is the schema in yugabyte DB:

ycqlsh:example> CREATE TABLE users(user_id INT PRIMARY KEY, full_name TEXT) WITH default_time_to_live = 0 AND transactions = {'enabled': 'false'};     

ycqlsh:example> CREATE TABLE entities(entity_id INT PRIMARY KEY, full_name TEXT) WITH default_time_to_live = 0 AND transactions = {'enabled': 'false'};

Version:

[ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]

Queries are initiated through multiple threads in the app

Does insert/update queries on users & entities table ensure ACID properties?

2

Hi @sham_yuga

Yes they are. Both single row and multi row transactions: Design goals | YugabyteDB Docs

3

A quick followup on your query sham_yuga:

In order to participate in multi-shard distributed transactions, you must set the property transactions = { ‘enabled’ : ‘true’ } on your table definition. Otherwise, the table will only have transactional guarantees for single shard transactions.

–Alan

4

@Alan_Caldera
When you say multi-shard transactions,
Do you mean shard one of users table and shard two of entities table?

5

@sham_yuga multi-shard means 2+ tablets. They may be of the same table or from different tables.